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...
As Wyn described, it is hard to give you a very easy solution.
There are 2 main solutions I would suggest:
- either create a date table (e.g. start with 01.01.2017, in each following row add +1) and add all values behind each date, using the vlookup or sumif function
- or https://youtu.be/VeS0fh8xUVA and https://youtu.be/ldoQws7Zbx8
Best, Oliver
Not sure that works with variable fields structure
