2 Table extend simultaneously

Hi guru,

i'm having some difficulties to sync 2 tables coz if I extend Table A, i have to redo formulas at Table B. So, is it possible if both table extend simultaneously and the formula used will extend automatically?

I'm not sure if this will serve your purpose, but it might get you in the right direction. I'm assuming table A on Sheet1 and table B on Sheet2.

For the column(s) which you want to match in Table B, type the following formula and copy down as far as you wish:

=IF(Sheet1!A2<>"",Sheet1!A2,"")

This will leave blank cells in Table B until the corresponding cell in Table A is populated.

I hope this idea helps!

I had the same issue, only after reinstall problem was solved.