Thanks Marcol ! That worked very well. I would like to add one more cell A4 and it's value changes every time, let say, it's the date. I tried to add an InputBox after Range("A3")... but when I ran the Marco, the InputBox prompted up for every worksheet (I have more than 30 worksheets @@). I'd also like to do some formatting and adjust the column width. Could you take a look at below codes and let me know if that's the way?
And sorry, one more, what if I don't want the actions done on a few worksheets. They might not be the first two worksheets. Sometimes it might be the 21st and 29th while sometimes the others. I won't be able to tell the sequence of the worksheets because it might change every time (unless I count) but what I could be certain was the name of the worksheet.
Bookmarks