Jan 03, 2013 How to create a reference between a column and a row of another sheet and vice versa Excel VBA? Question. However, now I would like to link cells from another sheet. However, the program I wrote could not make reference among cells from one sheet to another sheet. Example. Sheet1, Column A. How to copy rows from one excel sheet to