Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
Help with referenced sheet (sorry for dups)
Hi all,
I am attempting to feed data into a cell on sheet ABC that comes from another sheet that will be created programmatically (call it sheet XYZ). I start by creating the reference with sheet XYZ already existing, so that I can pick the cells I want off of it. I then delete sheet XYZ. My cells on ABC all then become #REF, which is okay with me. I save and close. I then run the program that takes some data, opens my excel file, and (re)creates sheet XYZ and puts the data I want onto it. The problem is that all of my cells on ABC that reference XYZ keep the #REF until I double click in the cell and hit 'Enter'. Neither Refresh or Calculate Sheet work. Any ideas? Thanks! Bill |
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
Help with referenced sheet (sorry for dups)
To get xyz!b4
=INDIRECT("xyz!B"& ROW(A4)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Bill L" wrote in message .. . Hi all, I am attempting to feed data into a cell on sheet ABC that comes from another sheet that will be created programmatically (call it sheet XYZ). I start by creating the reference with sheet XYZ already existing, so that I can pick the cells I want off of it. I then delete sheet XYZ. My cells on ABC all then become #REF, which is okay with me. I save and close. I then run the program that takes some data, opens my excel file, and (re)creates sheet XYZ and puts the data I want onto it. The problem is that all of my cells on ABC that reference XYZ keep the #REF until I double click in the cell and hit 'Enter'. Neither Refresh or Calculate Sheet work. Any ideas? Thanks! Bill |
#4
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
Help with referenced sheet (sorry for dups)
Glad to help
-- Don Guillett Microsoft MVP Excel SalesAid Software "Bill L" wrote in message . .. Worked like a charm! Thanks!! "Don Guillett" wrote in message ... To get xyz!b4 =INDIRECT("xyz!B"& ROW(A4)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Bill L" wrote in message .. . Hi all, I am attempting to feed data into a cell on sheet ABC that comes from another sheet that will be created programmatically (call it sheet XYZ). I start by creating the reference with sheet XYZ already existing, so that I can pick the cells I want off of it. I then delete sheet XYZ. My cells on ABC all then become #REF, which is okay with me. I save and close. I then run the program that takes some data, opens my excel file, and (re)creates sheet XYZ and puts the data I want onto it. The problem is that all of my cells on ABC that reference XYZ keep the #REF until I double click in the cell and hit 'Enter'. Neither Refresh or Calculate Sheet work. Any ideas? Thanks! Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database - looking for dups | Excel Discussion (Misc queries) | |||
Can a sheet be referenced by a value in a cell? | Excel Worksheet Functions | |||
Creating a master sheet referenced to multiple worksheets | Excel Discussion (Misc queries) | |||
Lookup funtion referenced from another sheet. | Excel Worksheet Functions | |||
Automate a date referenced in a formula pointing to another sheet | Excel Worksheet Functions |