Hello.
I have a workbook with multiple sheets that a given a unique worksheet name.
Each worksheet multiple columns of data. Each column on each worksheet has the same formatting and type of data. The number of rows in each worksheet varies. But each worksheet has the same number of colums.
I have a formula that picks a random value from a specific column between row 2 and the last row of data. I have it skipping row 1 from the column as that is the column header row.
I want to create a button to run this formula on each worksheet and put the results in 5 cells in a column that does not have data.
To give an example of the structure of the excel sheet:
Columns A - Z are used. Column E is the column I want to pull random values from. I want to automatically run the formula on each worksheet by pressing a button and have the results pasted in cells AA:2 = AA:6
I can manually do this on each worksheet by pasting the formula in the cells that I referenced, but there are 25 worksheets and it takes quite a bit of time to do this manually each week.
Thanks in advance.