Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking worksheets after runnning report
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help linking worksheets | New Users to Excel | |||
linking worksheets in same workbook | Excel Discussion (Misc queries) | |||
Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel | |||
Simplify Linking to several worksheets?? | Excel Worksheet Functions | |||
Linking Data between worksheets in a workbook | Excel Worksheet Functions |