Link certain columns between two sheets

[naeco]

Hello,

I have a list with hyperlink for each content. I'd like to link 2 columns to a new sheet for a different purpose. How do I set it up so that when I update one list (i.e: insert new content, add new hyper link...), the other will get updated as well?

Thanks in advance !

 

[Robert Mika]

Hi naeco,
Can you give an example?

 

[naeco]

Hi Robert,
Let's say we have columns Order, Code, Name, Date, Number of pages... as I'm collecting financial reports from companies. On sheet1, I enter quarterly reports. On sheet2, I enter annual reports. The columns I'd like to keep updated on both sheets are Order, Code and Name. Othet columns will get its proper inputs. Entries in Code and Name will have hyper links to company website and profile. The list is likely to increase when the number of companies grows. I'd like both sheets to get update when I add new company or new link (to existing company) to either sheet. In other word, I'd like both sheets to share data of three columns Order, Code and Name.
I hope that the example is clear enough as English is not my native language.

 

[naeco]

http://www.mediafire.com/?35lv2ug8uqvxgu0
This will probably help explaining better.

 

[Robert Mika]

naeco,
To update both sheets at the same time you wil have to have some VBA code, as you can not have data link to another cell and at the same time enter data into it.
Unfortnatell my programing skill is not good enough fot this task.

Alternativly you can use Sheet3 as a Master sheet and then have link Sheet 1 and 2 to this sheet.

 

[naeco]

Using a sheet as Master sheet is fine as well if that can do the job. I'd be greatly grateful if you could show me how.