Excel Help Needed
03-10-2004, 04:33 PM
#12
Senior Member
Join Date: Nov 2001
Location: Ames, IA
Posts: 4,773
Pick a cell (I used C36) and type "=C7*2.65" into it, without the quotes. Then, grab the corner of that cell and drag to Q36, then grab and drag again to Q52. The values in there will be the values in your original table multiplied by 2.65. Then, select cells C36:Q52 and copy. Then, once that data is in your clipboard, select cells C7:Q23 and go to Edit > Paste Special and then select Values and click OK.
03-11-2004, 08:06 AM
#15
Super Moderator
Join Date: Sep 2002
Location: Tallahassee, FL
Posts: 5,425
Originally Posted by Turbo II' date='Mar 10 2004, 05:36 PM
:lost:
You're just essentially recreating your entire table with the new results in a bunch of vacant cells, then copying it and pasting it to your original table. Then just delete the temporary crap you created at the bottom.
03-11-2004, 12:34 PM
#16
omghi2u
Thread Starter
Join Date: Mar 2002
Location: Los Angeles, CA
Posts: 7,259
i did it. took me till 11 last night! i copied the whole range of cells on the same page and had that multiply eveyrthing by 2.65 and just applied the forumula to the original. thanks for the help ed and baldy
Thread
Thread Starter
Forum
Replies
Last Post
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)