Do Loop/Function/VB/Macro to automate system description ID entry

**ShagNasty** · 09-30-2012, 06:35 PM

Automating System ID's 093012.docm

I need a do loop, function, vb code, or macro that will index through the SEARCHVAR (col A) and find items that contain the text in SYSDESC (col D) and replace SYS (col C) with the associated contents of SYSID (col B). Columns “A” & “B” can be in separate worksheets if needed. The goal is to automate assigning the System that each row of data belongs. The “A” col contains the search items and will need to be expandable.

Thanks,

Shag..

**shg** · 09-30-2012, 06:41 PM

Why post a word document for an Excel problem?

**ShagNasty** · 09-30-2012, 08:03 PM

Good question - call me overly cautious, just making sure I don't get a case of "happy fingers" and send out a spreadsheet with sensitive information...

Shag...

**shg** · 10-01-2012, 10:37 AM

That's actually a reason I understand ...

See attached.

**ShagNasty** · 10-02-2012, 04:35 PM

shg, really appreciate your work...

Your routine gives me what I need - nearly. I'm attaching a spreadsheet that may make clearer what I would like as the end result.

The attached spreadsheet "Test Example Query" contains 2 worksheets: "ALM Report" and "Lookup Key." I need to populate the ALM Report "SYS" col (A) with Lookup Key "SYSID" col (B), matching text in ALM Report "DESCRP" col F. I need to be able to add additional items in the Lookup Key worksheet..

Thanks,

Shag..