Is there a way to edit forumla eg. =Input!A1 into =Input!"A"&"1" ?(input is the tab name) because I need to drag right and copy across for a formula increase of +2
eg. I am trying to transfer data from 1st tab to second tab. But data only exist every 2nd cell
Instead of typing =Input!A1, =Input!A3, =Input!A5 on separate cells in a second tab., or manually clicking and matching to previous tab. is there a way to quickly +2 for the numbers?
Thanks!
Bookmarks