+ Reply to Thread
Results 1 to 5 of 5

Copy & Paste Column with Data in the next available column in the same worksheet

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    3

    Copy & Paste Column with Data in the next available column in the same worksheet

    Hi Everyone

    First time user and absolute noob at VBA so I would realy appreciate your help with my problem.

    I have a data set on worksheet called "Demand" and its set out as follows:

    Column B2:B58 contain static labels and
    Column C2:C58 contains the default, blank lists described in D2:D58
    Column D2:D58 contain a series of drop-down lists, text field that users have to complete and select.

    I want to create a button ("Add new Record") located at B1 that copies all the formulas, drop-down lists, formatting etc from C2:C58 into the next available column - which would be E2:E58 and F2:F58, G2:G587, etc , every time you select the "Add New Record" Button.

    I would be most thankful for any assistance you can offer. Thanks Bruce.

  2. #2
    Forum Contributor
    Join Date
    10-19-2012
    Location
    Omaha, Nebraska USA
    MS-Off Ver
    Excel 2010
    Posts
    249

    Re: Copy & Paste Column with Data in the next available column in the same worksheet

    Hi Bruce,

    If you post the file itself, I will take a look at it? Making a button to copy a row of cells won't be too hard, but I want to make sure it is capturing what you are wanting it to and it would be easier to just use the sheet you made rather than me coming up with a dummy file. If you hit the "Reply to Thread" button rather than the "quick reply", it should have an option down towards the bottom that allows you to post a file. I use Excel 2003, so we should be compatible if that is the version you used to create the file.

    Thanks,

    Daniel

  3. #3
    Registered User
    Join Date
    01-14-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Copy & Paste Column with Data in the next available column in the same worksheet

    Hi

    Here is the actual file that I am working off.AddButton-20130116.xlsx

    Bruce

  4. #4
    Forum Contributor
    Join Date
    10-19-2012
    Location
    Omaha, Nebraska USA
    MS-Off Ver
    Excel 2010
    Posts
    249

    Re: Copy & Paste Column with Data in the next available column in the same worksheet

    Hi Bruce,

    For some reason, I can't open *.xlsx files although I've been told I should be able to. If you want to save it as an *.xls file, (Excel 97-2003), I can open those.

    Thanks,

    Daniel

  5. #5
    Registered User
    Join Date
    01-14-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Copy & Paste Column with Data in the next available column in the same worksheet

    Hi Daniel

    Here you go and thanks you.AddButton-20130116.1.xls

+ 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