| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Help
I have built a set of spreadsheets that track our plant operation.
It consists of one sheet we call the input sheet that we put our daily readings in ( power, water,motor hour meter, etc.) and twelve sheets (January - December) that have the formulas to draw the information to the appropriate equipment. My plans were to at the years end to save as to the next years date, wipe out my input page and start over. Here is my delima. The save as sheet still tries to draw from the previous years input page. Any ideas ? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet Help
EditLinksChange Links generally gets the job done.
Gord Dibben MS Excel MVP On Tue, 22 Dec 2009 07:19:01 -0800, Jerry R wrote: I have built a set of spreadsheets that track our plant operation. It consists of one sheet we call the input sheet that we put our daily readings in ( power, water,motor hour meter, etc.) and twelve sheets (January - December) that have the formulas to draw the information to the appropriate equipment. My plans were to at the years end to save as to the next years date, wipe out my input page and start over. Here is my delima. The save as sheet still tries to draw from the previous years input page. Any ideas ? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet Help
Where do I find this?
"Gord Dibben" wrote: EditLinksChange Links generally gets the job done. Gord Dibben MS Excel MVP On Tue, 22 Dec 2009 07:19:01 -0800, Jerry R wrote: I have built a set of spreadsheets that track our plant operation. It consists of one sheet we call the input sheet that we put our daily readings in ( power, water,motor hour meter, etc.) and twelve sheets (January - December) that have the formulas to draw the information to the appropriate equipment. My plans were to at the years end to save as to the next years date, wipe out my input page and start over. Here is my delima. The save as sheet still tries to draw from the previous years input page. Any ideas ? Thanks . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet Help
You could start by looking at the top of your screen for EDIT
-- Don Guillett Microsoft MVP Excel SalesAid Software "Jerry R" wrote in message ... Where do I find this? "Gord Dibben" wrote: EditLinksChange Links generally gets the job done. Gord Dibben MS Excel MVP On Tue, 22 Dec 2009 07:19:01 -0800, Jerry R wrote: I have built a set of spreadsheets that track our plant operation. It consists of one sheet we call the input sheet that we put our daily readings in ( power, water,motor hour meter, etc.) and twelve sheets (January - December) that have the formulas to draw the information to the appropriate equipment. My plans were to at the years end to save as to the next years date, wipe out my input page and start over. Here is my delima. The save as sheet still tries to draw from the previous years input page. Any ideas ? Thanks . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet Help
You could look in Excel help for "edit links"
Or don't bother with Excel help at all and waste your time posting and waiting for someone to tell you...................... Your time is yours to distribute as you see fit so............. In 2003 EditLinks In 2007 DataEdit Links Gord On Tue, 22 Dec 2009 12:26:01 -0800, Jerry R wrote: Where do I find this? "Gord Dibben" wrote: EditLinksChange Links generally gets the job done. Gord Dibben MS Excel MVP On Tue, 22 Dec 2009 07:19:01 -0800, Jerry R wrote: I have built a set of spreadsheets that track our plant operation. It consists of one sheet we call the input sheet that we put our daily readings in ( power, water,motor hour meter, etc.) and twelve sheets (January - December) that have the formulas to draw the information to the appropriate equipment. My plans were to at the years end to save as to the next years date, wipe out my input page and start over. Here is my delima. The save as sheet still tries to draw from the previous years input page. Any ideas ? Thanks . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet Help
SORRY IT IS SUCH AN INCONVIENCE!!!!!
I'm self taught on excell because of our remote location and lack of available classes. I'll try not to infringe on your prescious time any more, but I don't see any reason to get snotty about it!!!! "Gord Dibben" wrote: You could look in Excel help for "edit links" Or don't bother with Excel help at all and waste your time posting and waiting for someone to tell you...................... Your time is yours to distribute as you see fit so............. In 2003 EditLinks In 2007 DataEdit Links Gord On Tue, 22 Dec 2009 12:26:01 -0800, Jerry R wrote: Where do I find this? "Gord Dibben" wrote: EditLinksChange Links generally gets the job done. Gord Dibben MS Excel MVP On Tue, 22 Dec 2009 07:19:01 -0800, Jerry R wrote: I have built a set of spreadsheets that track our plant operation. It consists of one sheet we call the input sheet that we put our daily readings in ( power, water,motor hour meter, etc.) and twelve sheets (January - December) that have the formulas to draw the information to the appropriate equipment. My plans were to at the years end to save as to the next years date, wipe out my input page and start over. Here is my delima. The save as sheet still tries to draw from the previous years input page. Any ideas ? Thanks . . |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet Help
Are you saying that you don't know how to invoke Excel Help? It is
pretty much universal that "Help" is on the right hand side of the menu system, and can also be started by pressing the F1 key. Jerry R wrote: SORRY IT IS SUCH AN INCONVIENCE!!!!! I'm self taught on excell because of our remote location and lack of available classes. I'll try not to infringe on your prescious time any more, but I don't see any reason to get snotty about it!!!! "Gord Dibben" wrote: You could look in Excel help for "edit links" Or don't bother with Excel help at all and waste your time posting and waiting for someone to tell you...................... Your time is yours to distribute as you see fit so............. In 2003 EditLinks In 2007 DataEdit Links Gord On Tue, 22 Dec 2009 12:26:01 -0800, Jerry R wrote: Where do I find this? "Gord Dibben" wrote: EditLinksChange Links generally gets the job done. Gord Dibben MS Excel MVP On Tue, 22 Dec 2009 07:19:01 -0800, Jerry R wrote: I have built a set of spreadsheets that track our plant operation. It consists of one sheet we call the input sheet that we put our daily readings in ( power, water,motor hour meter, etc.) and twelve sheets (January - December) that have the formulas to draw the information to the appropriate equipment. My plans were to at the years end to save as to the next years date, wipe out my input page and start over. Here is my delima. The save as sheet still tries to draw from the previous years input page. Any ideas ? Thanks . . |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet Help
Obviously I have offended someone or ones. I apologise.
I thought I had exlored all places for edit and realised the page I was looking at did not draw from the input page so edit was not highlighted and was not an option. I do appreciate the guidance and will try not to overlook the obvious from here on in. "Bob I" wrote: Are you saying that you don't know how to invoke Excel Help? It is pretty much universal that "Help" is on the right hand side of the menu system, and can also be started by pressing the F1 key. Jerry R wrote: SORRY IT IS SUCH AN INCONVIENCE!!!!! I'm self taught on excell because of our remote location and lack of available classes. I'll try not to infringe on your prescious time any more, but I don't see any reason to get snotty about it!!!! "Gord Dibben" wrote: You could look in Excel help for "edit links" Or don't bother with Excel help at all and waste your time posting and waiting for someone to tell you...................... Your time is yours to distribute as you see fit so............. In 2003 EditLinks In 2007 DataEdit Links Gord On Tue, 22 Dec 2009 12:26:01 -0800, Jerry R wrote: Where do I find this? "Gord Dibben" wrote: EditLinksChange Links generally gets the job done. Gord Dibben MS Excel MVP On Tue, 22 Dec 2009 07:19:01 -0800, Jerry R wrote: I have built a set of spreadsheets that track our plant operation. It consists of one sheet we call the input sheet that we put our daily readings in ( power, water,motor hour meter, etc.) and twelve sheets (January - December) that have the formulas to draw the information to the appropriate equipment. My plans were to at the years end to save as to the next years date, wipe out my input page and start over. Here is my delima. The save as sheet still tries to draw from the previous years input page. Any ideas ? Thanks . . . |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet Help
Not a problem. I suspect it partly comes from frustration due to so many
folks expecting the Help contents to be copied/pasted here in the thread. Jerry R wrote: Obviously I have offended someone or ones. I apologise. I thought I had exlored all places for edit and realised the page I was looking at did not draw from the input page so edit was not highlighted and was not an option. I do appreciate the guidance and will try not to overlook the obvious from here on in. "Bob I" wrote: Are you saying that you don't know how to invoke Excel Help? It is pretty much universal that "Help" is on the right hand side of the menu system, and can also be started by pressing the F1 key. Jerry R wrote: SORRY IT IS SUCH AN INCONVIENCE!!!!! I'm self taught on excell because of our remote location and lack of available classes. I'll try not to infringe on your prescious time any more, but I don't see any reason to get snotty about it!!!! "Gord Dibben" wrote: You could look in Excel help for "edit links" Or don't bother with Excel help at all and waste your time posting and waiting for someone to tell you...................... Your time is yours to distribute as you see fit so............. In 2003 EditLinks In 2007 DataEdit Links Gord On Tue, 22 Dec 2009 12:26:01 -0800, Jerry R wrote: Where do I find this? "Gord Dibben" wrote: EditLinksChange Links generally gets the job done. Gord Dibben MS Excel MVP On Tue, 22 Dec 2009 07:19:01 -0800, Jerry R wrote: I have built a set of spreadsheets that track our plant operation. It consists of one sheet we call the input sheet that we put our daily readings in ( power, water,motor hour meter, etc.) and twelve sheets (January - December) that have the formulas to draw the information to the appropriate equipment. My plans were to at the years end to save as to the next years date, wipe out my input page and start over. Here is my delima. The save as sheet still tries to draw from the previous years input page. Any ideas ? Thanks . . . |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spreadsheet Help
Not an inconvenience to myself.
Just trying to show you a much quicker way to get help. 30 seconds to find out how to edit links would suit me far better than taking the time to post and wait for an answer. Gord On Wed, 23 Dec 2009 05:06:01 -0800, Jerry R wrote: SORRY IT IS SUCH AN INCONVIENCE!!!!! I'm self taught on excell because of our remote location and lack of available classes. I'll try not to infringe on your prescious time any more, but I don't see any reason to get snotty about it!!!! "Gord Dibben" wrote: You could look in Excel help for "edit links" Or don't bother with Excel help at all and waste your time posting and waiting for someone to tell you...................... Your time is yours to distribute as you see fit so............. In 2003 EditLinks In 2007 DataEdit Links Gord On Tue, 22 Dec 2009 12:26:01 -0800, Jerry R wrote: Where do I find this? "Gord Dibben" wrote: EditLinksChange Links generally gets the job done. Gord Dibben MS Excel MVP On Tue, 22 Dec 2009 07:19:01 -0800, Jerry R wrote: I have built a set of spreadsheets that track our plant operation. It consists of one sheet we call the input sheet that we put our daily readings in ( power, water,motor hour meter, etc.) and twelve sheets (January - December) that have the formulas to draw the information to the appropriate equipment. My plans were to at the years end to save as to the next years date, wipe out my input page and start over. Here is my delima. The save as sheet still tries to draw from the previous years input page. Any ideas ? Thanks . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link a local spreadsheet to a network shared spreadsheet | Setting up and Configuration of Excel | |||
| Attach a Spreadsheet File to a Cell in Another Spreadsheet | Excel Discussion (Misc queries) | |||
| conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
