Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 10-07-2013, 02:22 PM
BobBridges's Avatar
BobBridges BobBridges is offline Lookup using 2 criteria Windows 7 64bit Lookup using 2 criteria Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Changing the calculation to Manual is another good idea, IMO; I didn't think of that, but it means you can decide when you want to go through the wait, even after you've reduced it.



Quote:
Originally Posted by Itsbarbara
I dabbled in VBA, but it has been quite a while.

This may just be the best way to approach this so I can hand it off.
If you're thinking VBA may be the best way so you can then hand it off, I'm inclined to disagree. I love VBA automation, but once I hand something off I want the victim of my work to be able to deal with it himself if it breaks; so VBA is a good idea only if there's someone there who can fix broken VBA. I'm guessing that isn't the "this" you were referring to, but I mention it just in case I'm mistaken.
Reply With Quote
  #17  
Old 10-07-2013, 02:53 PM
Itsbarbara Itsbarbara is offline Lookup using 2 criteria Windows 7 64bit Lookup using 2 criteria Office 2010 64bit
Novice
Lookup using 2 criteria
 
Join Date: Oct 2013
Posts: 8
Itsbarbara is on a distinguished road
Default

Ha Ha, No, actually, I meant using the Table format for the Data sheet and showing them how to do a copy and paste values. (They can keep a copy of the original with the formulas to work from for the next school year.)

I guess you had trouble following my post as you can't read my mind. I'm bad about that....typing what happens to be on my mind at the moment, not realizing that I've changed topics!!! Sorry about that, but I really have appreciated all of the help. I don't work with Excel that often any more and you guys are just so good.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup angie.chang Excel 1 07-27-2012 09:45 PM
Sorting by certain criteria randenius Excel 2 06-11-2012 02:18 AM
Lookup using 2 criteria Possible Lookup Karen222 Excel 3 01-10-2012 05:41 AM
Lookup using 2 criteria LookUp aztiguen24 Excel 5 05-24-2011 03:57 AM
Lookup using 2 criteria Countif with 2 criteria ibrahimaa Excel 3 05-23-2011 11:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:16 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft