Desired multiple data into single cell

**namedas** · 10-01-2013, 06:12 PM

How i can be done

can any one explain i am attaching the spread sheet of abstract

09 13.xls 09 13.xls 09 13.xls

**alansidman** · 10-01-2013, 06:27 PM

Please provide a better explanation of the desired results. try to be as specific as possible. You have not given us any clues as to what you want and I dropped my crystal ball last week. It is currently in the repair shop.

**namedas** · 10-01-2013, 11:07 PM

in the sheet name DA i the number of employers with their employee code has the bill for their duties

where in the sheet DEPL i need the employees whose working in the same office just with their employee codes in a single CELL with commas

is it possible

again attaching the excel file
09 13.xls

**namedas** · 10-01-2013, 11:18 PM

oops i forgot to define that what i want

there is several sheets in the file but i need to work on two sheets in the file

the sheet name DA has the Duty Allowance and Sheet DEPL has Deployment positions of the employees in various offices

i need the formula where the employee is working (employee Codes (HG NO) Only) in sheet DEPL in a single cell

is it possible

if pls explain

i will repair your crystal ball soon

**FDibbins** · 10-01-2013, 11:22 PM

Hi and welcome to the forum

Although I have no doubt that 1 of the members could indeed put a formula together to give you what you want (sheet DA B41, B45, B51, 90, B119, B123, B219 into sheet DEPL D3 - and this is a hint to anyone attempting this, just filter sheet DA column D on "SDPO Office NRL"), I think you would get quicker answers if this was in the VBA forum, so I will move it there for you

**namedas** · 10-05-2013, 02:55 AM

Hi FDibbins
i hope that was correct using filters i can check this but everymonth the fileds or rows is shifted as the employees is having rotation method so thats not possible to do so

it is off every months work

**namedas** · 10-05-2013, 02:56 AM

Originally Posted by alansidman

Please provide a better explanation of the desired results. try to be as specific as possible. You have not given us any clues as to what you want and I dropped my crystal ball last week. It is currently in the repair shop.

oops i forgot to define that what i want

there is several sheets in the file but i need to work on two sheets in the file

the sheet name DA has the Duty Allowance and Sheet DEPL has Deployment positions of the employees in various offices

i need the formula where the employee is working (employee Codes (HG NO) Only) in sheet DEPL in a single cell

is it possible

if pls explain

i will repair your crystal ball soon

**namedas** · 10-05-2013, 02:57 AM

Originally Posted by FDibbins

Hi and welcome to the forum

Although I have no doubt that 1 of the members could indeed put a formula together to give you what you want (sheet DA B41, B45, B51, 90, B119, B123, B219 into sheet DEPL D3 - and this is a hint to anyone attempting this, just filter sheet DA column D on "SDPO Office NRL"), I think you would get quicker answers if this was in the VBA forum, so I will move it there for you

Hi FDibbins
i hope that was correct using filters i can check this but everymonth the fileds or rows is shifted as the employees is having rotation method so thats not possible to do so

it is off every months work

**alansidman** · 10-05-2013, 07:26 AM

See the attached. I have included in the VBA a UDF that was originally designed by JINDON of this forum. It is called VlookupMulti. To make it work, you must have your D I table rearranged in the order I have done it. Additionally, the Departments must be spelled identically in both sheets or you will get error messages as currently shown.