Hello
Windows Server 2005
Excel 2003
First post (hello everyone )
I've only been using VBA properly for about a month now so all of this is new to me and been using it for work.
I've created two spreadsheets one with data (testregister) and one with headings (testmailout). When a user closes testregister a userform will pop up. The userform has a DTPicker, a combo box with a list of customers and two command buttons for "Go" and "Close".
I want to know if it's possible in VBA for the user to select a date and customer in the userform, click 'Go', find the rows which contains the date in column 'I' and the customer name in column 'F' but only copy the row if column 'E' has a Y or y and column 'H' has a PASS.
The rows will then be copied into testmailout and testregister will close (this step is important)
Any help would be apprechiated and if possible can you explain what parts of the code is doing please.
This will be used by staff who are computer illiterate so it needs to be as automated as possible please.
If you know anymore info I'll try my best to explain
Cheers,
guyinahatgames
Bookmarks