Consulting

Results 1 to 3 of 3

Thread: Copy data fields macro

  1. #1
    VBAX Contributor
    Joined
    Aug 2007
    Posts
    165
    Location

    Copy data fields macro

    Hi

    Need a macro that will copy data from a fixed range exact match from the same work book, from one work sheet to another.......irresecptive if the work sheet is hidden or not......

    copy from work sheet - original data-

    paste into work sheet accounts-

    data range: D7:CZ200

    thanks

  2. #2
    VBAX Contributor
    Joined
    Aug 2007
    Posts
    165
    Location
    Ignore this question i have solved the problem.....

    thanks

  3. #3
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    [VBA]Worksheets("accounts").Range("D7:CZ200").Value = Worksheets("original data").Range("D7:CZ200").Value[/VBA]
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

Posting Permissions

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