| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Cells Q
How could I copy cells in a range but reverse its sign?
E.g To Copy Range A2:D2 to A1:D1 The value in A2= 15000 The value I wish then to see in A1 = -15000 Same for B2:D2 etc There maybe <blanks in cells A2:D2 if so I would still want these blank in A1:D1 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy big ranges of cells without drag or copy/paste? | Excel Discussion (Misc queries) | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| macro needed to copy blocks of cells across to list of cells down | Excel Programming | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Copy data into cells until changes trigger new copy | Excel Programming | |||
Threaded Mode
