StewartM666
New Member
- Joined
- Jun 11, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have 2 different spreadsheets running to 100,000 rows each, with around 15 columns on both of them. They both show different measurements of performance and i want to bring some of the data across from sheet 2 to sheet 1 where the same event is on both spreadsheets. This is beyond my skills and so i would really appreciate some help.
On both sheets the common data is in columns A/B/C being Date, Person, Place so i need something that checks for identical entries in all 3 fields in same row on both spreadsheets and then if there is a match it grabs data from a column on spreadsheet 2 and puts it in a column on spreadsheet 1.
Please help as doing it manually is proving very slow!
On both sheets the common data is in columns A/B/C being Date, Person, Place so i need something that checks for identical entries in all 3 fields in same row on both spreadsheets and then if there is a match it grabs data from a column on spreadsheet 2 and puts it in a column on spreadsheet 1.
Please help as doing it manually is proving very slow!