Excel 2003 Multipage Copy
Posted on 2013-01-24
I have a multipage which has a list of transactions, what I want to do based on the types of transactions that are in the list box I want to create sub pages for each transaction type and copy the list box over to the name page and filter the list box data based on the transaction type.
I was trying to use something like this to copy everything over but it is not working.
PagesCnt = .Count
Set newPage = .Pages.Add("Page" & (PagesCnt + 1), _
"Page " & (PagesCnt + 1), PagesCnt)