I have created a spreadsheet that I have to enter data into on a weekly
basis. And when I enter this data, I need it to update it's totals into
another worksheet. I have linked both sheets together so everything is
working great! However, there is one thing that I would love to correct if
it is possible.

When I enter my weekly information, I enter it in a downward manner
(A1,A2,A3, etc.)

But the linked worsheets fields are going accoss. (A1,B1,C1, etc). Is
there a way that even though I entered my data in a downward fashion, it
would still update the linked sheet going across with my information.

The only soulution that I came up with was to redesigned the spreadsheets
and make the collums for them same.

If there is a better way than this, please let me know. Thanks.

I actually do not prefer to use any types of links. They tend to get broken
or corrupted from time to time.

Instead I prefer to use a macro to send (or receive) the data I need.

You may consider utilizing one spreadsheet as a database (or data source)
and look into using some type of ADO connection to retrieve or send your
data.

Let me know if I can help out with this project...

Mark

"SIRSTEVE" wrote in message
...
I have created a spreadsheet that I have to enter data into on a weekly
basis. And when I enter this data, I need it to update it's totals into
another worksheet. I have linked both sheets together so everything is
working great! However, there is one thing that I would love to correct
if
it is possible.

When I enter my weekly information, I enter it in a downward manner
(A1,A2,A3, etc.)

But the linked worsheets fields are going accoss. (A1,B1,C1, etc). Is
there a way that even though I entered my data in a downward fashion, it
would still update the linked sheet going across with my information.

The only soulution that I came up with was to redesigned the spreadsheets
and make the collums for them same.

If there is a better way than this, please let me know. Thanks.

Thanks Mike for wanting to assist me with my project. I would certainly
appreciate your help. How should we proceed?

"Mark Ivey" wrote:

I actually do not prefer to use any types of links. They tend to get broken
or corrupted from time to time.

Instead I prefer to use a macro to send (or receive) the data I need.

You may consider utilizing one spreadsheet as a database (or data source)
and look into using some type of ADO connection to retrieve or send your
data.

Let me know if I can help out with this project...

Mark

"SIRSTEVE" wrote in message
...
I have created a spreadsheet that I have to enter data into on a weekly
basis. And when I enter this data, I need it to update it's totals into
another worksheet. I have linked both sheets together so everything is
working great! However, there is one thing that I would love to correct
if
it is possible.

When I enter my weekly information, I enter it in a downward manner
(A1,A2,A3, etc.)

But the linked worsheets fields are going accoss. (A1,B1,C1, etc). Is
there a way that even though I entered my data in a downward fashion, it
would still update the linked sheet going across with my information.

The only soulution that I came up with was to redesigned the spreadsheets
and make the collums for them same.

If there is a better way than this, please let me know. Thanks.