can you send an example?
can you send the excel file?
i never saw an attachment can you try again.
what sheet in your file are you trying to set up?
can you tell me which cells are supposed to be which columns?
i really cant find a formula that will do this correctly only way to be absolutely correct would be some kind of macro
im not exactly sure how a countblank formula is getting the correct value from the correct row.
I can create a macro to do it, but not for the price offered. It will cost more.
i can't do it for less than $99. that is my typical charge for a macro. A macro should be able to figure out which cells to update assuming there are exactly the same number of rows on each page.
do you have any insterest in continuing?