TASK-1 Insert Patent Type
Intent drag in an existing value (if a row ID exists) else: add new row with 2-column ID.
i.e. compare Sheet-1 & Sheet-2
TASK-1 I would actually prefer a generic spreadsheet vs. canned VPA app. For this one
1 User pastes 100-Colums by 1000-Rows of data on Sheet-1
2 User pastes 2 Columns by 1000-rows of data on Sheet-2
3 ignore header row
4 Sort sheets 1 &2 by col A ignoring Header both sheets
5 User or program needs to create NEW Sheet-3 (1 new column for the insertion of new text string 20 char max from Sheet-2 col-B)
6 If Sheet-1 Col-1 cel A2 thru A1000 is on Sheet-2 Col-A THEN (add Text from Sheet-2 Col-2 to Sheet-3 Nu Column)
7 Else insert new row with not-present Seet-2 Col-A and Col-B data)
have excel example if not clear