Hello,
On daily basis I used to prepare a report, for preparing this I will be getting 5 different excel files as input, to prepare this report I used to take two man hours.
I thought of implementing macros in this report, but I am not sure how this will work, I will explain how I will prepare this report, please review and provide me the coding.
I have attached a sample excel sheet, in this worksheet from sheet1 to sheet5 is the input file, now sheet1 is the base data, macro should calculate how many rows is available in sheet1 according to that each row with header column sheets need to be created and sheet names will be “po Number3” data. For this I have got the coding from Forum below is the coding.
Now will go to sheet KW8660, here column A to column O header column will be filled, now we need to fill column P to column W for this we need to take the data from Sheet2.
In sheet 2 we need to filter the KW8660 and we need to copy the data from header and paste in sheet KW8660 (column P to W),
Similarly from column X to A0 we need to take the filter data from sheet 3,
then from column AP to BU we need to take the filter data from sheet 4,
finally from column BV to CO we need to take the filter data from sheet 5.
Like this we need to pull the details to all the sheets.
For this I need a macro please help me…
Bookmarks