tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I'm looking for a macro that can do the following,
I have a sheet called "Product Data"
The headers are in Row 3 so the data starts at row 4
The data range is A4:Z (last row)
Now each row is a different product,
in Column H "Number of Colours" is a number, it can be any number from one up (If cell is blank assume 1)
what I would like is a macro that when run
goes through each Row checks the Number in Column H for that row and makes that many copies into Sheet "Colours" Column A and first empty row,
So If I was writing this in English it would read something like this
For each row in sheet "Product Data" range A4:Zand last row
take the number from column H and copy Row, and paste it that many times in Sheet "Colours" Column A and first empty row,
Please help if you can,
Thanks
Tony
I'm looking for a macro that can do the following,
I have a sheet called "Product Data"
The headers are in Row 3 so the data starts at row 4
The data range is A4:Z (last row)
Now each row is a different product,
in Column H "Number of Colours" is a number, it can be any number from one up (If cell is blank assume 1)
what I would like is a macro that when run
goes through each Row checks the Number in Column H for that row and makes that many copies into Sheet "Colours" Column A and first empty row,
So If I was writing this in English it would read something like this
For each row in sheet "Product Data" range A4:Zand last row
take the number from column H and copy Row, and paste it that many times in Sheet "Colours" Column A and first empty row,
Please help if you can,
Thanks
Tony