I am not a very advanced Excel user, so bare with me here. I am a commercial real estate broker and every time I do a lease transaction, I fill out a deal form in Excel for our bookings department. In each deal form workbook, I am required to fill in the dates when payments are due. I want to be able to pull the dates from ALL of the deal form spreadsheets located in my C:\Deal Forms folder (there are currently about 50) and have it either create a spreadsheet or pull it into a database like Access which will allow me to see all the dates at once. In other words, how can I design a spreadsheet or Database file that will remind me when a payment date is coming up? I have way to many deal form.xls files to keep track of. I need to some how create a summary list of these dates which corrispond to the Deal # field in the form. Somebody please help
Red Flag Submitted
Thank you for helping keep Eng-Tips Forums free from inappropriate posts. The Eng-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Eng-Tips forums is a member-only feature.