mongoose
03-11-2020, 12:53 PM
I have an excel file which is running too slow because of the amount of data in it. I have a table named "Table3" in Sheet1 and I would like to move the data into an identical table in Sheet4.
But I need to only pull data that fall into a certain date range. If the date in Column "Actual Ship Date" doesn't fall within the range of today's date + 14 days; then it gets moved to the table on Sheet4.
Basically the table in Sheet4 would be a sort of archive. When the data gets moved, I need it to add to any data that is already there and not overwrite the data which is there.
Can anyone help point me in the right direction? I'd rather not loop through cell after cell unless I have to. I have heard and experienced how slow it is but am unfamiliar of another route?
But I need to only pull data that fall into a certain date range. If the date in Column "Actual Ship Date" doesn't fall within the range of today's date + 14 days; then it gets moved to the table on Sheet4.
Basically the table in Sheet4 would be a sort of archive. When the data gets moved, I need it to add to any data that is already there and not overwrite the data which is there.
Can anyone help point me in the right direction? I'd rather not loop through cell after cell unless I have to. I have heard and experienced how slow it is but am unfamiliar of another route?