Depending on how your spreadsheets are set-up, what about vlookup? Or hlookup is it is a horizontal field.
Jayne: Captain, can you stop her from bein' cheerful, please? Mal: I don't believe there is a power in the 'verse that can stop Kaylee from being cheerful. Sometimes you just wanna duct tape her mouth and dump her in the hold for a month.
'Serenity'
Buffistechnology 3: "Press Some Buttons, See What Happens."
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
SuziQ - Jan 29, 2014 8:23:45 am PST #23610 of 25496
Back tattoos of the mother is that you are absolutely right - Ame
meara - Jan 29, 2014 8:28:51 am PST #23611 of 25496
Does the cell #/location not stay the same in each tab (ie, does Tab1 move the News Subtotal from H100 to H101 depending on what's going on), and that's why you need it to be next to the "News Subtotal"?
Jessica - Jan 29, 2014 9:27:13 am PST #23612 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Yeah, each tab has a completely different number of rows, and in some cases columns. So what I need is to take all of the subtotal rows and transfer them to a clean sheet so I can add up those values.
meara - Jan 29, 2014 9:38:01 am PST #23613 of 25496
Sorry, I mean when the spreadsheet is updated, does the placement of the value change within the tab? Not that in Tab1 it's H100 and Tab2 it's G75, but like, on Monday Tab1 is H100 and Friday it's Tab1 H106?
Because if it's just in a different place in each tab, that's easy enough. If it changes where it is, different task.
Jessica - Jan 29, 2014 9:44:11 am PST #23614 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Oh I see. I'm working with a static copy so no, the row will not change.
meara - Jan 29, 2014 9:58:33 am PST #23615 of 25496
Oh, sure, that's easy then--just pick the sheet where you want it to add up, type the equals sign, then go click on the cells you want it to add, it'll be like =Sheet2!B7+Sheet3!C14
(I mean, that's a more manual way than it finding all the cells next to a certain phrase, so maybe if you've got 100 sheets it doesn't work so well?)
Jessica - Jan 29, 2014 10:23:20 am PST #23616 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
(I mean, that's a more manual way than it finding all the cells next to a certain phrase, so maybe if you've got 100 sheets it doesn't work so well?)
Yeah, that's the process I'm trying to avoid. I don't want to spend half an hour copy-pasting.
-t - Jan 29, 2014 10:36:30 am PST #23617 of 25496
I am a woman of various inclinations and only some of the time are they to burn everything down in frustration
Yeah, I'd do a IFERROR(VLOOKUP(TAB1ARRAY,NEWS SUBTOTAL,[correct column],false),0)+ IFERROR(VLOOKUP(TAB2ARRAY,NEWS SUBTOTAL,[correct column],false),0) etc. on the sheet you want the subotals to be. Or one of those one a line if you want to list all the subtotals one after the other, I guess, maybe you wouldn't need the IFERROR then.
le nubian - Jan 29, 2014 2:29:13 pm PST #23618 of 25496
"And to be clear, I am the hell. And the high water."
sumi,
Le nubian - it turns out that the university library has an e-book and a physical book that my boss can use.
good.
Typo Boy - Jan 29, 2014 6:56:09 pm PST #23619 of 25496
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.
I have a friend who has won a Fullbright Research Fellowship. She is going to be traveling to India. She has decided she needs a tablet, mainly for reading purposes - maybe a Kindle Fire, or a good Ipad or a good Droil. Maybe some light web browsing and email reading, but the big purpose will be to store and read e-books. These will be books for her research, and she wants to get e-book verision of most of her library. So she will be looking at this screen a lot and odes not have great eyes.
She also wants a work computer to write on MS Word, Excel, Powerpoint, email, research web browsing. I suggested these it might be possible to combine the two especially since she is used to windows and somewhat resistant to a Mac. But she might consider a Mac for the work computer and an ipad for the reading computer. Oh and she has to buy quickly. No time for mail order or getting stuff built. So she needs something she can get from the Apple Store (if Apple) or from Best Buy or Office Depot or Target or places like that for Kindle/Android/Windows. She also open to Kindle Fire for her reading tablet. Again,she wants a separate laptop and tablet. She wants the screen on her laptop to be at least 13 inches and decebt res,
So need rec for both the tablet and the laptop. Again, she does not want to combine.