Hi All,
Looking to see if anyone could help, I am very new to vba so any help is appreciated.
I have two files that will each change each month (new lan locations each month but kinda beyond what I am asking). Anyway, I want to link file A to file B in a few cells.
What I am trying to do is implement some vba code to move the link down one row everytime I click to code.
So...
File A originally would be as below.
Cell F4 = [FileB]'Sheet1'!A2
F5 = [FileB]'Sheet1'!B2
I would then click the macro so that...
F4 = [FileB]'Sheet1'!A3
F5 = [FileB]'Sheet1'!B3
And so on, everytime I click the macro it moves the link one row down. I would think this is possible and simple enough but I have no idea what I am doing so no luck so far. Any help would be great.
Thanks,
Looking to see if anyone could help, I am very new to vba so any help is appreciated.
I have two files that will each change each month (new lan locations each month but kinda beyond what I am asking). Anyway, I want to link file A to file B in a few cells.
What I am trying to do is implement some vba code to move the link down one row everytime I click to code.
So...
File A originally would be as below.
Cell F4 = [FileB]'Sheet1'!A2
F5 = [FileB]'Sheet1'!B2
I would then click the macro so that...
F4 = [FileB]'Sheet1'!A3
F5 = [FileB]'Sheet1'!B3
And so on, everytime I click the macro it moves the link one row down. I would think this is possible and simple enough but I have no idea what I am doing so no luck so far. Any help would be great.
Thanks,