Not sure if the title is correct, but here is my problem.
I have 2 excel sheets, and in the first (sheet 1) are thousands of named cells in columns B,C,D,E. Also in this sheet there are breaks for different categories. So lets say after 20 rows there is a blank row and a new category of named cells under.
In the other sheet (sheet 2) I have blank spaces for theses named cells from sheet 1. I have tried writing a macro to pull the named cells from the 1st sheet to the other but I am too much of a rookie at this. In sheet 2 I need to pull the amounts into columns C,E,G,I.
Any help would be much appreciated!
Bookmarks