Let me explain what I am trying to do. I want to make a worksheet, with as few sheet tabs as possible.
Sheet1: I will be refreshing data from a txt file. (I have two macros already to help sort this. Maybe if I can have the worksheet automatically update from the same text file [without clicking the refresh button and having to search for the file], and run these two macros after refresh, all on open, this would save time. These macros are already operating-- one deletes all rows that do not have the word "open" in column A, and the next deletes the first three characters from column B)
- this sheet has open orders, the order #, the date placed.
Sheet2: I will have to manually enter two columns on this sheet. Column A being the order # (which I will have to connect or lookup on Sheet1 to print the value that I type in column B- which will be a specified delivery date.
-would having a user form make data entry quicker?
I want to match the Order #'s that I type into Sheet2, and print the specified date in a column that I choose on Sheet1.
Challenges --
I want to delete rows from Sheet2, but only after they have appeared on Sheet1, and then disappeared from Sheet1. (I may enter an order # and date on Sheet2 before it has even shown up or refreshed on Sheet1. So only delete once it has matched an order on Sheet1, and then disappeared from Sheet1 (meaning that it has been delivered and is no longer an open order))
I am trying to track and make sure that orders are being delivered on time. Based on the specified dates that I enter into Sheet2.
**If doing this in Access may make things simpler or more user-friendly, please suggest that as well
Bookmarks