I am working with Microsoft Excel 2003. I am trying to import(or something
like it) from worksheet (A) to worksheet (B). Worksheet A is a spreadsheet
that I have saved to keep the same row names, etc. but the information within
the named cells is forever changing. I also save the information from
worksheet A, but have another copy that when I open, it always opens without
any changed data in it. MY question/problem is that I need to import the
data from A to B, and every time that A changes, I need B to automatically
update the data and continuously add to the spreadsheet I have made up for B.
I can NOT have A overwrite any data that I have already put into B.

In Worksheet B
choose the cell that needs to read a cell from Worksheet A
hit the = sign now use your mouse to click on the cell in worksheet A
that you want read into B
Or use in WorksheetB Cell A1
=IF('WorksheetA!$A$1<"",WorksheetA!$A$1,"")
(replace cell value ,drag formula ,or copy paste special formula where
needed)
This allows for blank cells to stay blank until used







"Jillian" wrote:

I am working with Microsoft Excel 2003. I am trying to import(or something
like it) from worksheet (A) to worksheet (B). Worksheet A is a spreadsheet
that I have saved to keep the same row names, etc. but the information within
the named cells is forever changing. I also save the information from
worksheet A, but have another copy that when I open, it always opens without
any changed data in it. MY question/problem is that I need to import the
data from A to B, and every time that A changes, I need B to automatically
update the data and continuously add to the spreadsheet I have made up for B.
I can NOT have A overwrite any data that I have already put into B.

UFO_PILOT-
I TRIED DOING THE FORMULA THAT YOU HAVE GIVEN ME, AND IT PUT ONE PERSON'S
INFORMATION INTO ALL THE CELLS THAT I DRAGGED THE FORMULA INTO. DID I DO
SOMETHING WRONG? NONE OF THE CELLS STAYED BLANK, AND WHEN I CHANGED THE DATA
IN THE FIRST WORKSHEET, THE DATA WAS OVERWRITTEN AGAIN. PLEASE HELP ME
UNDERSTAND WHAT IT IS THAT YOU WANT ME TO DO. MAYBE IT WOULD HELP, BUT MY
WORKSHEET NAMES ARE ACTUALLY: BLANK WO AND CUSTOMER LIST

"ufo_pilot" wrote:

In Worksheet B
choose the cell that needs to read a cell from Worksheet A
hit the = sign now use your mouse to click on the cell in worksheet A
that you want read into B
Or use in WorksheetB Cell A1
=IF('WorksheetA!$A$1<"",WorksheetA!$A$1,"")
(replace cell value ,drag formula ,or copy paste special formula where
needed)
This allows for blank cells to stay blank until used







"Jillian" wrote:

I am working with Microsoft Excel 2003. I am trying to import(or something
like it) from worksheet (A) to worksheet (B). Worksheet A is a spreadsheet
that I have saved to keep the same row names, etc. but the information within
the named cells is forever changing. I also save the information from
worksheet A, but have another copy that when I open, it always opens without
any changed data in it. MY question/problem is that I need to import the
data from A to B, and every time that A changes, I need B to automatically
update the data and continuously add to the spreadsheet I have made up for B.
I can NOT have A overwrite any data that I have already put into B.

I had a co-worker try to help me with the formula, and he is as stumped as I
am with the reasoning of the formula. My new question now is...can I email
you a fake copy of the two worksheets that I am working on so that you can
fully understand what I am working with and trying to do? And if I can, how
do I get both spreadsheets to email to you in the exact format that they are
currently in.

"ufo_pilot" wrote:

In Worksheet B
choose the cell that needs to read a cell from Worksheet A
hit the = sign now use your mouse to click on the cell in worksheet A
that you want read into B
Or use in WorksheetB Cell A1
=IF('WorksheetA!$A$1<"",WorksheetA!$A$1,"")
(replace cell value ,drag formula ,or copy paste special formula where
needed)
This allows for blank cells to stay blank until used







"Jillian" wrote:

I am working with Microsoft Excel 2003. I am trying to import(or something
like it) from worksheet (A) to worksheet (B). Worksheet A is a spreadsheet
that I have saved to keep the same row names, etc. but the information within
the named cells is forever changing. I also save the information from
worksheet A, but have another copy that when I open, it always opens without
any changed data in it. MY question/problem is that I need to import the
data from A to B, and every time that A changes, I need B to automatically
update the data and continuously add to the spreadsheet I have made up for B.
I can NOT have A overwrite any data that I have already put into B.

A slight amendment to UFO's formula:

=IF('WorksheetA!A1<"",WorksheetA!A1,"")

If you type this into WorksheetB Cell A1 then copy across and down as
appropriate. This will reflect the values in WorksheetA, though you
might have to format some columns and adjust widths etc.

Hope this helps.

Pete

Another slight adjustment <vbg:

=IF('WorksheetA'!A1<"",'WorksheetA'!A1,"")

You don't always need the apostrophes, but if you use one, you'll need both.

If you type them in and excel doesn't need them, excel will get rid of them.

Pete wrote:

A slight amendment to UFO's formula:

=IF('WorksheetA!A1<"",WorksheetA!A1,"")

If you type this into WorksheetB Cell A1 then copy across and down as
appropriate. This will reflect the values in WorksheetA, though you
might have to format some columns and adjust widths etc.

Hope this helps.

Pete

--

Dave Peterson

Thanks, Dave,

I copied the original formula and amended the $ signs - I didn't spot
the single apostrophe.

Pete

Do I have to put this formula into each individual cell that I need it in
then? Bc the data that I am transfering over has column and row headers and
I need what is in those column and rows to match the column headers that I
have in the second worksheet?

"Dave Peterson" wrote:

Another slight adjustment <vbg:

=IF('WorksheetA'!A1<"",'WorksheetA'!A1,"")

You don't always need the apostrophes, but if you use one, you'll need both.

If you type them in and excel doesn't need them, excel will get rid of them.

Pete wrote:

A slight amendment to UFO's formula:

=IF('WorksheetA!A1<"",WorksheetA!A1,"")

If you type this into WorksheetB Cell A1 then copy across and down as
appropriate. This will reflect the values in WorksheetA, though you
might have to format some columns and adjust widths etc.

Hope this helps.

Pete

--

Dave Peterson

Do I have to put anything within the two quotes right behind the greater
than/less than signs or behind the second !A1?? Because I tried to put it
in, and Excel said that there was an error in the formula.
Also, would it be possible to send someone/anyone a copy of what I am trying
to accomplish so that you can see for yourself what it is that I am looking
at and what I am trying to do? Thank-you!



"Dave Peterson" wrote:

Another slight adjustment <vbg:

=IF('WorksheetA'!A1<"",'WorksheetA'!A1,"")

You don't always need the apostrophes, but if you use one, you'll need both.

If you type them in and excel doesn't need them, excel will get rid of them.

Pete wrote:

A slight amendment to UFO's formula:

=IF('WorksheetA!A1<"",WorksheetA!A1,"")

If you type this into WorksheetB Cell A1 then copy across and down as
appropriate. This will reflect the values in WorksheetA, though you
might have to format some columns and adjust widths etc.

Hope this helps.

Pete

--

Dave Peterson