Forum Discussion
How to merge multi sheets into master but keeping the date format?
I'm newbie ! Work as a Salesforce admin. I know basic excel. what I need to know that how can I merge multi sheets into one but wants to keep the date format as well. For e.g 1st spreadtsheet (Jan...
Hi Nidhi,
No simple answer unfortunately.
First aim would be to fix the process to avoid having different data in different sheets / files. Fixing the process and structuring the data correctly in the first place can save masses of re-work and headaches.
Next best solution would be to learn a bit about Power Query (called Get & Transform) in Excel 2016. It's great at consolidating data from different sheets / files etc.
No simple answer unfortunately.
First aim would be to fix the process to avoid having different data in different sheets / files. Fixing the process and structuring the data correctly in the first place can save masses of re-work and headaches.
Next best solution would be to learn a bit about Power Query (called Get & Transform) in Excel 2016. It's great at consolidating data from different sheets / files etc.