W
WSD
Hello
New to Excal/VBA and need a little help for a macro I've been trying t
create. I've tried a few things and looked around numerous place
however cannot find the solution to my problem. I am currently usin
Excel 2010, but will require this to work in Excel 2003 if possible
I have 2 Excel Sheets
- Sheet1 will contain data/item that change on a daily basis and ar
pasted into the document from another spreadsheet. The data is locate
from A6:G? (where ? will vary from day to day)
- Sheet2 contains a list of names in columnA (number of names will var
on an occasional basis) and a list of corresponding numbers in columnC
I am trying to create a macro that will copy, multiple times, the name
from Sheet2 columnA into Sheet1 columnH (starting at H6) based on th
number which is in Sheet2 columnC
Essentially, I am trying to 'assign' the items in Sheet1 to the peopl
in Sheet2 based on the number entered
Example
Sheet
ColA:G Col
item1 Name
item2 Name
item3 Name
item4 Name
item5 Name
item6 Name
Sheet
ColA Col
Name1
Name2
Name3
Thanks for any help you can provide
New to Excal/VBA and need a little help for a macro I've been trying t
create. I've tried a few things and looked around numerous place
however cannot find the solution to my problem. I am currently usin
Excel 2010, but will require this to work in Excel 2003 if possible
I have 2 Excel Sheets
- Sheet1 will contain data/item that change on a daily basis and ar
pasted into the document from another spreadsheet. The data is locate
from A6:G? (where ? will vary from day to day)
- Sheet2 contains a list of names in columnA (number of names will var
on an occasional basis) and a list of corresponding numbers in columnC
I am trying to create a macro that will copy, multiple times, the name
from Sheet2 columnA into Sheet1 columnH (starting at H6) based on th
number which is in Sheet2 columnC
Essentially, I am trying to 'assign' the items in Sheet1 to the peopl
in Sheet2 based on the number entered
Example
Sheet
ColA:G Col
item1 Name
item2 Name
item3 Name
item4 Name
item5 Name
item6 Name
Sheet
ColA Col
Name1
Name2
Name3
Thanks for any help you can provide