Link Data in One Tab & Then Link Other Data to Another Tab

Hi,

I have a huge workbook broken up via months in individual tabs. I am trying to link data into the worksheet via month(each tab), but I have run into a problem. If I link it in one month, I don't know how to stop the link or get a new link for another month? The link carries on to each month but I don't want to prior month's data to change. I want to gather new data in each month by using the same links but linked to another spreadsheet. Does this make sense?? Does anyone know how to do this??

I basically want to keep the data I linked in one tab and have new data for the next month updated via a link. The cuts down on me typing it all in.

Please help me-- SEOT

Originally Posted by SEOT

Hi,

I have a huge workbook broken up via months in individual tabs. I am trying to link data into the worksheet via month(each tab), but I have run into a problem. If I link it in one month, I don't know how to stop the link or get a new link for another month? The link carries on to each month but I don't want to prior month's data to change. I want to gather new data in each month by using the same links but linked to another spreadsheet. Does this make sense?? Does anyone know how to do this??

I basically want to keep the data I linked in one tab and have new data for the next month updated via a link. The cuts down on me typing it all in.

Please help me-- SEOT

I'm a little confused, if you mean for example jan's tab, links to fileA and feb's to fileB and so on...

Copy the jan tab, into the feb one. Select all the cells in the feb tab, and then 'find and replace' the old file (fileA) with the new one (fileB). It really helps to have the file you're linking into open, otherwise doing this has crashed my pc more times than I care to remember, but I suppose it depends how many links you're replacing.

If you dont mean that.... do you have an example you could attach?

Dude, you are the best! This will work! I wish I knew how to automate some of this, but I might can get to that later!! Thank U Buddy!!

MikeyFears,

You are right about it not working if the Source is not open. I wish there was a way to do it without the Source being open. My system keeps locking up(Crashing)! - SEOT

there is a kind of fudge.. you can copy the whole worksheet to another workbook.. then go to edit--->links----> then click update source.

if you did this without moving it, it'd update your first sheet too. then move it back when its update the links.

does that help?

Originally Posted by mikeyfear

there is a kind of fudge.. you can copy the whole worksheet to another workbook.. then go to edit--->links----> then click update source.

if you did this without moving it, it'd update your first sheet too. then move it back when its update the links.

does that help?

Mikeyfears, I will go with your first suggestion of having the sources open and updating them. This seems like a better process, but I wish it would work without the sources open. I reallly do appreciate all your help on this one!!! - SEOT