D
Dave Y
Hello
I have to run a SQL script on a daily basis that provides me with a list of customers who have just opened up a new account with us, for a certain type of account product. Each day I will have to work from this list to gather certain information. I will be importing the data from my SQL tool into an Excel workbook. I am trying to figure out a good way, after I import the data into individual Excel spreadsheets (one spreadsheet for each day) to compare all the spreadsheets for any duplicate entries. I'm trying to avoid having to compare multiple spreadsheets manually. I would like to be able to create a macro that would run the comparison on all the worksheets in the push of a button. I would appreciate any suggestions, feedback, or links that would help me to accomplish this goal. Of course the workbook will grow one spreadsheet every day and I would like the macro to know to compare all spreadsheets, whether it is two or twenty sheets. If any more info is needed from me, I will supply it in a reply post. Also, I accidently pressed enter when I originally went to create this post and ended up submitting a blank post. I apologize for the garbage post. Thank you in advance for any assistance in helping me complete this task. Dave Y
I have to run a SQL script on a daily basis that provides me with a list of customers who have just opened up a new account with us, for a certain type of account product. Each day I will have to work from this list to gather certain information. I will be importing the data from my SQL tool into an Excel workbook. I am trying to figure out a good way, after I import the data into individual Excel spreadsheets (one spreadsheet for each day) to compare all the spreadsheets for any duplicate entries. I'm trying to avoid having to compare multiple spreadsheets manually. I would like to be able to create a macro that would run the comparison on all the worksheets in the push of a button. I would appreciate any suggestions, feedback, or links that would help me to accomplish this goal. Of course the workbook will grow one spreadsheet every day and I would like the macro to know to compare all spreadsheets, whether it is two or twenty sheets. If any more info is needed from me, I will supply it in a reply post. Also, I accidently pressed enter when I originally went to create this post and ended up submitting a blank post. I apologize for the garbage post. Thank you in advance for any assistance in helping me complete this task. Dave Y