i have a spreadsheet looks like a crosstab dates/names-->money
the money comes from copy/paste from internet in new sheet named date of copy
the names are on the top row identical the new sheet has
and the dates are identical new sheet name
so every time i get new sheet
i copy last row to new row and adjust few cell to meet new sheet
this way no much data entry
but need keep all sheet from internet otherwise the cell got error/empty
because the first year not so advanced i did not notice the problem
when the database looks fine the total amount was wrong.
then i found the many not filled
is there a way to read/copy the cell by value?to fill access table?
why only the top row as heading why not the frozen top?