copy a row of data to a column in another workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get the data i enter into my charity subscription workbook, to
be automatically updated in my gift aid register (workbook) so that i do not
have to input twice. The data is entered into the subs register in rows and
the gift aid register is entered in columns. Any ideas would be appreciated.
 
hi,
=('H:\CodeStuff\[ConnectPaths.xls]Sheet1'!D4)
a formula like this in your gift aid register wb will draw
the data over from your charity subscription wb.
I don't know your file paths so you will have to change it
to fit your set up. in the gift aid register wb, put the
file path to the charity subscription wb + sheet + cell.

Regards
Frank
 
Hi Frank,
Thanks for the answer but will this copy as each person will have about 50
cells to link from one workbook to the other. When i tried your answer the
cell reference came up with $ in front.

Frank Stone said:
hi,
=('H:\CodeStuff\[ConnectPaths.xls]Sheet1'!D4)
a formula like this in your gift aid register wb will draw
the data over from your charity subscription wb.
I don't know your file paths so you will have to change it
to fit your set up. in the gift aid register wb, put the
file path to the charity subscription wb + sheet + cell.

Regards
Frank
-----Original Message-----
I am trying to get the data i enter into my charity subscription workbook, to
be automatically updated in my gift aid register (workbook) so that i do not
have to input twice. The data is entered into the subs register in rows and
the gift aid register is entered in columns. Any ideas would be appreciated.
.
Click to expand...
Click to expand...
 
Hi Frank,
I tried your answer but the cell reference camse up with $ in front. if i
understand correctly this is an absolute value and would not allow the
formula to be copied, which is what i want to do as each person has 50 cells
to link

Frank Stone said:
hi,
=('H:\CodeStuff\[ConnectPaths.xls]Sheet1'!D4)
a formula like this in your gift aid register wb will draw
the data over from your charity subscription wb.
I don't know your file paths so you will have to change it
to fit your set up. in the gift aid register wb, put the
file path to the charity subscription wb + sheet + cell.

Regards
Frank
-----Original Message-----
I am trying to get the data i enter into my charity subscription workbook, to
be automatically updated in my gift aid register (workbook) so that i do not
have to input twice. The data is entered into the subs register in rows and
the gift aid register is entered in columns. Any ideas would be appreciated.
.
Click to expand...
Click to expand...
 
Back
Top