+ Reply to Thread
Results 1 to 4 of 4

Look in entire column and copy/paste data as new workbook

  1. #1
    Forum Contributor
    Join Date
    04-06-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    103

    Look in entire column and copy/paste data as new workbook

    Hi,

    I'm trying to write a macro but having a little trouble...

    I would like to look at each cell in Column B (worksheet "master") and set this as a variable called "currentaccount"... i would then like to go to a sheet called "data" and find the "currentaccount" variable in Column A, select the entire row the copy and paste the entire row to a new workbook called "currentaccount". Then repeat this entire process until all accounts listed in column B, master worksheet have had a file created.

    Hope that makes sence
    Thanks

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Look in entire column and copy/paste data as new workbook

    What do you have so far?
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Forum Contributor
    Join Date
    04-06-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    103

    Re: Look in entire column and copy/paste data as new workbook

    Unfortunately, absolutely nothing at all - im really struggling with knowing where to start so any ideas at all would be great

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Look in entire column and copy/paste data as new workbook

    The first bit will be the find stuff to copy

    have a look at
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1