chapter

I'm studying Jelen's book "VBA and Macros" and at the start of Chapter 4, on UDF's, he directs the reader to open a new module in the the VBA Editor and type the following function into the module: Add (Number1,Number2). Can someone tell me what I'm doing wrong because when I enter that line I...

I am creating a dynamic calendar table as discussed in M is for Data Monkey Chapter 24. I have the following fields, among others: Year and Month, both Whole Numbers. I wish to create a concatenated field, YYYYPP, which is the concatenation similar to this: [year] & right("0" & [month],2)...

The title really doesn't explain what is going on, I am writing a story and I use Excel for keeping track of the timeline What I am trying to do is show how much time has past between the dates in the same chapter, but I also want to see the dates in chronological order. Some dates get...

I am comparing a membership rosters for two different years in excel. I need to find records from 2016 that are not listed on the 2017 listing or are not listing with the same chapter from 2016 (Criteria: ID from 2016 must be on list from 2017 AND ID from 2016 cannot have a different chapter on...

I bought Excel2016 Pivot Table Data Crunching, to try to master everything about the Pivot Table. I am following every chapter, using the downloaded workbook. But when I came to Chapter 4, I can't find any necessary worksheet to work with The downloaded worksheet for Chapter 4 contains only 3...