Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro to copy data X number of times into a column
Hello,
New to Excal/VBA and need a little help for a macro I've been trying to create. I've tried a few things and looked around numerous places however cannot find the solution to my problem. I am currently using 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 are pasted into the document from another spreadsheet. The data is located from A6:G? (where ? will vary from day to day). - Sheet2 contains a list of names in columnA (number of names will vary 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 names from Sheet2 columnA into Sheet1 columnH (starting at H6) based on the number which is in Sheet2 columnC. Essentially, I am trying to 'assign' the items in Sheet1 to the people in Sheet2 based on the number entered. Example: Sheet1 ColA:G ColH item1 Name1 item2 Name1 item3 Name2 item4 Name3 item5 Name3 item6 Name3 Sheet2 ColA ColC Name1 2 Name2 1 Name3 3 Thanks for any help you can provide! Last edited by WSD : August 31st 12 at 04:48 PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy exactly the I number of times that he/she appears in the column | Excel Programming | |||
Copy a row down a column for the same number of rows of data in another workshee | Excel Programming | |||
Copy a row down a column for the same number of rows of data in another workshee | Excel Programming | |||
how do i copy down x number of times | Excel Worksheet Functions | |||
Copy a formula down a set number of times | Excel Worksheet Functions |