+ Reply to Thread
Results 1 to 3 of 3

Increases formula cell value by a set number down

  1. 04-25-2019, 06:14 PM #1
    fallennoctis
    fallennoctis is offline
    Registered User
    Join Date
    04-25-2019
    Location
    Here
    MS-Off Ver
    2013
    Posts
    2

    Increases formula cell value by a set number down

    Hi,

    I'm trying to create a VBA to fill out a table with 6 different formulas that gather data from the same sheet and compile it nice and neat into a table.
    The six formulas are as follows.
    Please Login or Register  to view this content.
    These are the first two of every formula set and the value always increases by 6 cells down. I have snooped through a lot of things and havent been able to find something that will let me increase the cell count by 6 only one by one down. I attempted to use the macro creator button to figure it out but no such luck.
    Any help would be much appreciated. If you have any questions let me know and I would be glad to assist where I can.
    Reply With QuoteRegister To Reply
  2. 04-25-2019, 11:57 PM #2
    Crooza
    Crooza is offline
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Increases formula cell value by a set number down

    For this line,

    =MID(E12,FIND("Created: ",E12)+8,10)

    change it by replacing the cell reference E12 with the coloured section

    =MID(OFFSET($E$12,6*ROW(1:1)-6,0),FIND("Created: ",OFFSET($E$12,6*ROW(1:1)-6,0))+8,10)

    This will then jump 6 rows for every row you drag the formula down. Is that what you wanted? If so you can work the other ones out
    Happy with my advice? Click on the * reputation button below
    Reply With QuoteRegister To Reply
  3. 04-29-2019, 07:54 PM #3
    fallennoctis
    fallennoctis is offline
    Registered User
    Join Date
    04-25-2019
    Location
    Here
    MS-Off Ver
    2013
    Posts
    2

    Re: Increases formula cell value by a set number down

    That should do it I really appreciate it, sorry it took me so long to reply! Not sure why I didn't find offset's in all of my searching.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Solution time increases with number executions
    By Joakim N in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2018, 03:59 PM
  2. Printing a document where the Doc number increases each print job
    By THC1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2016, 01:20 PM
  3. Formula When Date Entered in One Cell Another Cell Increases or Decreases by 1
    By staffnu123 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-20-2015, 06:56 PM
  4. [SOLVED] Numerical values increases as name increases
    By Jbelle7435 in forum Excel General
    Replies: 3
    Last Post: 09-16-2014, 01:41 PM
  5. macro: The number next to name increases by one
    By dundukas in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-08-2013, 03:33 PM
  6. Macro to insert new line after number increases
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-18-2011, 10:51 PM
  7. Copied number (format as text) increases
    By James Wagner in forum Excel General
    Replies: 2
    Last Post: 10-27-2005, 06:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1