Data Compilation macro help

[im_kaushal]

Hi All,

I have many workbooks available in a folder which will a worksheet name "BalSheet".
Structure of this sheet is such
in Column A Discription is Available - Product A, Product B, Product C etc.
In Column B Status is available - Relevant, Non Relevant
In Column C Submission Dates are available - in mm/dd/yy (is different in each workbook)
In Column D Amount is available -

Can A macro be created which can go into each of the workbook and create a table in a new excel sheet which should have data like
In Range"A2" = Product A
In Range"A3" = Product B
In Range "B1:Z1" = Dates
And in Column B Amount can be pasted for all the Relevant status...


I hope I make you question clear...


This is something I am doing manually, Can someone please help me out...

I know you guys are expert of this thing...

many thanks,
Kaushal

 

[im_kaushal]

Posting a reply as not able to edit my previous post

Hi All,

I have many worksheets available in a workbook.
Structure of these sheet is such
in Column A Discription is Available - Product A, Product B, Product C etc.
In Column B Status is available - Relevant, Non Relevant
In Column C Submission Dates are available - in mm/dd/yy (is different in each worksheet)
In Column D Amount is available -

Can A macro be created which can go into each of the worksheets and create a table in a new excel sheet which should have data like
In Range"A2" = Product A
In Range"A3" = Product B
In Range "B1:Z1" = Dates
And in Column B Amount can be pasted for all the Relevant status...


I hope I make you question clear...


This is something I am doing manually, Can someone please help me out...

I know you guys are expert of this thing...

many thanks,
Kaushal
<!-- / message -->