I apologize in advance for likely not using the proper language as I am far from an Excel pro! Here's what I'm trying to do:
One workbook will have a list of data which essentially contains our entire residential area with about 8 different spreadsheets within the workbook titled Vacancy Report (VR). One person will be maintaining that report by making changes to the appropriate rows (one row = room info described across several columns within that row). What I would like is to have another workbook keep track of the changes within a single spreadsheet. Ideally, whenever a date is entered under the Room Change column in workbook VR, it will automatically populate the information from that single row in the workbook titled Combo Change Database (CCD) simply by adding a new row at the bottom of the list, in chronological order of when it was changed. Is something like that possible? Is that too complicated? I'm including a link to an image of what I want to do. For some reason, I can't get the image to insert into this post. If whatever I said is not clear, please do not hesitate to ask for more info! Thanks in advance for anyone who can help!
