+ Reply to Thread
Results 1 to 2 of 2

Copy a column from one sheet and append to another

  1. #1
    Registered User
    Join Date
    02-14-2018
    Location
    Germany
    MS-Off Ver
    Office 2017
    Posts
    1

    Question Copy a column from one sheet and append to another

    Hi everybody,

    I am a quiet a beginner to VBA and my boss asked me to write a macro to process some data in our excel files. After 1 hour of using google I still have no clue and really hope that you guys can help me. Probably it is an easy task for most of you. So here is the problem:

    Input:
    For every month i have a different sheet in my excel file, January to December and at the end I have something like a balance sheet. In each monthly sheet I have one to ten different projects with various data for each project. The data for each project is the same (it's standardized) and it is saved from K96 to K136 for project one, K142 to K180 for project two and so on...

    Output:
    I want to create a button next to each project, which copies the values of this specific project, let's say K96 to K136 and appends the data to the balance sheet in the same order. I don't want to copy every project to the balance sheet so the macro shouldn't process like: copy data from Project 1 January and add it to B1-B40 of the balance sheet and Project 2 January to C1-C40. But it should append it to the right. So it should check for blank cells.

    I hope you can understand my problem. It is quite hard to explain this in text...but I am very happy to get some help!! Thanks a lot guys.

    Greets
    VBegginerA
    Last edited by VBeginnerA; 02-14-2018 at 09:30 AM.

  2. #2
    Registered User
    Join Date
    02-14-2018
    Location
    Highlands, UK
    MS-Off Ver
    365 Excel 2016
    Posts
    3

    Re: Copy a column from one sheet and append to another

    Hi VBeginnerA, I'm a newb myself and learning, so not in a position to answer you.
    Might I suggest you include a spreadsheet as an example? Make a mock-up if it has sensitive data.
    Steve

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy and Append data to another sheet
    By Gerben015 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-30-2016, 10:36 AM
  2. Replies: 2
    Last Post: 01-22-2014, 05:36 PM
  3. Copy table01, append to tableA on another sheet, create sub-tables therein
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2014, 06:12 PM
  4. copy from one sheet and append in another one
    By mmf in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-01-2013, 02:06 AM
  5. [SOLVED] Open column of url's as csv files and append as new sheet
    By rgilpatric in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-04-2012, 09:18 AM
  6. Replies: 1
    Last Post: 07-17-2012, 11:05 PM
  7. Find in text - and copy/append to other sheet
    By excaliburst in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2009, 11:29 PM

Tags for this Thread

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