View Single Post
 
Old 11-15-2017, 10:00 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

As soon as you type an "A" in column A, row 11 of "Results" sheet, you should see column F show "A_4". This means this is the 4th occurance of "Item A", and therefore it should add a 4th row to the Item A sheet. It should not overwrite anything.

My sample is assuming you are adding new rows in the results sheet (even for same Item). It does not assume you are overwriting previous information.
Reply With Quote