+ Reply to Thread
Results 1 to 3 of 3

Need a Macro to increment the Cell Reference over and over

  1. #1
    Registered User
    Join Date
    12-08-2014
    Location
    UK
    MS-Off Ver
    MS Office 2013
    Posts
    2

    Need a Macro to increment the Cell Reference over and over

    Hi guys, I'm very new to VBA so please be gentle.

    I've got a spreadsheet that has 3 sheets, the first sheet has several cells with formulas in that reference cells on the other 2 sheets.

    Some of these formulas look as follows:

    =Sheet3!L3

    =IF(ISBLANK(Sheet3!DJ3),"Unable to Provide","")

    And so on...

    What I need is a Macro that I can link to a Command button so that every time the button is pressed, the 'row' reference in each of the formulas increases by one.

    Can anyone point me in the right direction please?

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Need a Macro to increment the Cell Reference over and over

    are you wanting this in order to populate a worksheet with the functions? ie youve got a full row of functions in row 3 and want them to go down to row 5000?

    if so just highlight the cells and drag them down the required number of rows
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    12-08-2014
    Location
    UK
    MS-Off Ver
    MS Office 2013
    Posts
    2

    Re: Need a Macro to increment the Cell Reference over and over

    No, I'm wanting to extract 10 answers from a selection of 170 questions from a survey of 100 respondents. The questions are the columns on the 2 back sheets and the respondents are the rows.

    What I am wanting to see on the front sheet at any one time is the answers to those 10 questions for each respondent one at a time. The relevance of row 3 is that is the first respondent's set of answers.

    I want to be able to click through the same set of 10 answers for each respondent every time I click the macro command button.

    Does this make any more sense?

+ 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. Cell reference increment other than 1
    By Nickolai in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-07-2014, 05:13 PM
  2. Increment cell reference
    By George.ca in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2014, 11:18 PM
  3. [SOLVED] Increment Cell Reference
    By XLVBA in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2012, 08:33 AM
  4. Increment Cell Reference
    By Perry in forum Excel General
    Replies: 4
    Last Post: 03-08-2006, 04:20 AM
  5. A2 cell reference increment
    By cejones in forum Excel General
    Replies: 3
    Last Post: 11-07-2005, 11:45 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