My goal is to find dynamic way to update main sheet with data inside new tables I get on a daily basis without overwriting main file. In simplified example, I work with widgets.
BREAKDOWN OF SHEETS IN FILE(Main, Day1, Day2 and FinalResult)
The "Main" sheet is the primary sheet where I've made manual updates.
Day1update and Day2update are examples of the incoming sheets that I need to merge/append to the "Main" sheet.
Problem #1 - Update sheets have different headers that I need to merge into main.
Problem #2 - When I merge new update sheet, it overwrites original row and my updates are gone.
OUTCOME FILE: Would like to have output to look like "FINALresult" sheet .
RESULTS NEEDED:
1.All headers are merged in one sheet.
2. Only "new" Widgets in update file are only added to main file if it currently doesn't exist.
3. Manual edits (Seen in Orange in Final Results sheet) are not overwritten.
Hi Robert,
Did you mean to attach a file?
After selecting the file you have to click on Start Upload.
Phil
I tried and got a critical error. Let me try again.
File Attachment here
Sorry for so many replies. I'm not sure how to edit original post. If nothing else, I'm sharpening my addition skills...hahaaha. File has been uploaded. Thanks for the help.
- Robert
