Keep Cell Constant, but change after Number

Hi Guys,


I would like to keep a value constant for the first cell link in this and then change it to the next 4 automatically from $2 to $3. Then after that 4 change to $4. I would also like the second cell link to always be A2, A3, A4, A5 for every set of 4 sums I do.


=’Dining Tables’!$A$2&’Dining Chairs’!A2

=’Dining Tables’!$A$2&’Dining Chairs’!A3

=’Dining Tables’!$A$2&’Dining Chairs’!A4

=’Dining Tables’!$A$2&’Dining Chairs’!A5


This is what the first drag down reads, but I would like it to them do this automatically:


=’Dining Tables’!$A$3&’Dining Chairs’!A2

=’Dining Tables’!$A$3&’Dining Chairs’!A3

=’Dining Tables’!$A$3&’Dining Chairs’!A4

=’Dining Tables’!$A$3&’Dining Chairs’!A5


I hope this makes sense. Any help would be appreciated.


Kind regards,



By: Monty

15 thoughts on “Keep Cell Constant, but change after Number


    Greate pieces. Keep writing such kind of info on your site.
    Im really impressed by your blog.
    Hello there, You have done an incredible job. I will definitely
    digg it and in my opinion suggest to my friends.
    I’m sure they’ll be benefited from this website.

  2. coconut oil this

    I just like the valuable info you provide for your articles.
    I will bookmark your weblog and test again right here regularly.
    I am rather certain I’ll be informed many new stuff proper here!
    Good luck for the next!

  3. plenty of fish dating site

    I love your blog.. very nice colors & theme.

    Did you create this website yourself or did you hire someone to
    do it for you? Plz reply as I’m looking to create my own blog and
    would like to find out where u got this from.

  4. quest bars cheap

    Heya i am for the first time here. I found this board and
    I find It truly helpful & it helped me out a lot. I hope to offer one thing again and help others
    such as you aided me.

  5. free trial

    I’m curious to find out what blog system you’re utilizing?

    I’m experiencing some minor security problems with my latest blog and I’d like to find something more secure.

    Do you have any recommendations?

  6. free trial

    When I originally commented I clicked the “Notify me when new comments are added” checkbox
    and now each time a comment is added I get four emails
    with the same comment. Is there any way you can remove me from that
    service? Cheers!

  7. sling tv

    An interesting discussion is definitely worth comment.

    I do believe that you ought to write more about this issue, it might not be a taboo subject
    but typically people do not speak about these issues.

    To the next! Kind regards!!

Leave a Reply

Your email address will not be published. Required fields are marked *