Here is my issue.
I'm combining 3 spreadsheets into one. I would like for all the spreadsheets to update the one...including when rows are added to them. I have been able to link individual cells from one worksheet to another but that doesn't solve the problem of added rows. I wondered briefly if this would be solved by linking a list but I can't even figure out how to do it. I'm currently using Excel 2003. Any help whatsoever would be appreciated.
Thanks in advance,
Bubb
I'm combining 3 spreadsheets into one. I would like for all the spreadsheets to update the one...including when rows are added to them. I have been able to link individual cells from one worksheet to another but that doesn't solve the problem of added rows. I wondered briefly if this would be solved by linking a list but I can't even figure out how to do it. I'm currently using Excel 2003. Any help whatsoever would be appreciated.
Thanks in advance,
Bubb