Hello,
Is there a way to link a table to another table and have the linked table update as the main one gets updated? What i have is a sheet with a table of a years worth of data, that is updated every day. I will take this data and sort it, say by name and then print it it out as a report. What i would like to do is to have multiple sheets with each sales persons name, on each sheet have a table that would dynamically update as i update the main table.
Any advice or help is appreciated.
Thanks, Schmill
Is there a way to link a table to another table and have the linked table update as the main one gets updated? What i have is a sheet with a table of a years worth of data, that is updated every day. I will take this data and sort it, say by name and then print it it out as a report. What i would like to do is to have multiple sheets with each sales persons name, on each sheet have a table that would dynamically update as i update the main table.
Any advice or help is appreciated.
Thanks, Schmill
