Thanks Karthik, I built it into a macro and used a button to re-issue as and
when needed.
--
Regards vipa
"Karthik" wrote:
Hi Vipra
Do this: Before you multiply your numbers with 1 select only non blank
cells... How??
As usual write 1 in any cell and copy it.
Select your cells (all of them - 3000 rows). Now go to
Edit Go To..Special... Select the "Constants" option and click OK.
Now you see only non blank cells are selected.
Now do a paste special. Edit Paste Special and choose multiply. (u
already know this)
Job done in under 10 seconds.....
Thanks
Karthik Bhat
Karthikbhat<atrediffmail<dotcom
Bangalore
|