O.k. please bear with me for this one I will try my best to explain. I am
running a report (layout) using peoplesoft software and it returns the
information in excel. When I run the layout the criteria is entered in one
row, say A4 for example. The problem is that when I run the report (layout)
the information expands. So I now have information in cel A4 - A10 (or
wherever the data ends) on my layout worksheet. I want to link the layout
worksheet to a different worksheet so I can format it, and display it in a
more visually appealing manner. The problem is with the link. Before I run
the report I link up the cell in the worksheet where I wish to display the
information, to A4 in the alyout worksheet. After running the report and
having the information expand it starts the information at cell A10(or where
ever the data stops). I want to know if there is a way to link it or solve
this problem in anyway without a macro. I built a macro that I run after the
report is run, so I can retrieve all the information, but I do not have
enough VBA knowledge to do what I wish. . . . . Keep in mind that the
problem is not linking the data after the report is run, but the problem is
linking the information before the report is run, then running the report,
and having the link move (acting as if it is absolute referenced ($)).
Hopefully this isnt too confusing. Thank you in advance