Macro to copy and past large amounts of data

[ulikel]

I have a spreadsheet that contains large amounts of inventory counts, from many branches. Each month I have to create a summary sheet, which requires hiding most of the columns in the sheet, filtering by branch, and then copying and pasting each branch into a different sheet. The reason I do one branch at a time is so I can leave space in between them for totals and such. Now I already have a macro to hide and sort the columns, but the issue I was having for copying and pasting is that some months some of the branches will not appear in the summary, so I can't simply tell Excel to "copy and paste kingston to sheet 2" if kingston does not exist that month. It sort of sounds like something an IFERROR function would be used for in excel but not sure how to do it in VBA. Any suggestions?

[xladept]

Hi ulikel,

Welcome to the Forum!

Is there a way to designate "kingston" in the sheet?

Can you:

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 use the paperclip icon to open the upload window.

View Pic