Hi,
Here's what am trying to do :-
Datasource: Sheet1 that has monthly (columns)forecasted cash needed to purchase materials by four different departments(rows), and phases(rows).
They put the reason for material purchase as a comment in the cell that they put their forecasted cash figure into in this sheet1(under respective month column) .
My actual and budgeted data for material needs is available in sheet2. Sheet 3 has serial number, material descrition/rationalization for need,project phase, orderer, month,supplier name, order approved,cost per item, no of items, total cost.
Target:
I want to combine data from all thses sheets and put in one sheet with fields -
department, material description (should append data from respective comment field into data in description field by matching month, department and phase from sheet1 to description data in sheet3), project phase from sheet1, budgeted material need from sheet2, forecasted material need from sheet1, actual material need from sheet2, variance between actual and forecast, orderer from sheet 3, month,supplier name from sheet3, order approved from sheet3,cost per item from sheet3, no of items from sheet3, total cost from sheet3.
Am trying to figure out how the placement of fields should be with so many items, am thinking maybe i should have month as a drop down list or how will it work if i have months as columns and all the other fields as different as rows...how will the outlay be?
another issue would be how would i get the text out of the comments in one sheet and append this text to text in respective cell in another sheet. how to set rule for finding appropriate cell to append to and how to append the text once the cell is found?
Am very new VB, macros...and dont know how to put this all together.
Your help is greatly appreciated.
Thanks and regards,
Joy
Bookmarks