Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: HELP!!!!!!

  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 2 COPY DATA VIA A MACRO FROM ONE WORKBOOK TO ANOTHER REPEATEDLY.E.G FROM AN INVOICE SHEET TO A CUSTOMER PROFILE WORKBOOK.PLEASE RESPOND ASAP

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi dredpipin
    You will need to give more details. Are you copying entire rows, individual cells, whole ranges? Where exactly do you want them to end up? Try to give a simple but precise example.
    regards
    Derek

  3. #3
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Perhaps instead of copying, you could make your Workbook a template and use the Template Wizard with Data-Tracking Add-in. See the link below for info.

    http://support.microsoft.com/search/...;en-us;Q214246

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

    Default

    i want 9 cells of information to be transfered from an invoice sheet and placed into another workbook where i want the details to be displayed.it will contain digits and letters but no formulas.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To record a macro:
    go to Tools, Macro, Record New Macro.
    A dialogue box will open where you can name your macro and designate key strokes to run it. From then on every action you take will be recorded in code. Just select the area you wish to copy, then select the workbook and worksheet you want it to go to and paste it. Press Esc on your keyboard (ends copy mode)
    go to Tools, Macro, Stop Recording.
    Now when you use your designated keystrokes the macro will copy from the same range and paste to same range exactly as you recorded it.
    If you wish you can assign this macro to a button. You do this by customising your toolbar. Select the button icon from the Forms section. Click on this icon to draw an oblong button on your sheet. Right click the button and select Assign Macro. select your macro's name.
    Hope this helps
    regards
    Derek

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dredpin,

    is this from a sales invoice sheet or from a purchase invoice sheet ?

Some videos you may like

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
  •