flammabubble
New Member
- Joined
- Aug 19, 2015
- Messages
- 24
Hi All, I'm trying to figure out a way to quickly update a main spreadsheet with the data newly filled in by other users. Basically what I have is a master sheet with all of the data in columns A-P, followed by Columns Q-W which need to be filled in for each entry. People are working to fill in those columns and I then want to update the master sheet with what they've done so far without having to copy/paste each time. I'm aware that a solution is potentially a shared sheet but this isn't an option.
I've been looking around and it looks like VLookup/PowerQuery are probably the most likely solutions but I'm really not sure how best to approach this. To be clear, all of the spreadsheets have the exact same column headings, it's just that columns Q-W need to be updated with the data newly added.
Any advice/pointers would be greatly appreciated.
I've been looking around and it looks like VLookup/PowerQuery are probably the most likely solutions but I'm really not sure how best to approach this. To be clear, all of the spreadsheets have the exact same column headings, it's just that columns Q-W need to be updated with the data newly added.
Any advice/pointers would be greatly appreciated.