Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-19-2012, 05:44 AM
Geza59 Geza59 is offline How to create a Main category mirrored in Sub category data entry type of solution? Windows XP How to create a Main category mirrored in Sub category data entry type of solution? Office 2003
Novice
How to create a Main category mirrored in Sub category data entry type of solution?
 
Join Date: May 2012
Location: Budapest, Hungary
Posts: 20
Geza59 is on a distinguished road
Default How to create a Main category mirrored in Sub category data entry type of solution?

Hello Everybody,



How can I mirror the entered data from one worksheet to another in a continuous "data entry" mode where two tasks have to be done:

1. Mirror the record to the sheet that matches its name to a category on the main sheet.

2. Enter the data in the sheet of the subcategory in the first available empty row.

I uploaded a sample file for illustration, my problem is that I lack the part of Excel vocabulary that could make my job a lot easier to explain what I am trying to accomplish here.

So, this is how it would work:

(1st record):
You enter a "Fee" type of record for Joe in the amount of 250. As you enter the same record gets mirrored on a worksheet called "Fee" making sure that the mirror entry on the "Fee" sheet happens in the first empty, or available row.

It would be nice if the mirrored data would stay "connected" to the same record on the Main sheet in case the record on the Main sheet gets changed or corrected, the mirrored data gets the update simultaneously.

And finally, please, help me to verbalize this problem for me in "Excel language", what is it that I am actually looking for?
Attached Files
File Type: xls Main-Fee.xls (14.5 KB, 10 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Contact Category to Excel eliz.bell Outlook 0 12-12-2011 12:16 PM
How to create a Main category mirrored in Sub category data entry type of solution? Rule on Category Change ker09 Outlook 1 08-29-2011 06:15 AM
MS Office colour category chaos action 49 Office 0 02-08-2011 12:05 AM
Archive according to category? Outlook 2007 EllieW Outlook 0 01-10-2011 11:45 AM
How to create a Main category mirrored in Sub category data entry type of solution? forward message to outlook category knoutam Outlook 1 11-07-2010 02:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:59 PM.


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