This is not going to be easy to explain due to i cannot send or upload cofidential files. But here goes nothing.
I have multiple workbooks, that have multipe worksheets. The tabs are all locked with the same password. Each book has different account numbers, but all are located in Column A.
I need to unlock all workbooks (i will have all open at once) and put in a formula starting in A6 (which is already hidden) on "Budget" Tab that will read B$2&B6 and copied down to cell "A250" This is unquie number to all open workbooks; Then copy colulmn A and past special value. Then Hide Column A. Then copy column A in each tab labled "Budget" into another brand new workbook. Then lock the books with the same password.
Any idea and or help would be great. I know how to put in macros.
Bookmarks