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

Expanding Sheets in Workbook

Hello!

I have a workbook with 54 sheets. The first four sheets are various summary sheets that pull data from the other 50 sheets. The sheets are labeled numerically.

I need to expand this workbook to 55 sheets. I can copy the sheets, rename, and reorder them easily. But is there an easier (also, less prone to omittance/error!) way to update the first four sheets to include the extras? Right now, all of the cell references say '1-50' and I need them to say '1-55.' It's multiple changes, however. I was hoping dragging formula would work once the new tabs were added and and named, but that wasn't my experience.

Help! ​

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#google sheets
#Excel alternatives for data analysis
#rows.com
#AI formula generation techniques
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#formula generator
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#workbook
#sheets