A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Move data?



 
 
Thread Tools Display Modes
  #11  
Old January 24th, 2006, 05:14 PM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default 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
news
=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  
Old January 24th, 2006, 11:05 PM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default 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  
Old January 24th, 2006, 11:13 PM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default 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





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cross program data sharing m_jurrens Powerpoint 1 December 16th, 2005 05:36 PM
From several workbooks onto one excel worksheet steve General Discussion 6 December 1st, 2005 09:03 AM
PST file has reached maximum size Jeff C General Discussion 2 October 6th, 2005 01:35 PM
strategy for data entry in multiple tables LAF Using Forms 18 April 25th, 2005 04:04 AM
How to create graphs in a monthly report where the base data can change John Clarke Charts and Charting 3 June 25th, 2004 02:22 AM


All times are GMT +1. The time now is 10:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.