EXCEL HELP

[Closed]
Report
-
 Blocked Profile -
Hello,

Hello,

I have a excel worksheet with inventory data in it.
Column A is Item Number
Column B is Type of Coating
Column C is Stock Level to maintain
Column D is Stock on Hand
Column E is Qty. to Order
Column F is Ordered

There are 220 rows in the worksheet (and growing)

I have the basics covered, =IF(D7<C7,C7-D7,"").

What I'm wondering is beyound the basics I believe.

Here's my question. Is it possible when Column F has a X in it, to copy that row of information using only Column A, B, E into an existing worksheet, in the same workbook, named Order Form that is already formatted with a company logo and a place for a P.O.#. This then can be printed out to give to the sales person rather then copy/paste manually or taking forever giving a verbal or written order, which sometimes leads to mistakes.

From browsing the internet it seems possible, but all the examples A)involve using VBA, which i can follow, but have problems modifing for this purpose.
B)copy the entire row if column is equal to "X" when I only need the three columns of information for each row.

Thanks in advance.
JP

1 reply


Dear Sir,

Please have the solution from the following address.

https://ccm.net/forum/affich-222455-excel-compare-and-transfer-data

Thank you.