2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Looking for a way to combine all similar sheets from different workbooks into 1 new Book

we have a few customers who are ordering goods from us and different departments will basically get the same digital order form to fill out what they want. We have it set up so we have different garments types on different sheets with formulas and links to keep things organized for customization(in case certain customers want their names on certain goods.

I'm trying to figure a way to consolidate the same sheets from different workbooks together to create one master order form for out production staff.

for example, all of our workbooks will have sheets that for garments like sweatshirts, work shirts, overalls, work pants, jackets, etc. I would like to be able to grab all the sheets that say work shirts and copy them all into 1 book.

I looked into using a power query but the imported data doesn't visually look the same as the the original document. I'd like to have it remain the same.

I've been manually copying each sheets into a new document and while it does the job, it's very tedious to do when a customer has 20+ departments to do.

submitted by /u/the0utc4st
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#google sheets
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#digital transformation in spreadsheet software
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#sheets
#order form