Example: I want to copy the values of cells in sheet A to cells in sheet
B.The values in A are separated by at least 4 rows. Cells in B where I want
those values are separated by 1 row.
How can I copy the values without having to enter each cell reference
indivudually in B?
I know I can Insert "rows" to equal the difference then delete, but my data
consists of hundreds of "source" and "destination" files over several sheets
therefore making changing the ref in the formula about as easy.
Is there a formula to add columns or rows such as cell A1+3 = cell D1 or
cell A1 + 3 = cell A4?
Pulling my hair out!
Thank You
--
....kev...