I have three columns of data (A8:A???, B8:B???, C8:C???) on sheet10 that I need to copy to columns A, B, C on sheet13 (starting on row 23)
Basically I am taking information from the sheet10 (shipped sheet) and copy it to sheet13 to fill in a packing slip with the items shipped listed.
One catch though, sheet3 needs to only return the values based on what dates sheet10 are sorted by.
For example, there could be 500 lines of items on the shipped tab (sheet10) because this sheet keep accumulating shipped items for up to a few months.
Its when the sheet it filtered to a certain date is where the data really matters.
So If they just filter it to 10-1-17 there may be 20 things that shipped that day. So the packing slip sheet would have to be fluid with that is filtered basically.
It doesn't matter if all of the data on the shipping tab just sits on the packing slip tab, they won't print it until its filtered. So if its unfiltered and 500 lines show up on the packing slip tab it won't matter.
I'm open to any ideas, maybe a formula is a better way to go I'm not sure, I have searched on it and haven't found anything.
Thanks
Bookmarks