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