VBA: Find row (in one tab) based on cell value (in second tab) and paste data

[KMJG]

Hello All,

I have a workbook with two tabs.

In the "Project" tab users enter project specific information.
In the "Data" tab a table is kept of all the project information.

On the "Project" tab users have the ability to look at current project information, add new projects, and modify existing project data.

What I want:
A user has entered new project information on the "Project" tab. I now want to copy this information to the appropriate row in the "Data" tab.

What I need excel to do:
1. Determine which row in the "Data" tab corresponds to the updated project information entered in the "Project" tab. To do this, excel must find the cell contents in cell Project B61 (I named the cell "_updateProjectName") on the "Data" tab in column B (this is an excel table header "Project:" and the range is named "projects".

2. Copy the data from Project B61:Z61 and paste it in the correct row on the Data tab (based on step 1 above) starting in column B.

3. If the cell Project B30 (named _NewIndicator) equals the text "NEW", then copy the data from Project B61:AA61 into the first empty row in the "Data tab" starting in column B


Index/Match, Vlookup, other formulas are not an option.

Thank you!

[stnkynts]

Untested:

Please Login or Register  to view this content.

[KMJG]

Thank you!