+ Reply to Thread
Results 1 to 1 of 1

repeat cells

  1. #1
    Forum Contributor
    Join Date
    12-18-2015
    Location
    scotland
    MS-Off Ver
    MS office 365 business
    Posts
    187

    repeat cells

    Hi

    I've completely forgot how to do this, I have a spreadsheet with a set of data, its for recording weekly takings. The way the sheet was set up you highlighted a specific cell by using keys clt + n this would copy the cells and put a new lot of blank cells directly under the previous one with all the formula/s in tact.

    I.va attached what I think it looks like

    Thanks
    toddp

    sample.xlsx

    I've been looking and its a macro but when I click on the cell rather than creating the next set of cells it creates a new worksheet
    Last edited by toddp2; 01-31-2016 at 01:07 PM. Reason: more information

+ 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. Replies: 4
    Last Post: 03-08-2014, 08:01 AM
  2. macro to cut first non zero cells to the first blank cells and repeat it
    By nasim12w in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2013, 10:54 AM
  3. Conditional formatting between 2 cells and then moving down to the next 2 cells to repeat
    By DebbieEdwards in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2013, 06:55 AM
  4. Merge data from cells on 2nd columns in which the cells of 1st column repeat
    By jagke in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-14-2013, 01:06 PM
  5. sum cells until value met and then repeat
    By pquack001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2012, 02:23 AM
  6. sum cells until value met and then repeat
    By pquack001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2012, 08:59 AM
  7. [SOLVED] Macro to repeat action too a range of cells with assending numbers in the cells.
    By 2k05gt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2012, 02:13 PM
  8. Copy data from one set of cells to another cells and repeat the process -sheet attach
    By talhawahab in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-26-2011, 03:50 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