Hi.
I have a VLOOKUP-problem I hope you guys can help me with:
The input:
1) I have several worksheets in a workbook. Each worksheet is representing a project with financial figures. There is about 100 projects, so there are about 100 worksheets in the workbook. The names of the worksheets are a specific project number (1000,1001,1002.... 1100). All worksheets are designe equally - that is, they look sismila. In column A; I have different financial posts (e.g. revenue, costs of labour, direct material, etc.) All these posts have a number (accounting number). In row 1, I have predefined all the months in the duration of the project (e.g Jan14, Feb14, Mar14 ... etc).
2) Each month the projects needs to be updated. As the time passes on, the matrix between row 1 and column A will be filled with actual finacial figures per project.
3) Each month I receive actual financial information in three columns in a inbput worksheet. In column A the project number, column B: the financial post number and column C: The figure.
The challenge:
What I need is a macro that I can run once a month. I need to be able to select wich month in a predefined drop down cell, and run the macro.
The macro should copy the figures from the input sheet, and pastes the information in the correct column for the correct project (worksheet). For instance; Jan14 is in column B in all projects (worksheets). It would be great if i just could select "Jan14" from the drop down menu, and then the macro runs a lookup in column B in all of the 100 worksheets. The nexth month the macro should (by the choosing of Feb14) run the same lookup in column C for all worksheets. The lookup should be able to recognize the project number (so correct revenue is linked to correct project in correct spreadsheet) as well as correct financial post (correct line in the correct column).
Plase help
I have a VLOOKUP-problem I hope you guys can help me with:
The input:
1) I have several worksheets in a workbook. Each worksheet is representing a project with financial figures. There is about 100 projects, so there are about 100 worksheets in the workbook. The names of the worksheets are a specific project number (1000,1001,1002.... 1100). All worksheets are designe equally - that is, they look sismila. In column A; I have different financial posts (e.g. revenue, costs of labour, direct material, etc.) All these posts have a number (accounting number). In row 1, I have predefined all the months in the duration of the project (e.g Jan14, Feb14, Mar14 ... etc).
2) Each month the projects needs to be updated. As the time passes on, the matrix between row 1 and column A will be filled with actual finacial figures per project.
3) Each month I receive actual financial information in three columns in a inbput worksheet. In column A the project number, column B: the financial post number and column C: The figure.
The challenge:
What I need is a macro that I can run once a month. I need to be able to select wich month in a predefined drop down cell, and run the macro.
The macro should copy the figures from the input sheet, and pastes the information in the correct column for the correct project (worksheet). For instance; Jan14 is in column B in all projects (worksheets). It would be great if i just could select "Jan14" from the drop down menu, and then the macro runs a lookup in column B in all of the 100 worksheets. The nexth month the macro should (by the choosing of Feb14) run the same lookup in column C for all worksheets. The lookup should be able to recognize the project number (so correct revenue is linked to correct project in correct spreadsheet) as well as correct financial post (correct line in the correct column).
Plase help
