i need help and quick

dredpipin · Mar 12th, 2002, 07:33 AM

i need 2 know how to link information between workbooks.For example i hav a workbook which contains information that i want to send to an invoice sheet.But i still want it to exist in then original workbook e.g copying not cutting.Please respond a.s.a.p

Dave Hawley · Mar 12th, 2002, 07:37 AM

Open both Workbooks. In the one you want to duplicate information type:
=
in a cell then go to Window>"Your other workbook" select the sheet then the cell and push Enter. Double click back in the cell, or go to the formula bar and and cycle through pushing F4 to go from absolute to relative reference then copy the formula to wherever!

dredpipin · Mar 12th, 2002, 07:48 AM

Ah but you misunderstood,i wanted to know how to transfer information such as:-Name,address,telephone etc... and duplicate it to the invoice via a macro because it must be repeated for a amateur user.sorry 4 the lack of info

Dave Hawley · Mar 12th, 2002, 07:53 AM

Hi dredpipin

That would take some detailed information to get that done. You can either record a macro, or (probably best) save your workbook as another name and delete what you don't want.

dredpipin · Mar 12th, 2002, 08:08 AM

could u possibly write me an example of how to get around it or give me a technical name for the action so i can research it.Has it got any relations to do with pivot tables.rsvp

Dave Hawley · Mar 12th, 2002, 08:36 AM

Hi dredpipin

Sorry, I wouldn't have the time, as I say it would require a lot of detail. I am sure that if you repost you will get a response here. There are loads of kind helpers here.

Have you tried just a simple formula reference? I feel sure it could pull in the needed data.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 07:33 AM	#1
dredpipin New Member Join Date: Mar 2002 Location: london Posts: 5	i need 2 know how to link information between workbooks.For example i hav a workbook which contains information that i want to send to an invoice sheet.But i still want it to exist in then original workbook e.g copying not cutting.Please respond a.s.a.p

Mar 12th, 2002, 07:37 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Open both Workbooks. In the one you want to duplicate information type: = in a cell then go to Window>"Your other workbook" select the sheet then the cell and push Enter. Double click back in the cell, or go to the formula bar and and cycle through pushing F4 to go from absolute to relative reference then copy the formula to wherever!

Mar 12th, 2002, 07:48 AM	#3
dredpipin New Member Join Date: Mar 2002 Location: london Posts: 5	Ah but you misunderstood,i wanted to know how to transfer information such as:-Name,address,telephone etc... and duplicate it to the invoice via a macro because it must be repeated for a amateur user.sorry 4 the lack of info

Mar 12th, 2002, 07:53 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi dredpipin That would take some detailed information to get that done. You can either record a macro, or (probably best) save your workbook as another name and delete what you don't want.

Mar 12th, 2002, 08:08 AM	#5
dredpipin New Member Join Date: Mar 2002 Location: london Posts: 5	could u possibly write me an example of how to get around it or give me a technical name for the action so i can research it.Has it got any relations to do with pivot tables.rsvp

Mar 12th, 2002, 08:36 AM	#6
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi dredpipin Sorry, I wouldn't have the time, as I say it would require a lot of detail. I am sure that if you repost you will get a response here. There are loads of kind helpers here. Have you tried just a simple formula reference? I feel sure it could pull in the needed data.