0
My spreadsheet contains several tabs. Each tab contains the same headers. My co-workers fill in their tab, so several tabs contain a lot if information. I own the Master tab.
Is there a formula to pull info from the 13 other tabs into the Master tab? Am I able to sort it once it's pulled over?
maymartin
Posted 2017-03-02T08:05:22.580
Reputation: 3
1
For this you could use
tab_name!cell_address
e.x
Reg_Systems!C13
Or to get certain data from some user you could use
=VLOOKUP()
Its a command from Excel. Its kinda difficult to merge multiple tables from multiple sheets into one file.
You could however ask your users to export their tables and then you can combine the tables and put them into one table.
RamonRobben
Posted 2017-03-02T08:05:22.580
Reputation: 870
1Don't forget the = Sign to complete the equation, at least in Google Sheets :D ;) =Reg_Systems!C13 – asmith – 2017-03-02T08:15:18.547
Once all the tabs pull into the master cell, will all my formulas also be copied and will I be able to sort by date or any other column I would need to sort? – maymartin – 2017-03-02T08:19:44.950
So if I have multiple tabs would I just write: =Reg_Systems!C13 =Housing!C13 – maymartin – 2017-03-02T08:20:22.777
@maymartin You are only getting the cell value from the sheet!cell_name. The formula which calculates the cell value will still be there not the actual formula. – RamonRobben – 2017-03-02T08:22:53.100
When I type in =Reg_Systems!A12:I200 I get an error message that says An array value could not be found. Can I only copy a row or column, but not the entire sheet? – maymartin – 2017-03-02T08:26:48.303
@maymartin Why would you want to copy the whole sheet? Could you show us what you mean by this? Show us the other tabs aswell. btw try click and dragging your formula – RamonRobben – 2017-03-02T08:32:44.523
I added a pic of a portion of the Reg_Systems tab. I am responsible for getting the Master tab updated with data from the other tabs. I'm currently copying and pasting the data from each tab into the Master tab. My co-workers are responsible for adding their data into the other tabs. Some contain very little data and other tabs can contain a lot of data. Hope that makes sense. – maymartin – 2017-03-02T08:41:54.060
I know get what you mean @maymartin I'll try to find a better solution to this. – RamonRobben – 2017-03-02T09:13:18.763
@maymartin you may want to look at the =Vlookup command from Excel – RamonRobben – 2017-03-02T10:17:22.633
@maymartin - if you want to bring in a range go ahead and try this: =ArrayFormula(Reg_Systems!A12:I200) – schmielson – 2018-07-29T20:20:07.100
1
You are asking an off-topic question. Please read On-Topic, How do I ask a good question? and What types of questions should I avoid asking?
– DavidPostill – 2017-03-02T14:57:51.020