Forum Home
Press F1
Thread ID: 12617	2001-11-03 04:19:00	MACRO Closure Q. Russell D	Guest (0)	Press F1

Post ID	Timestamp	Content	User
23501	2001-11-03 04:19:00	Russell, The highlight code works great- Last request on this issue- My Leadership yesterday explained a little better what they were reaching for on this. Briefly, the spreadsheet lists colums 'A - N' Columns G,H,K,L are the ones being looked at for duplicates. If they are dup's then it means we are paying out double $. Columns are: G= Division number-ie 27 H= Item code- 6 digits K= Date- example 4/4/02 L= Profile type-ie AAA1 I have to pull up the highlighted rows by item code and verify if they are indeed duplicate billing or if someone entered the same bill twice in error. Anyway that's the long and the short of it. Can this be done?? Thanks, Sam	Guest (0)
23502	2001-11-06 04:41:00	Will there be multiple item codes that are not duplicates, and if so what other single column parameter will indicate a potential duplicate along with the item code column. Also when you say the hilight works great - is it identifying your current duplicates, and if so which column are you running the macro on? An alternative may be to use the inbuilt Data/Filter/Autofilter function of Excel. .............	Guest (0)
23503	2001-11-07 01:52:00	'Yes there will be multiple item codes that will not be duplicates. 'There are 5 columns (F,G,H,I,J)that will be reviewed for a duplication match. 'Your 'highlight code' works great for column A which contains the 'UPC' code (like the ones you would see labeled on grocery store shelves), but column A doesn't narrow the search sufficiently to make a positive match. 'I tried the Data/Filter/Auto Filter- it would be alright for a 1 page worksheet -but this spreadsheet has 300 pages. Thanks	Guest (0)
1