Hi
I'm trying to update a rows in my Master file (Main Worksheet) using data from multiple data sheets (data sheets are updated constantly). Data from the data sheets must be filled up based on the masterfiles ID no(Both master file and data sheets have same columns). data is not arranged chronologically so it needs to be looping... i think.
here is a sample below.
This is my master file. i need to fill up the capex part using data from the data sheets. with columns " End user" and "No." as their constants.
Both Master File and Data Sheets have the same Column names. Data sheets are separate worksheets based on End Users
Master File
I'm trying to update a rows in my Master file (Main Worksheet) using data from multiple data sheets (data sheets are updated constantly). Data from the data sheets must be filled up based on the masterfiles ID no(Both master file and data sheets have same columns). data is not arranged chronologically so it needs to be looping... i think.
here is a sample below.
This is my master file. i need to fill up the capex part using data from the data sheets. with columns " End user" and "No." as their constants.
Both Master File and Data Sheets have the same Column names. Data sheets are separate worksheets based on End Users
Master File
| Transaction No. | GS /CS / IN | No. | Year | Procurement Project | End User | Date | Deadline | ABC | Contract | CAPEX OPEX |
1 | GS | 0001 | Test Project 1 | FSS | ||||||
1 | GS | 0002 | Test Project 2 | PMSS | ||||||
2 | GS | 0003 | Test Project 3 | PMSS | ||||||
1 | IN | 0005 | Test Project 1 | FSS |
