Simple change to list address
 

have a simple list that pulls from multiple worksheets within a
workbook. each cell in the list pulls from just one worksheet. the
list is structured so that the column from these worksheets does not
change but the row does. I go into each cell and change the number of
the cell reference. am trying to learn vba but could use a quick
answer on how to easily change the row number in these cells. thanx

Simple change to list address
 

Can you post some examples of what you have in one of these cell that
you want t the number of the cell reference changed in ?

Xis4Us wrote:
have a simple list that pulls from multiple worksheets within a
workbook. each cell in the list pulls from just one worksheet. the
list is structured so that the column from these worksheets does not
change but the row does. I go into each cell and change the number of
the cell reference. am trying to learn vba but could use a quick
answer on how to easily change the row number in these cells. thanx