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?