I am wanting to sum rows of data, some cells text and some numbers from a data base sheet to another sheet.
The data base sheet has name and other information for that name aling the cells in that row.
In a seperate sheet would like to bring over some rows of information based off certain critera.
(I can add a new cell in each row that would specify this to be summed in the seperate shet) Such as a "yes" in a cell next to the name...)
The part I don't know hiw to do is in the seperate sheet I don't want blank rows as onlt some of the rows from sheet1 will be wanted on sheet2
Is there a way to do this without VBA? A formula that will do this so we don't have to copy and paste all the time?
And I don't like the copy and paste becuase sometimes the data will change on sheet1 and that needs to reflect on sheet2
I just don't want to have a lot of blank rows on sheet2
Bookmarks