Excel Format

[ahmedpa]

I Want To Autofill The Cell A,b And C In Work Sheet Three By Combining The Information Given In Work Sheet One And Two,such That Information In Cell B Of Worksheet 1 And Information Of Cell B Of Worksheet 2 Should Come In Cell B And Cell C Of Worksheet 3 According To The Code In Cell A.
Example :
Work Sheet 1
Cell A Cell B
Code Qty
A001 5
B001 3
C001 2

Work Sheet 2
Cell A Cell B
Code Qty
D001 2
A001 3
F001 5

Work Sheet 3

Cell A Cell B Cell C
Code Qty1 Qty2
A001 5 3
B001 3
C001 2
D001 2
F001 5

[mudraker]

ahmedpa

Welcome to excelforum

Please read forum rules - see links below

Your question has nothing to do with a format problem that your thread title would have us beleive your problem is.

[olasa]

I'm not sure about you explainations so I made two options.

Should column A to be autofilled?
In Sheet 3-2 the formula finds all unique codes in column A.

Should column B be filled if only one quantity exists and column C if two quantities exist?
The formula in Sheet 3-2 separates into 1 or 2 quantities.

Hope this helps
Ola


Note:
Some formulas are entered as Array formulas. Meaning they has to be ended by holding down Ctrl+Shift and then hit Enter. Only to hit enter will not do. The sign that it has been done correctly is that Excel automatically adds two squiggly brackets, one at the beginning and one at the end.