ab12345,
This worked great. Thank you so much. Since it ends with a loop, I obviously have to make a seperate macro for each field I am pulling date from. For example, I have a "Date Due" and an "Amount Due" field and need to pull both fields (they are not located next to...
ab123456,
This is great. Thank you so much. I tried the other suggestions people gave, but they did not work very well (perhaps I was not doing them correctly). Thanks for taking the time to actually write out the code for me. I will give it a go and let you know how it works. Thanks again.
Thanks to both of you. I will try these suggestions and let you know how it turns out. Ivanlocke, this is a little over my head, but I will attempt to figure it out. Thanks again. B-)
I am trying to design this for use by everyone in my company - about 200 real estate agents. I cannot tell 200 people to go out and buy Quickbooks Pro. Of course there are lots of programs where you could set reminders (such as Outlook), but that is not the point. I know that this is...
I appreciate your effort in trying to help, but that is not going to work. Each of the forms/workbooks are named something different. I need it to pull the data from the cell g4 in all workbooks (regardless of what file name they were saved as) that are located in the folder c:\Deal Forms...
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...
