I have information from A1 to G1 down to A10 to G10
I want to reuse that information in a report but it only can bring in one "line" of data at a time.
So, I want to start at A30 and =A1. That will bring in A1's data, but when I do that I want B1:G1 to come in automatically. Then when I type in =A2, B2:G2 data comes in automatically, etc.
I know I can type in =A1, then copy cell right and that will do it, but there are other considerations, so I can't just "copy right", then adjust as needed. So it has to be something similar to: (A30) =A1 (B30)=A30+1 (that just adds one to the previous cell not brings in B30's info).
Range Update Problem.xls
Bookmarks