Dear sir,with my regards , i want to ask your good self if is it possible to help by a code or formulas to transfer data from sheet (main) to sheet(details) as mentioned in attached file .


Many thanks in advance .

Attached Files

Transferring data.xls (58.5 KB, 8 views)

Hi
the fact that you haven't got any answers at excelguru.ca indicates that what you want is insufficient or unclear.
There is no explanation whatsoever.
Your use of merged cells will also cause problems.
Try to explain better what you want to achieve and if those cells are involved in the solution, get rid of the merged cells first.

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Dear sir,many thanks for your notes,i have cancelled all the merging cells and put some explanations as you have advised.
Accept my apology.

Attached Files

Transferring data1.xls (80.5 KB, 11 views)

Dear sir,any hope to get any reply.
Thanking you.