If two sheets contain the smae unique identifier, link cells so data is entered only once

**Tanyab** · 03-27-2013, 11:47 AM

Good Afternoon All,

I have developed a macro-enabled database, but am struggling at one of the last things I need to implement. It is my first full project involving macro coding so I am definately still a novice! Attached is a template fo the problem I will to solve.

If there is a number in Column C of sheet ‘Data B’ (i.e. not N/A) it means that this data also exists in sheet ‘Data A’. Instead of the users having to enter data twice, I would like the macro to insert an automatic link, to automatically input the data that is in columns H to R of sheet ‘Data A’ to columns G-Q in sheet ‘Data B’ as the data is therefore the same.

Can anybody help?

Kind regards,
Tanya

**venkat1926** · 03-28-2013, 03:36 AM

“If there is a number in Column C of sheet ‘Data B’ (i.e. not N/A) it means that this data also exists in sheet ‘Data A’.” in which column of data
Which is your source sheet and which is result sheet

Do you mean to say data A B2 is 1 andin data B 2 is iun C2. Does it mean that in data A H2 to R2 values(11 columns) same as in data B inG2 to Q2.(11 columns) respectively that is
H2 in data iss samad as G2 in data B. I2 od data is same as H2 of data B. clarify give 2 or 3 examples

**Tanyab** · 05-30-2013, 11:53 AM

Thank you. Sorry I managed to figure it out!

If two sheets contain the smae unique identifier, link cells so data is entered only once

LinkBack

Thread Tools

Rate This Thread

Display

If two sheets contain the smae unique identifier, link cells so data is entered only once

Re: If two sheets contain the smae unique identifier, link cells so data is entered only o

Re: If two sheets contain the smae unique identifier, link cells so data is entered only o

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions