I have a report that has 2 sheets, the first sheet(1) contains data, sheet (2) a table linked to sheet(1) and a graph feeding from the linked data in sheet(2).
I want to insert a from that will show filtered data from a report in Sheet1. The reason Sheet 1 is visible to a lot of people and don’t want to modify the format, I want to show the data filtered for the 5 types of criteria use in this report. So, I created the form, inserted a Multipage object, and a Excel Sheet in page 1. Now how can you link the data from Sheet1 of the report to the From sheet in VBA . I tried using the inserting “=” in the Forms cell and then go to the Sheet1 of reports click on a cell, press enter and it doesn’t “link” the data. Also try to use the formula that I have in the Linked table in Sheet 2 of the report on the From Sheet and doesn’t work too.Any of the copy commands (between the Report Sheet and Form Sheet) wont work.
Can somebody explain how this Sheet object in the Form can be linked to data in the Report Sheets?

Thanks guys!