Timeline for How do I copy data from multiple Google sheets and paste into master Google sheet while maintaining format?
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 19, 2020 at 10:44 | history | edited | Alex | CC BY-SA 4.0 |
added 6 characters in body
|
| Mar 19, 2020 at 10:38 | comment | added | Garrett Boulware | I do not know that I used IMPORTRANGE properly, but when I used it, it came up short for me. The reason it did not work for me was because when I gave the employee a new assignment it would then replace the old assignment on the master sheet as well, deleting my records of what each person did in the past. I want a master sheet to keep the records from the past and to add new records at the bottom. It was only keeping the most recent record for each employee. IMPORTRANGE worked for formatting but didn't allow for new data to be added at the bottom of the master sheet it replaced old data. | |
| Mar 18, 2020 at 22:40 | history | answered | Shane Symons | CC BY-SA 4.0 |