I have a huge spreadsheet - over 200,000 rows and over 20 columns. In the original I've made new worksheets with different columns trimmed. I tried to open a new workbook and copy one of the worksheets to it and all the dates copied over as plus one day and 4 years! I did a copy & paste value and verified that the formating is the same. Why is the date wrong and how can I get it to copy properly?
I want a single worksheet in a workbook so I can open it with a different program to look at some stats and I don't want all the original columns. The dataset is too large in it's original format to open several sheets worth in the other program.
I want a single worksheet in a workbook so I can open it with a different program to look at some stats and I don't want all the original columns. The dataset is too large in it's original format to open several sheets worth in the other program.