Trying to create a sequence that will evaluate spreadsheet A and spreadsheet B, if the data in column B matches my criteria on either of the spreadsheets, I want to copy that entire spreadsheet to a specific tab of spreadsheet C.
I know that the data in column B will meet my criteria on either sheet A or sheet B everyday but don’t know which one. Sheet A and B get generated everyday with this type of name “words-number-words.xls” convention. The “words” stay the same, the “number” changes everyday.
My thinking was assign each sheet to a variable and then use a for loop and if activity to evaluate the two spreadsheets. I’m not sure how to assign each sheet to a different variable because the name will change everyday. If anybody has some time to work with me on this I’d appreciate the help.