Mal ,'Bushwhacked'
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!
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.
Oh I see. I'm working with a static copy so no, the row will not change.
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?)
(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.
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.
sumi,
Le nubian - it turns out that the university library has an e-book and a physical book that my boss can use.
good.
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.
I'm a fan of the Toshibas. Something like this, perhaps? [link]
I recommend avoiding Windows 8 unless you have a touchscreen.
For the tablet, I've heard good things about the Kindle Paperwhite, but I haven't tried one myself.
I LOVE my Paperwhite, and it's got a much better battery life than the Kindle Fire. The down side is that the PW isn't a tablet, it's just a kindle. But if she's getting a laptop, she can use that for browsing and movies or whatever.
The reason she is thinking tablet not pure e-reader is many of the books she needs are not available on Amazon. She not only needs to ability to read a variety of formats (which the paperwhite does fine) she needs to browse to websites to download the books. Otherwise It hink she would love a paperhite, but she needs to do light browsing to get the books. I guess she can download all the non-kindle books via her laptop and then transfer them via USB.