Extracting cells from all workbooks in one file


I do all my estimates on an Excel spreadsheet. The cells that the address goes in is the same for all my saved estimates. I would like to collect the addresses from all my estimates and place it in one file for a mailing. How can I do this?



Your description is contracdictory. If the address is in the same cell on all estimates then all estimates shouldn't be on a single spreadsheet. You could have a worksheet per estimate in one workbook or one estimate per workbook. Without such information an answer to your question is impossible.
Variatus (rep: 4218) Feb 7, '20 at 8:51 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login