Hi all,
I am trying to compile a spreadsheet which different clients for migrations that have different migration times and different roles.
I need to match the migration start month/year (12/2010) in the client list to the month on columns J:BM2 and then once matched display the values for each role for the duration of the migration.
I have attached a sample of what I am trying to do which I have done manually.
any help is appreciated!
Thanks!
A few points
Using your sample file...1. please modify your title and remove HELP!
2. use Date values (always)
3. be wary of cell formatting !
If backwards compatibility is a concern (ie pre XL2007) you can replace the use of EDATE with more traditional alternatives - let us know.
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
SOLVED. Allocating values based on criteria
it worked!!!! Thanks a lot!
Please note point 1 in my prior post else I will get into trouble with the Mods for answering your thread in the first instance.
Please adapt your title as requested Thx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks