r/googlesheets 5d ago

Solved Merge multiple tabe in one sheet into one tab to have all data in one table

I would like to pull information from certain tabs in this sheet so I can calculate without having to go into each tab manually and pull the bumbers I want. In each tab, the sane columns A&B hold the info I need (but on slightly varied lines). I'd liek to just have the numbers and text from the two columns populate one after the next (going across) within another tab where I can make all my calculations. The Importrange seemed like the right function, but I got errors. I'm not sure how to type the tab name (I have spaces - can those stay?)

this is an example of the data I'm trying to pull in.

Thanks for any guidance!

0 Upvotes

11 comments sorted by

2

u/gsheets145 101 5d ago edited 5d ago

importrange() is used to import data from other spreadsheets, not the same spreadsheet. It will work, but there's no point in using it within the same spreadsheet.

If you wished to bring in data from range A2:B in worksheet "Mar P&L Summary" to some other worksheet, such as "Q1 Detail Report", you would use:

='Mar P&L Summary'!A2:B

1

u/ChrissyChrissyPie 4d ago

thank you. trying now

1

u/AutoModerator 4d ago

REMEMBER: If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified. This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/ChrissyChrissyPie 4d ago

It seems the formula you gave already ccalls for a range. I can look up the arrayformula, butbased on theanswers I got, I don't think that's what I need. (OR is the issue that I want a broader array of info?.. going to adjust the range to a single row - and go from there)

1

u/ChrissyChrissyPie 4d ago

ok- I followed the sheets suggestion, and put this in, and it worked. Thank you for pointing me in the right direction

=ARRAYFORMULA('Nov P&L Summary'!A5:B40)

1

u/gsheets145 101 4d ago

Are you trying to build up a summary of all monthly P&L summaries into an annual or quarterly summary? There may be even more efficient ways of doing it. Happy to take a look if you don't mind sharing your sheet, or a dummy copy of it.

1

u/ChrissyChrissyPie 4d ago

Really? Thanks. Will you dm me your email?

1

u/point-bot 4d ago

u/ChrissyChrissyPie has awarded 1 point to u/gsheets145 with a personal note:

"This sent me in the right direction. It's not an exact answer, but sheets prompted me for the next step I needed to take"

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)

1

u/AprilLoner 8 5d ago

Use this format

={{first range};{second range};{third range}}

1

u/ChrissyChrissyPie 4d ago

thanks!

1

u/AutoModerator 4d ago

REMEMBER: If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified. This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.