| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Same Formula, multiple columns, worksheets
I have a tariff document with pricing in it. It is 21 worksheets in the same
workbook. I want to increase columns D-I, rows 2 - 52 in each column, on every single worksheet, by 20%. Worksheet 1 is for Asia, cell D2 is minimum $290. Cell E2 is Asia-Europe at $4.19. Worksheet 2 is for USA, cell D2 is minimum @340. Cell E2 is US-Africa at $6.32. Can I get WRKSHT 1, cell D2 to change to $348, and E2 to $5.03, and get WKRSHT 2, cell D2 to $408, E2 to $7.58 in one command? How can I do this? Thanks. -- Maddy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replicate columns across multiple worksheets | Excel Worksheet Functions | |||
| Counting rows from columns on multiple worksheets? | Excel Worksheet Functions | |||
| linking multiple columns onto multiple worksheets | Excel Discussion (Misc queries) | |||
| Linking between multiple worksheets, workbooks and columns | Excel Discussion (Misc queries) | |||
| Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) | |||
Threaded Mode
