 ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 297 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Excel WorkbooksI am using a multi page excel workbook. I want to copy text data from a worksheet (sheet 3) to another worksheet (sheet 1) so that if I update the data on sheet 3 it automatically changes sheet 1. Am looking for the formula i need to type in the cell in Sheet 1 to "grab" the date from sheet 3.
Did that make sense? Diane |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
Use OFFSET or INDIRECT
=OFFSET(sheet3!A1,ROW()-1,COLUMN()-1)
=INDIRECT(ADDRESS(ROW(),COLUMN(),,,"sheet3"))
copy text data from a worksheet
hihi...
This will most likely cause you more problems than it solves, but here's how to do it anyway:
in cell A1 on sheet1, type:
=IF(Sheet3!A1<>"",Sheet3!A1,"")
Then copy that formula to cells on Sheet 1 to as many cells as you think you may ever populate on Sheet3.
- The problem is if you go inserting or deleting rows, cells or columns on Sheet 3.
- If you do this, you will have to repeat the tasks above.
- Also, if you have done the above, and the values on Sheet 1 do not reflect Sheet 3, Press F9 to recalculate.
An alternative is to copy the entire sheet when you need to use the copy.
http://excelexperts.com/Excel-Tips-Copy-Sheet-To-New-Workbook
You should never need to do what you're doing if you have designed your spreadsheet well, but without knowing what the end goal is, I can't advise further
Nick