+ Reply to Thread
Results 1 to 2 of 2

VBA to copy data across a range based on the number of buildings required

  1. #1
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    865

    VBA to copy data across a range based on the number of buildings required

    Evening all,

    I've been given a customer template and require a macro to use it as a basis to populate cells elsewhere in the workbook.

    I've recreated an example of the data I'm working with that uses the same ranges and I've also included some further guidance/instructions (see attached).

    If it helps this is a solution I was provided with previously but unfortunately due to the customer template changing is no longer workable. I did try to figure out how to make the necessary adjustments but was unsuccessful.

    Link

    If you have any queries just give me a shout.

    Thanks in advance,

    Snook
    Last edited by The_Snook; 05-07-2018 at 06:23 AM. Reason: Updated

  2. #2
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    865

    Re: VBA to copy data across a range based on the number of buildings required

    Morning all,

    I'm assuming that I didn't explain my requirement clearly enough given the lack of responses. As such I've tried to reword and provide a bit more detail around what I'm looking to achieve.

    I'd be massively grateful if someone could assist me.

    Thanks in advance,

    Snook

+ 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] VBA to replicate a range of cells based on the number of buildings required
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-22-2018, 11:09 AM
  2. Replies: 1
    Last Post: 12-05-2016, 12:04 PM
  3. [SOLVED] Need to fill a grid of cells with data, based on percentage amount specified.
    By Traymond in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-25-2016, 08:07 PM
  4. [SOLVED] Split the data to new files based on the date and name it from the list provided
    By Jul Stev in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-09-2014, 04:26 AM
  5. [SOLVED] Replicate a data range
    By Excel_learner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2014, 09:57 AM
  6. Previous Set Amount of Cells With Data as Range
    By ARayburn in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-17-2013, 05:33 PM
  7. [SOLVED] Add a fractional amount for a range of cells of similar, but different data
    By MGatESSInc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2013, 05:42 PM

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