Results 1 to 2 of 2

Thread: Copy Columns and Formula to a Database sheet

  1. #1

    Thread Starter
    Junior Member
    Join Date
    May 2005
    Posts
    20

    Copy Columns and Formula to a Database sheet

    hi all
    i need use 1 of my excel file(book3) to supply different formula to different excel file example (book4) in sheet2 and copy some of the column in book4 (sheet 1 into sheet 2).any 1 know how am i able to do that without typing any coding in book4 cause making it for an end user all coding is done in book3 thx.sorry for my poor explaination if is confusing but any one can help thx my excel file in the zip
    Attached Files Attached Files

  2. #2
    PowerPoster lintz's Avatar
    Join Date
    Mar 2003
    Location
    The 19th Hole
    Posts
    2,697

    Re: Copy Columns and Formula to a Database sheet

    Record a Macro in Excel and then once recorded click Tools --> Macro --> Visual Basic Editor and view the code required to do what you want. HTH

Posting Permissions

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



Click Here to Expand Forum to Full Width