Hi all, I have a table that copies data from another cell on the page (using formula =C1) and the cell next to it is (=C3) and the cell next to that is (=B1). So i have to manually click on c1, c3, b1 every time i have new data to add to this table.

Is there a way i can click on =c1 and it copies c3 and b1 at the same time (keeping in mind c1 is always the main cell i click on, and the number is c3 will always be 2 cells to the right and b1 will always be 1 cell below)

Is there a way of doing this?


Thanks so much!