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

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


    Hello, there. I understand this kind of is off-topic, but I got wondering which blog system are you using intended for this site? I’m receiving fed up of Wp because I’ve had issues with hackers and Now i’m looking at options regarding another platform. I might be fantastic should you can point me in direction of some sort of good platform.

  2. wisata gadang tembok

    Hmm, it seems like your current site ate my initial comment (it was incredibly long) so I speculate I’ll just sum that up the things we had written and point out, I’m thoroughly enjoying your own blog. I as nicely is an aspiring blog page writer, but I’m even now new to the complete thing. Do you possess any suggestions for newbie blog freelance writers? I’d appreciate it.

  3. produksicetak

    When I initially mentioned, I clicked the “Notify me when new remarks are added” checkbox plus now every time a new comment is added We get several emails with all the same comment. Is generally there in whatever way a person can remove people because a result service? Cheers.


    At the moment, it seems such as WordPress is the desired blogging platform available ideal now. (from what I have read) Is the fact that what if you’re using in your blog? Wonderful post, yet , I had been wondering if you can write a little a lot more on this subject?

  5. seo bisnis online

    I enjoy that which you guys are usually upwards too. This sort associated with clever work and protection! Keep up the fantastic works guys I’ve included you guys to my personal blogroll.

  6. jalan jalan ke arab

    My partner and i and my local freinds were going by way of the nice, helpful suggestions coming from the blog then the particular sudden came up using an awful suspicion My partner and i never expressed respect for the website owner for individuals secrets.

  7. Buy CBD Topicals Online

    I’m no longer positive the place you’re getting your info, however good topic. I must spend a while learning much more or working out more. Thank you for fantastic info I was in search of this information for my mission.

  8. anabolika kaufen

    Having read this I thought it was very informative. I appreciate you taking the time and effort to put this article together. I once again find myself spending way to much time both reading and commenting. But so what, it was still worth it!

  9. Buy Reductil Europe

    I am not sure where you are getting your info, but good topic. I needs to spend some time learning much more or understanding more. Thanks for excellent info I was looking for this info for my mission.

Comments are closed.