You can copy and paste AF10 into AF11:AF119 simultaneously - you need not apply each formula individually... (or if you hover on bottom right corner of AF10 you will see a black cross - click that and drag down to AF119).
You might want to google on "Fill Handle" as this is a very handy tool when you're getting to grips with XL.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
SOLVED... Off Balance...
Absolutely Astounding... I can't thank you enough. Worked like a charm. Thanks for being so patient, thorough, and quick to offer assistance... truly appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks