i need help and quick
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: i need help and quick

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    london
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!



  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    london
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.



  5. #5
    New Member
    Join Date
    Mar 2002
    Location
    london
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  6. #6
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.



User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com