| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same Text on Multiple Worksheets
Thanks Dave, works great
-- PB "Dave Peterson" wrote: You can use formulas that point to any cell on that original worksheet. It may be a pain to set it up the first time, but once it's done, it's done. =if(sheet1!a1="","",sheet1!a1) can go in any sheet in any cell to retrieve the value from A1 on sheet1. This is nice for titles. But if you have a key unique value in a column, you may be able to use =vlookup() or =index(match()) to return a value from a cell in that same row based on that key column. You may want to read Debra Dalgleish's notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) Brennan wrote: I need to enter text into certain fields on a worksheet and I want that text to repeat automatically on other worksheets in the same workbook. Cell references on the other worksheets are not the same as the original worksheet. -- PB -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
| Functions across multiple worksheets | Excel Worksheet Functions | |||
| Sumif with multiple worksheets | Excel Worksheet Functions | |||
| Printing Multiple Worksheets | Excel Discussion (Misc queries) | |||
| search multiple worksheets name with common text and process using | Excel Worksheet Functions | |||
Hybrid Mode
