Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 11-15-2017, 10:00 AM
NBVC's Avatar
NBVC NBVC is offline Consolidation or not? Windows 10 Consolidation or not? 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Consolidation or not? Consolidation of multiple sheets in Pivot Kelly Mathews Excel 1 10-15-2016 04:19 AM
Consolidation or not? Excel Consolidation Problem youngsc Excel 1 03-29-2010 06:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft