Help me please (Urgent)

dkbrostyle · Mar 18th, 2002, 12:16 AM

Hi I am creating a project, which has to be done,
within this week. The question is that is there a way
that you can link workbooks together so that, when you
type a work in Workbook (A) it would appear on
Workbook (B). Or is there a way that I can link two
macros from different workbooks please.

Thank you for your help and time.
(I'm truly grateful for your time)

Anne Troy · Mar 18th, 2002, 12:18 AM

Check out the help file for *paste link* and for *personal.xls*, I'm thinkin'

Dave Hawley · Mar 18th, 2002, 12:25 AM

To expand on Tuggies help. Open both workbooks, the select any cell in the Workbook you want to have the data update from. type = then go to Window>'Book2.xls' and select the sheet then the cell you want to link to and push Enter. Change the:

$A$1 to absolute or relative.

dkbrostyle · Mar 13th, 2004, 03:01 AM

Hi everyone, i've got the help that i need now, thank you very much. How do i now delete this topic since i don't need it anymore. Because on the forum rules it says you can deltet your posts in this forum.

Aladin Akyurek · Mar 13th, 2004, 03:15 AM

Quote:

Originally Posted by dkbrostyle

Hi everyone, i've got the help that i need now, thank you very much. How do i now delete this topic since i don't need it anymore. Because on the forum rules it says you can deltet your posts in this forum.

You can delete a post of yours within 50 minutes or so if it's the last post in the thread, otherwise you can't.

What you seem to have in mind can't be allowed. Imgaine that X starts a thread. Y replies. If X deletes his/her thread, Y's post would have to be removed along with it. I don't think X should have the right to do that.

Tom Urtis · Mar 13th, 2004, 11:31 AM

dkbrostyle - -

Ok, I'm really curious here...in addition to what Aladin said, why did you resurrect this 2-year old post in the first place, by bringing it all the way up to the top of the heap if you didn't want to call attention to it? You adding your post today just polished off 2 years of dust to a thread that was anonymously buried in the archives anyway.

The other issue is, although you received the information you needed, public forums like this one are excellent sources of information for people having the same question you did. That's one reason why search engines like Google, and the Search link on this site, are so useful, so the same questions don't have to be asked over and over if the answer already exists and is find-able through a search.

Mar 18th, 2002, 12:18 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Check out the help file for paste link and for personal.xls, I'm thinkin' __________________ ~Anne Troy

Mar 13th, 2004, 11:31 AM	#6
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,384	Re: Help me please (Urgent) dkbrostyle - - Ok, I'm really curious here...in addition to what Aladin said, why did you resurrect this 2-year old post in the first place, by bringing it all the way up to the top of the heap if you didn't want to call attention to it? You adding your post today just polished off 2 years of dust to a thread that was anonymously buried in the archives anyway. The other issue is, although you received the information you needed, public forums like this one are excellent sources of information for people having the same question you did. That's one reason why search engines like Google, and the Search link on this site, are so useful, so the same questions don't have to be asked over and over if the answer already exists and is find-able through a search. __________________ Tom Urtis Microsoft MVP - Excel

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

Mar 18th, 2002, 12:16 AM	#1
dkbrostyle New Member Join Date: Mar 2002 Posts: 28	Hi I am creating a project, which has to be done, within this week. The question is that is there a way that you can link workbooks together so that, when you type a work in Workbook (A) it would appear on Workbook (B). Or is there a way that I can link two macros from different workbooks please. Thank you for your help and time. (I'm truly grateful for your time)

Mar 18th, 2002, 12:25 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	To expand on Tuggies help. Open both workbooks, the select any cell in the Workbook you want to have the data update from. type = then go to Window>'Book2.xls' and select the sheet then the cell you want to link to and push Enter. Change the: $A$1 to absolute or relative.

Mar 13th, 2004, 03:01 AM	#4
dkbrostyle New Member Join Date: Mar 2002 Posts: 28	Hi everyone, i've got the help that i need now, thank you very much. How do i now delete this topic since i don't need it anymore. Because on the forum rules it says you can deltet your posts in this forum.