D
didemps
I have a file with data for a particular week with formulas in the cell
which are using this data to produce totals, but when i copy these cell
with the formulas and then "paste special" into a new worksheet for th
following week (which has its own data which i want to total up usin
the same formulas from previous week) i am not getting correct totals.
Sometimes when use the paste i dont even get the correct "past
special" dialogue box, instead getting prompted to choose a type o
paste- excel 8, text or others from list. Others times when the correc
"paste special" box appears, and i select "all" and then paste im onl
getting the formulas being used in the cell not actually any data
Other times if i paste i get some data but its not updated with th
values from the new worksheet im working in (not giving correct ne
total).
Ive tried on a couple of pcs and im pretty sure its not profile relate
- Is there anything in excel that would be causing the prob or is i
just bad data somewhere?????????
which are using this data to produce totals, but when i copy these cell
with the formulas and then "paste special" into a new worksheet for th
following week (which has its own data which i want to total up usin
the same formulas from previous week) i am not getting correct totals.
Sometimes when use the paste i dont even get the correct "past
special" dialogue box, instead getting prompted to choose a type o
paste- excel 8, text or others from list. Others times when the correc
"paste special" box appears, and i select "all" and then paste im onl
getting the formulas being used in the cell not actually any data
Other times if i paste i get some data but its not updated with th
values from the new worksheet im working in (not giving correct ne
total).
Ive tried on a couple of pcs and im pretty sure its not profile relate
- Is there anything in excel that would be causing the prob or is i
just bad data somewhere?????????