LoginSign up
AccountingWEB
Subscribe to Newsletter
Menu
Tax
Sales TaxIRSIndividualsBusiness Tax
Practice
ClientsGrowthPractice Excellence
A&A
StandardsFraudAuditing
Technology
ExcelSoftware NewsTrends
Bookkeeping Essentials
White Papers
Ask an Accountant
Webinars
Practice ExcellenceTax TalkTech Pulse
Summit 2023
Subscribe to Newsletter
David Ringstrom
David RIngstrom
Member Since: Jan 6th 2014
Columnist
Twitter
LinkedIn
Website
Likes: 0
Thanks: 1

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.

David Ringstrom
Author/Presenter/Spreadsheet Consultant Accounting Advisors, Inc.
  • Articles
  • Columnist Posts
  • Blog posts
  • Questions
  • Answers
  • Comments

My answers

Jul 8th 2018

Thank you for your kind feedback!

Reply to
Troubleshooting When Excel’s VLOOKUP Function Returns #N/A
Apr 11th 2018

The only way to do this is to write a macro that would assign a unique name to each worksheet. The numbers appear so that each sheet has a unique name and so there's no other way around this.

Reply to
5 Ways to Duplicate Worksheets in Excel
Oct 3rd 2017

A VBA macro in Excel can stack everything together into one list. This is a common enough need that I'm sure a Google search would unearth a Combine Sheets macro.

Reply to
Combining Multiple Worksheets in Any Version of Excel
Oct 3rd 2017

I'll be honest, whenever I find anyone using 100 sheets for *anything* in Excel, it's typically time to look to another solution. But Excel may be what you have for a tool. In that case, if it were me, I'd try assembling as many sheets as I can into a single worksheet, and then start a second worksheet to combine together as many additional sheets as I can. I'd then use a third query to combine the two "combined" worksheets into one list.

Reply to
Combining Multiple Worksheets in Any Version of Excel
Oct 3rd 2017

No, I don't think the problem is with height or width or any other features, except the Filter. Excel's Filter feature could put the workbook in a state where you can't combine the sheets. I'd try turning it off and see if that helps as a rule out. If you have the same problem afterwards, then you can skip that.

For the Administration worksheet, I'd try using Microsoft Query to pull that data into a separate worksheet by itself. If it lets you retrieve the data, copy and paste the SQL statement into your existing query with the Union statements.

It's tough to diagnose without seeing your data, but setting it down and picking it up again with a fresh eye does wonders for tracking down nuances in one's data.

Reply to
Combining Multiple Worksheets in Any Version of Excel
Aug 23rd 2017

Laurie,

I set up a file with the name you used and the sheet names in question, along with some sample data. I was able to get everything to work and I didn't get that error triggered.

It could be that your workbook has some corruption in it. As a starting point I'd copy and paste your data to a brand new workbook and try again to see if it works. If it doesn't, I'd be happy to take a look if you can share your workbook with me. Feel free to remove any confidential data. You can upload the file by way of the Upload a Project file link at www.acctadv.com.

David

Reply to
Combining Multiple Worksheets in Any Version of Excel

Most read this week

Standards
Aug 12th 2022

Identifying and Communicating Reportable Findings

by
Richard F. Fischer
Female auditor

Trending

Standards
Aug 12th 2022

Identifying and Communicating Reportable Findings

by
Richard F. Fischer
Practice Excellence
Aug 9th 2022

A New Approach to Client Filtering

by
Jon Hubbard
Any Answers comment Icon 1
Business Tax
Aug 10th 2022

Tax Court Approves Vehicle Deductions for Side Gig

by
Ken Berry
Any Answers comment Icon 1

Upcoming Events

Xerocon US 2022
August 24-25
Botkeeper -- AI Unchained
Sept 25-27
Digital CPA
Dec. 4-7
QB Connect 2022 (LIVE)
Dec 7-9
  • About SIFT
  • Advertise on AccountingWEB
  • Terms of use
  • Privacy policy
  • Contact us
Copyright 2022 Sift
Sift