sujittalukde
04-04-2008, 05:40 AM
I have attached a file wherein a sheet called ?Summary? exist..
This summary sheet should import data from the Sheet ?Details?
Data should be imported in the following manner.
The ?Summary? sheet is based on Quarter. For eg., Cell D2 contains the term ?Taxable Expenses? for Quarter 1. Similarly F2, H2 & J2 contains the trem for Quarter 2,3 & 4 respectively.
The cell A3 & onwards contains Head of Expenditures. This Head of Expenditure & Quarter also exist in Details Sheet.
Now I want that a macro should look for the first Head of Exp. For each quarter in the summary sheet, then go to Details sheet, look for the first Head of Exps. For the quarter and if found pick the same from the Detail Sheet and put the value in the Summary sheet for that quarter. If the Head of Exps. Is not found for the quarter then put 0 (Zero).
Can this be done by a macro?
The summary sheet format is fixed ie will not change but the number of rows for Details sheet will change but the columns will be fixed.
The data in the summary sheet is done manually this I want to import by macro.
This summary sheet should import data from the Sheet ?Details?
Data should be imported in the following manner.
The ?Summary? sheet is based on Quarter. For eg., Cell D2 contains the term ?Taxable Expenses? for Quarter 1. Similarly F2, H2 & J2 contains the trem for Quarter 2,3 & 4 respectively.
The cell A3 & onwards contains Head of Expenditures. This Head of Expenditure & Quarter also exist in Details Sheet.
Now I want that a macro should look for the first Head of Exp. For each quarter in the summary sheet, then go to Details sheet, look for the first Head of Exps. For the quarter and if found pick the same from the Detail Sheet and put the value in the Summary sheet for that quarter. If the Head of Exps. Is not found for the quarter then put 0 (Zero).
Can this be done by a macro?
The summary sheet format is fixed ie will not change but the number of rows for Details sheet will change but the columns will be fixed.
The data in the summary sheet is done manually this I want to import by macro.