linking data on different excel sheets

**generalfemi** · 02-04-2012, 01:29 AM

hallo,

i seriously need help on this.this is how it goes
i have a series of number codes with values e.g.2134000tm01,2134000tm02,2134000tm03 etc on one sheet,then on the other sheet which represents the data sheet i have a very long listings of this same codes with values,only that a number code may appear in multiple times.

i have able to write a program that will sum each code on another sheet.but what i need now is a program that will enable me link the number codes to the multiples number codes in the other sheet which i will have to do by a copy and paste function instead of linking one by one....

**mahju** · 02-04-2012, 02:52 AM

Hi
Please upload a sample sheet

Regards

**generalfemi** · 02-06-2012, 03:06 PM

thanks for your reply find attached.
the highlighted colmn a is wht i want to link with the"po" column A sheet.

thanks

**mahju** · 02-07-2012, 01:52 PM

Hi
Try the attached

I have added some supportive column.

Also your sequence is not consistant so It also requires that in AFSE sheetEach all the heading in colomn B should start with *, for that ACFE should be blank (Colomn C))

Also I have changed calculationm method to automatic. Change to manual as required

Regards

**generalfemi** · 02-08-2012, 02:58 AM

thank you very much i really appreciate

**mahju** · 02-08-2012, 11:26 AM

You are welcome

If you think your problem is solved
PLease mark the thread as solved.

Rule 9
Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

Regards