Extracting cells from all workbooks in one file

0

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?

Answer
Discuss

Discussion

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: 3523) 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