Inventory Maco help needed.....

[chefdt]

I have a WORKBOOK named "Inventory". It consists of several WORKSHEETS that divide my food inventory into categories such as "MEAT", "DAIRY PRODUCTS", etc.

I recorded a macro that will import my inventory from an online ordering system, dump it to a WORKSHEET named "IMPORT" and normalize the data.

I want to create a macro that looks through the import data and parses it into the appropriate WORKSHEET.

Column "I" of the "IMPORT" sheet contains the name of the WORKSHEET that the data needs to be copied to.

The other worksheets will already have data in them, starting at "A8". As each item is copied to the appropriate sheet, I want to verify if the item already exists on the sheet and do one of two options.....A) If it exists, copy only "H" which is the case cost, and flag by color or bold text if the new price is different from the current B) If it doesn't exist, add the entire row of data to the bottom row of data in the appropriate sheet.

Here is a sample of "IMPORT" and "DAIRY"

Dairy Products

	A	B	C	D	E	F	G	H	I	J	K	L	M
1		Todays Date:	10/31/2013							Total:
2		Date of Last Inventory:	3/12/2010							$ -
3		Days Since Last Inventory:	1329
4		Last Person to Inventory:
5
6
7	SUPC	Item Description	Brand	Count	Package Size	Mfg #	Re-order Count	Case Cost	Case	Each	Unit Cost	Units in Stock	Total $
8	8965881	BUTTERMILK 1% LOW FAT	WHLFARM	9	.5 GAL			$ 19.05			$ 2.12		$ -
9	6697890	CHEESE AMER YEL 160 SLI	BBRLCLS	4	5 LB			$ 37.68			$ 9.42		$ -
10	2404135	CHEESE CHDR YEL MILKD SHRD FTHR	CASASOL	4	5 LB			$ 45.80			$ 11.45		$ -
11	7234958	CHEESE CUBE CHDR/COJCK/PEP JCK	BBRLIMP	3	5 #			$ 48.00			$ 16.00		$ -
12	4791386	CHEESE CUBE HAVARTI/GOUDA/MUFN	SCHRBER	3	5 LB			$ 46.74			$ 15.58		$ -

<colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 49px"> <col style="WIDTH: 209px"> <col style="WIDTH: 61px"> <col style="WIDTH: 35px"> <col style="WIDTH: 71px"> <col style="WIDTH: 73px"> <col style="WIDTH: 81px"> <col style="WIDTH: 54px"> <col style="WIDTH: 30px"> <col style="WIDTH: 30px"> <col style="WIDTH: 54px"> <col style="WIDTH: 48px"> <col style="WIDTH: 54px"></colgroup> <tbody>
</tbody>

Import

	A	B	C	D	E	F	G	H	I
1	SUPC	Desc	Brand	Pack	Size	Mfr #	Par	Case $	Cat
2	DAIRY PRODUCTS
3	0671677	CHEESE BLUE CRUMBLES	SYS IMP	2	5 LB	10000847		$ 12.59	Dairy Products
4	5469259	CHEESE BRIE DOMSTC 1 KG	BBRLIMP	2	2.2 LB	10007830		$ 17.28	Dairy Products
5	2406189	CHEESE CHDR JACK SHRD FCY	CASASOL	4	5 LB	10000253		$ 47.78	Dairy Products
6	2599793	CHEESE CHDR MILD YEL PRNT	BBRLIMP	1	10 LB	10000253		$ 23.70	Dairy Products
7	6159263	CHEESE CHDR SHRP PRNT YEL	BBRLIMP	1	10 LB	10000253		$ 27.32	Dairy Products
8	2357598	CHEESE CHDR SMKD	TILAMOK	6	2 LB	10007703		$ 61.70	Dairy Products
9	2357580	CHEESE CHDR XSHRP WHITE	TILAMOK	2	5 LB	10007703		$ 53.95	Dairy Products
10	2220143	CHEESE FETA CRUMBLE DOM	SYS IMP	2	5 LB	10000847		$ 36.21	Dairy Products

<colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 119px"> <col style="WIDTH: 332px"> <col style="WIDTH: 72px"> <col style="WIDTH: 35px"> <col style="WIDTH: 55px"> <col style="WIDTH: 63px"> <col style="WIDTH: 64px"> <col style="WIDTH: 63px"> <col style="WIDTH: 108px"></colgroup> <tbody>
</tbody>

Any help appreciated!