Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
Office 2k.
Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
L
To link data from one sheet to another you can use a formula on the summary sheet like =January!A1 This can be dragged down using the fill handle as far as you wish. From the sounds of it you have 12 columns of notes on the summary sheet. In January Notes column enter =January!cellref and drag/copy that down. cellref being the top cell in the January sheet "notes" column Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote: Office 2k. Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
Thanks. Will give it a try when I get to work in the AM.
L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L To link data from one sheet to another you can use a formula on the summary sheet like =January!A1 This can be dragged down using the fill handle as far as you wish. From the sounds of it you have 12 columns of notes on the summary sheet. In January Notes column enter =January!cellref and drag/copy that down. cellref being the top cell in the January sheet "notes" column Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote: Office 2k. Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
Back in office and trying to follow your instructions.
Not sure what I'm doing wrong. The monthly sheet is labeled January 2006. The column for Notes is column "I" and I want to start in row 3 (first two rows are description of column). When I enter =January 2006!I3 in summary page, January notes(column "P" row 3) I get a popup "file not found" screen. Help, L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L To link data from one sheet to another you can use a formula on the summary sheet like =January!A1 This can be dragged down using the fill handle as far as you wish. From the sounds of it you have 12 columns of notes on the summary sheet. In January Notes column enter =January!cellref and drag/copy that down. cellref being the top cell in the January sheet "notes" column Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote: Office 2k. Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
Think I found it.
=January 2006!I3 s/b ='January 2006'!I3 Didn't have ' ' around sheet name. I'm guessing because of the space between January and 2006?? L. "L." wrote in message ... Back in office and trying to follow your instructions. Not sure what I'm doing wrong. The monthly sheet is labeled January 2006. The column for Notes is column "I" and I want to start in row 3 (first two rows are description of column). When I enter =January 2006!I3 in summary page, January notes(column "P" row 3) I get a popup "file not found" screen. Help, L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L To link data from one sheet to another you can use a formula on the summary sheet like =January!A1 This can be dragged down using the fill handle as far as you wish. From the sounds of it you have 12 columns of notes on the summary sheet. In January Notes column enter =January!cellref and drag/copy that down. cellref being the top cell in the January sheet "notes" column Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote: Office 2k. Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. |
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
Do have one problem.
On summary page, if there isn't anything entered on column, I get "0" instead of being blank. L. "L." wrote in message ... Think I found it. =January 2006!I3 s/b ='January 2006'!I3 Didn't have ' ' around sheet name. I'm guessing because of the space between January and 2006?? L. "L." wrote in message ... Back in office and trying to follow your instructions. Not sure what I'm doing wrong. The monthly sheet is labeled January 2006. The column for Notes is column "I" and I want to start in row 3 (first two rows are description of column). When I enter =January 2006!I3 in summary page, January notes(column "P" row 3) I get a popup "file not found" screen. Help, L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L To link data from one sheet to another you can use a formula on the summary sheet like =January!A1 This can be dragged down using the fill handle as far as you wish. From the sounds of it you have 12 columns of notes on the summary sheet. In January Notes column enter =January!cellref and drag/copy that down. cellref being the top cell in the January sheet "notes" column Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote: Office 2k. Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. |
#7
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
L
You are correct in your assumption. My bad for not pointing out the need for the single quotes when sheetname has space(s) Gord On Mon, 23 Jan 2006 12:10:10 -0600, "L." wrote: Think I found it. =January 2006!I3 s/b ='January 2006'!I3 Didn't have ' ' around sheet name. I'm guessing because of the space between January and 2006?? L. "L." wrote in message ... Back in office and trying to follow your instructions. Not sure what I'm doing wrong. The monthly sheet is labeled January 2006. The column for Notes is column "I" and I want to start in row 3 (first two rows are description of column). When I enter =January 2006!I3 in summary page, January notes(column "P" row 3) I get a popup "file not found" screen. Help, L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L To link data from one sheet to another you can use a formula on the summary sheet like =January!A1 This can be dragged down using the fill handle as far as you wish. From the sounds of it you have 12 columns of notes on the summary sheet. In January Notes column enter =January!cellref and drag/copy that down. cellref being the top cell in the January sheet "notes" column Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote: Office 2k. Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. Gord Dibben MS Excel MVP |
#8
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
=IF('January 2006'!I3="","",'January 2006'!I3)
OR ToolsOptionsView. Uncheck "Zero Values" Gord On Mon, 23 Jan 2006 12:13:29 -0600, "L." wrote: Do have one problem. On summary page, if there isn't anything entered on column, I get "0" instead of being blank. L. "L." wrote in message . .. Think I found it. =January 2006!I3 s/b ='January 2006'!I3 Didn't have ' ' around sheet name. I'm guessing because of the space between January and 2006?? L. "L." wrote in message ... Back in office and trying to follow your instructions. Not sure what I'm doing wrong. The monthly sheet is labeled January 2006. The column for Notes is column "I" and I want to start in row 3 (first two rows are description of column). When I enter =January 2006!I3 in summary page, January notes(column "P" row 3) I get a popup "file not found" screen. Help, L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L To link data from one sheet to another you can use a formula on the summary sheet like =January!A1 This can be dragged down using the fill handle as far as you wish. From the sounds of it you have 12 columns of notes on the summary sheet. In January Notes column enter =January!cellref and drag/copy that down. cellref being the top cell in the January sheet "notes" column Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote: Office 2k. Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. |
#9
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
Unchecking zero values did it.
In your opinion, which suggestion should I use. OR is it a "toss-up"? Thanks. L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... =IF('January 2006'!I3="","",'January 2006'!I3) OR ToolsOptionsView. Uncheck "Zero Values" Gord On Mon, 23 Jan 2006 12:13:29 -0600, "L." wrote: Do have one problem. On summary page, if there isn't anything entered on column, I get "0" instead of being blank. L. "L." wrote in message .. . Think I found it. =January 2006!I3 s/b ='January 2006'!I3 Didn't have ' ' around sheet name. I'm guessing because of the space between January and 2006?? L. "L." wrote in message ... Back in office and trying to follow your instructions. Not sure what I'm doing wrong. The monthly sheet is labeled January 2006. The column for Notes is column "I" and I want to start in row 3 (first two rows are description of column). When I enter =January 2006!I3 in summary page, January notes(column "P" row 3) I get a popup "file not found" screen. Help, L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L To link data from one sheet to another you can use a formula on the summary sheet like =January!A1 This can be dragged down using the fill handle as far as you wish. From the sounds of it you have 12 columns of notes on the summary sheet. In January Notes column enter =January!cellref and drag/copy that down. cellref being the top cell in the January sheet "notes" column Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote: Office 2k. Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. |
#10
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
Depends upon your needs.
There may be cases when the value is a real 0 and you want to see if it is. Otherwise, no harm in unchecking zero values. Gord On Mon, 23 Jan 2006 17:11:13 -0600, "L." wrote: Unchecking zero values did it. In your opinion, which suggestion should I use. OR is it a "toss-up"? Thanks. L. "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . =IF('January 2006'!I3="","",'January 2006'!I3) OR ToolsOptionsView. Uncheck "Zero Values" Gord On Mon, 23 Jan 2006 12:13:29 -0600, "L." wrote: Do have one problem. On summary page, if there isn't anything entered on column, I get "0" instead of being blank. L. "L." wrote in message . .. Think I found it. =January 2006!I3 s/b ='January 2006'!I3 Didn't have ' ' around sheet name. I'm guessing because of the space between January and 2006?? L. "L." wrote in message ... Back in office and trying to follow your instructions. Not sure what I'm doing wrong. The monthly sheet is labeled January 2006. The column for Notes is column "I" and I want to start in row 3 (first two rows are description of column). When I enter =January 2006!I3 in summary page, January notes(column "P" row 3) I get a popup "file not found" screen. Help, L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L To link data from one sheet to another you can use a formula on the summary sheet like =January!A1 This can be dragged down using the fill handle as far as you wish. From the sounds of it you have 12 columns of notes on the summary sheet. In January Notes column enter =January!cellref and drag/copy that down. cellref being the top cell in the January sheet "notes" column Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote: Office 2k. Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. |
#11
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
THANKS for your help
Since these columns are text only I will stay with zero values for the whole column but will keep your instructions(formula) just in case. thanks, L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Depends upon your needs. There may be cases when the value is a real 0 and you want to see if it is. Otherwise, no harm in unchecking zero values. Gord On Mon, 23 Jan 2006 17:11:13 -0600, "L." wrote: Unchecking zero values did it. In your opinion, which suggestion should I use. OR is it a "toss-up"? Thanks. L. "Gord Dibben" <gorddibbATshawDOTca wrote in message . .. =IF('January 2006'!I3="","",'January 2006'!I3) OR ToolsOptionsView. Uncheck "Zero Values" Gord On Mon, 23 Jan 2006 12:13:29 -0600, "L." wrote: Do have one problem. On summary page, if there isn't anything entered on column, I get "0" instead of being blank. L. "L." wrote in message ... Think I found it. =January 2006!I3 s/b ='January 2006'!I3 Didn't have ' ' around sheet name. I'm guessing because of the space between January and 2006?? L. "L." wrote in message ... Back in office and trying to follow your instructions. Not sure what I'm doing wrong. The monthly sheet is labeled January 2006. The column for Notes is column "I" and I want to start in row 3 (first two rows are description of column). When I enter =January 2006!I3 in summary page, January notes(column "P" row 3) I get a popup "file not found" screen. Help, L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L To link data from one sheet to another you can use a formula on the summary sheet like =January!A1 This can be dragged down using the fill handle as far as you wish. From the sounds of it you have 12 columns of notes on the summary sheet. In January Notes column enter =January!cellref and drag/copy that down. cellref being the top cell in the January sheet "notes" column Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote: Office 2k. Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. |
#12
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
Gord,
If you're still there, have a problem. I have entered the formula (=January 2006'!I3, ='Febuary 2006'!I3, etc etc etc ) in each of the monthly columns on the Summary sheet. Dragged down the 70 rows and everything worked great. Everything EXCEPT March.^!^@!@! When I enter ='March 2006'!I3 that is exactly what shows up in the column. I'm guessing it's picking up the fomula as text only. I've checked settings and they appear same as other monthly columns. Not sure what to do. L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L You are correct in your assumption. My bad for not pointing out the need for the single quotes when sheetname has space(s) Gord On Mon, 23 Jan 2006 12:10:10 -0600, "L." wrote: Think I found it. =January 2006!I3 s/b ='January 2006'!I3 Didn't have ' ' around sheet name. I'm guessing because of the space between January and 2006?? L. "L." wrote in message ... Back in office and trying to follow your instructions. Not sure what I'm doing wrong. The monthly sheet is labeled January 2006. The column for Notes is column "I" and I want to start in row 3 (first two rows are description of column). When I enter =January 2006!I3 in summary page, January notes(column "P" row 3) I get a popup "file not found" screen. Help, L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L To link data from one sheet to another you can use a formula on the summary sheet like =January!A1 This can be dragged down using the fill handle as far as you wish. From the sounds of it you have 12 columns of notes on the summary sheet. In January Notes column enter =January!cellref and drag/copy that down. cellref being the top cell in the January sheet "notes" column Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote: Office 2k. Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. Gord Dibben MS Excel MVP |
#13
Posted to microsoft.public.excel.setup
|
|||
|
|||
Move data?
Not sure WHY but I fixed problem.
I changed cell format to "general" and then back to "text" and it's working, now. L. "L." wrote in message ... Gord, If you're still there, have a problem. I have entered the formula (=January 2006'!I3, ='Febuary 2006'!I3, etc etc etc ) in each of the monthly columns on the Summary sheet. Dragged down the 70 rows and everything worked great. Everything EXCEPT March.^!^@!@! When I enter ='March 2006'!I3 that is exactly what shows up in the column. I'm guessing it's picking up the fomula as text only. I've checked settings and they appear same as other monthly columns. Not sure what to do. L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L You are correct in your assumption. My bad for not pointing out the need for the single quotes when sheetname has space(s) Gord On Mon, 23 Jan 2006 12:10:10 -0600, "L." wrote: Think I found it. =January 2006!I3 s/b ='January 2006'!I3 Didn't have ' ' around sheet name. I'm guessing because of the space between January and 2006?? L. "L." wrote in message ... Back in office and trying to follow your instructions. Not sure what I'm doing wrong. The monthly sheet is labeled January 2006. The column for Notes is column "I" and I want to start in row 3 (first two rows are description of column). When I enter =January 2006!I3 in summary page, January notes(column "P" row 3) I get a popup "file not found" screen. Help, L. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... L To link data from one sheet to another you can use a formula on the summary sheet like =January!A1 This can be dragged down using the fill handle as far as you wish. From the sounds of it you have 12 columns of notes on the summary sheet. In January Notes column enter =January!cellref and drag/copy that down. cellref being the top cell in the January sheet "notes" column Gord Dibben MS Excel MVP On Fri, 20 Jan 2006 15:38:28 -0600, "L." wrote: Office 2k. Have 13 sheets, one for each month and a "summary" page. Each monthly page has a "Notes" column for special notes, comments, etc. The Summary page also has corresponding columns (January Notes, Feb. Notes,etc.etc.) for each month. When done with particular month, I try to remember to transfer Notes from individual monthly pages to summary page Notes. Now I just retype data and/or copy-paste. Would like to have anything I enter in Notes column on monthly pages to auto transfer to summary page Notes. Help, L. Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Move Data Up One Row and Add On to Existing | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
HELP REF. NEW DATA ONLY AS i MOVE TO ANY CELL IN THE NEW ROW/RANGE | Charts and Charting in Excel | |||
retaining data after source cells move | Excel Discussion (Misc queries) |