up until now id input all the info on worksheet1 by hand,
and redo it again on worksheet2 by hand....


WORKSHEET1
A B C D
1 Product QUANTITY Price/Unit TOTAL
2 ProductA 100 30 3000
3 ProductA DETAIL............
4 ProductB 50 100 5000
5 ProductB DETAIL............
6 more ProductB DETAIL............
7 more and more ProductB DETAIL............
8 ProductC 1 500 500
9 ProductC DETAIL.......

WORKSHEET2
A B C D
1 Product Quantity Price/Unit Total
2 ProductA 100 30 3000
3 ProductB 50 100 5000
4 ProductC 1 500 500


was wondering if theres a way to let worksheet2 detect the following...
1. if WKS1 B3=ISNUMBER,
then write info in WKS1!B2 to WKS2!B2 and WKS1!A2 to WKS2! A2 and so on...

what im trying to say is, info on the first worksheet are for customers,
its mixed with numbers and information so it is not nicely lined up....

so for personal memo purpose i needed them to be lined up nicely,
thats why im trying to create worksheet2... is there anyway to let excel ignore the spaces between each product...
and have them lined up nicely on worksheet2?