Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto update one spreadsheet with another that creates a file.
Okay I'm trying to program a spreadsheet that will give me a YTD by month. I
have a spreadsheet programed already that the supervisors use to enter all the daily production info. At the end of the day they save and close the program which automaticaly creates a file name. Now for the main problem I have. I got it to work okay to the point where the file does not exist yet and i get a bunch of #REF! in the cells. is there a way for me to program this sheet and not have all these cells with #REF! in them. It would be nice to just program this sheet all at once and as the file is writen update the spreadsheet. Hopefully someone can understand this and help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simplest way to auto update a spreadsheet with web info? | Excel Discussion (Misc queries) | |||
How to auto update a spreadsheet with data from a .xls file? | Excel Worksheet Functions | |||
Auto Update of Source File Name | Excel Worksheet Functions | |||
how do I set up a spreadsheet and auto update from another wksheet | Excel Worksheet Functions | |||
Can I 'auto update' my spreadsheet ? | Excel Worksheet Functions |