I have a little VBA background, but I can not figure out how to do the following... can anyone help me?
The worksheet is used to manage projects on a chemical plant site. The chemical plant has several different areas and projects will fall into one of these areas.
All project managers will use a "consolidated" worksheet to enter data. This data should populate fields in other worksheets so that the project managers only enter data on the consolidated worksheet.
These other worksheets are area specific. There is a worksheet for each area of the plant. On each "area" worksheet and on the consolidated worksheet, there are three sections which help prioritize the projects for that area. All worksheets (inculding the consolidted spreadsheet) are contained within the same workbook.
The project manager will enter data into one of three sections on the consolidated worksheet. They will use the first cell in the row to identify the section they are in. They will use the second row to identify the area of the plant that the project belongs to. Cells C through R on the consolidated worksheet will populate cells A through P of one of the area worksheets. The worksheet that the data from the consolidated worksheet populates will depend on the information in column B on the consolidated worksheet.
Also, the data from the consolidated worksheet should populate the correct section in the area worksheet. The section that the data from the consolidated worksheet populates on the "area" worksheet will depend on the data in column A on the consolidated worksheet.
Please let me know if you need more information.
Thanks in advance for any help you are able to give.