Results 1 to 3 of 3

Auto generate data in multiple cells

Threaded View

  1. #1
    Registered User
    Join Date
    01-19-2016
    Location
    Glasgow
    MS-Off Ver
    2013
    Posts
    42

    Auto generate data in multiple cells

    Hi there!

    I have a sheet that is large and full of formulas that I would rather not have to mess around with (please find attached) I basically need to insert a "running cost" and "final invoice" column, after every "Yard" column across every sheet (so 20ish new columns across 30 sheets) with the running cost columns having the same info entered into the corresponding cells in the individual yard colums (ie yard 01- R10 will be automatically copied into Running Cost 01 S10 and so forth)

    Is there a quick way of doing this, or will I just have to take it sheet by sheet?

    Many thanks in advance for any help you guys can give!
    Attached Files Attached Files
    Last edited by Kirstyamanda; 12-06-2017 at 11:12 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 10-31-2016, 01:56 PM
  2. [SOLVED] auto generate titles to multiple sheets from a list
    By dtorres4043 in forum Excel General
    Replies: 10
    Last Post: 10-21-2015, 11:43 AM
  3. Excel Auto generate sheets with data in a summary VBA
    By markyspicer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2015, 08:13 PM
  4. Auto-Generate List from reference cells based on data validation list selection
    By BoundCustomDesign in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-13-2014, 11:06 AM
  5. Replies: 0
    Last Post: 02-26-2013, 05:08 AM
  6. Auto Generate Data Based on Other Data Entered
    By chelleleigh in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-28-2012, 01:51 PM
  7. auto generate a comment box based on a cell value that has variable reference cells
    By vamedic11 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-31-2010, 06:56 AM

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