I have a spreadsheet that lists all of the invoices that we have paid for service over a period of years. I have a column labeled invoice year. I would like to have a macro that would look in that column and copy all rows that have 2010 in that column to a new sheet and label that sheet 2010. I would like to do the same for all the other years as well. I have never written a macro before, but I feel this is probably the only way to do it. Does anyone have any ideas on how to begin?
Bookmarks