Need values on one sheet to appear on another sheet (3 columns total)

[PitBoo]

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

[xladept]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[PitBoo]

Here it is.

Please note that I removed a bunch of pages from the original that don't matter here.

And the Packing Slip tab is actually SHEET13 on the real version (it says sheet1 on this version).

thanks a ton.

[xladept]

Try this:

Please Login or Register  to view this content.

[PitBoo]

OK I put it in the shipped worksheet's code, created a "create packing slip" button and assigned it.
When the sheets are all unlocked it works, but when I protect the sheets and try it I get a 400 error.

One other issue, upon running the macro through the button the packing ship tab formats 10,000 rows with cell borders like the shipped tab is.

I can get around that by just pre setting the print area for just the first two pages. But it formats like 165 pages.

The biggest issue is it won't work when locked.

My password is 1111

It appears to be the shipping sheet that causes the error upon clicking the macro, I locked the packing slip tab and it still worked until I locked the shipping page.

Thanks for the help

[xladept]

Maybe:

Please Login or Register  to view this content.

[PitBoo]

I had to add a little bit at the end to allow for filtering once the sheet re-locked. I got it from another sheet I built, seems to be working.

Any Idea why its formatting 10,000 rows on the packing slip tab?


what I added at the end.

Please Login or Register  to view this content.

thanks again!

[xladept]

Not unless it's because of the clearing of the 1000 (- 22?) rows:

Please Login or Register  to view this content.

[PitBoo]

Well I can certainly live with it, I just set the print area to 2 pages that way it doesn't try to print all 10,000 formatted lines.

Big help, thanks again!

[xladept]

You're welcome!