Hi,
I am extremely new to macros and I am trying to create a macro that will copy paste a value from a spreadsheet called numbers.xlsm to a new spreadsheet called vlookup template.xlsm. In vlookup template.xlsm there are a series of vlookup functions. I want the value from numbers.xlsm to be pasted to the lookup value column in vlookup template.xlsm.
Then I want the macro to copy output produced by the vlookup functions and paste it into a new spreadsheet called demographics.xslm
I want the macro to loop for every value in numbers.xlsm
I am not even sure if this is possible but I would greatly appreciate any help.
Here is an example to clarify what I would like
numbers.xlsm vlookup template.xlsm demographics.xslm
1001- copy 1001-paste ( D 51 left )- Copy ( D 51 left )- Paste
these values are from vlookup
I am extremely new to macros and I am trying to create a macro that will copy paste a value from a spreadsheet called numbers.xlsm to a new spreadsheet called vlookup template.xlsm. In vlookup template.xlsm there are a series of vlookup functions. I want the value from numbers.xlsm to be pasted to the lookup value column in vlookup template.xlsm.
Then I want the macro to copy output produced by the vlookup functions and paste it into a new spreadsheet called demographics.xslm
I want the macro to loop for every value in numbers.xlsm
I am not even sure if this is possible but I would greatly appreciate any help.
Here is an example to clarify what I would like
numbers.xlsm vlookup template.xlsm demographics.xslm
1001- copy 1001-paste ( D 51 left )- Copy ( D 51 left )- Paste
these values are from vlookup
