| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limited autoformatting when pasting
Trying to find a timesaving operation, help needed. I.E. a formula like this; IF(LEFT(SheetA.A1,1)="X",(SheetB.B1*SheetC.C1),T(" ")) Now using this formula in Sheet D, I want the Table A value to remain fixed and the B&C values move along as I copy it down rows or columns. On row zz it should look like this; IF(LEFT(SheetA.A1,1)="X",(SheetB.Bzz*SheetC.Czz),T ("")) Help! //Johan -- Flaxkrax ------------------------------------------------------------------------ Flaxkrax's Profile: http://www.excelforum.com/member.php...o&userid=36040 View this thread: http://www.excelforum.com/showthread...hreadid=558333 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limited autoformatting when pasting
Hi Flaxkrax,
Try this: IF(LEFT(SheetA!$A$1,1)="X",(SheetB!$B1*SheetC!$C1) ,T("")) Regards, Stefi €˛Flaxkrax€¯ ezt Ć*rta: Trying to find a timesaving operation, help needed. I.E. a formula like this; IF(LEFT(SheetA.A1,1)="X",(SheetB.B1*SheetC.C1),T(" ")) Now using this formula in Sheet D, I want the Table A value to remain fixed and the B&C values move along as I copy it down rows or columns. On row zz it should look like this; IF(LEFT(SheetA.A1,1)="X",(SheetB.Bzz*SheetC.Czz),T ("")) Help! //Johan -- Flaxkrax ------------------------------------------------------------------------ Flaxkrax's Profile: http://www.excelforum.com/member.php...o&userid=36040 View this thread: http://www.excelforum.com/showthread...hreadid=558333 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limited autoformatting when pasting
That was just what I was looking for!! //Johan "Flaxkrax", greatful newbie -- Flaxkrax ------------------------------------------------------------------------ Flaxkrax's Profile: http://www.excelforum.com/member.php...o&userid=36040 View this thread: http://www.excelforum.com/showthread...hreadid=558333 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limited autoformatting when pasting
Thanks for the feedback!
Stefi €˛Flaxkrax€¯ ezt Ć*rta: That was just what I was looking for!! //Johan "Flaxkrax", greatful newbie -- Flaxkrax ------------------------------------------------------------------------ Flaxkrax's Profile: http://www.excelforum.com/member.php...o&userid=36040 View this thread: http://www.excelforum.com/showthread...hreadid=558333 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keeping cells locked and protected when copying and pasting | Excel Discussion (Misc queries) | |||
| Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
| Trimmean for limited array | Excel Worksheet Functions | |||
| Force values-only when pasting text to keep formatting | Excel Discussion (Misc queries) | |||
| Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
Linear Mode
