Excel '10 - A Macro to Populate Month Column Based on Date/Sched [Closed]

Report

k712

Posts: 2
Registration date: Friday May 20, 2016
Status: Member
Last seen: May 20, 2016

- May 20, 2016 at 04:34 PM

Hello,

I'm trying to work on a macro in Excel 2010 to auto-populate certain month (Jan-Dec) columns with an "X" based on the criteria of two other columns. One column provides the date and year (e.g. Aug/16) and the other provides the schedule (monthly, quarterly, semi-annual, or annual).

For example, if column E reads Aug/16 and column F reads quarterly, populate Feb, May, Aug, and Nov columns with an "X". Or if column E reads Aug'16 and column F reads semi-annual, populate Aug and Feb columns.

Is this something that would potentially be achievable with a macro?

Thanks in advance for any input you may be able to provide.

Excel '10 - A Macro to Populate Month Column Based on Date/Sched
Macro to delete multiple columns based on header ✓ - Forum - Excel
Excel macro to group by column and sum value ✓ - Forum - Excel
Excel macro find date in column ✓ - Forum - Excel
Excel macro to compare two columns and write to a third ✓ - Forum - Excel
Compare values in two columns and return the value from third ✓ - Forum - Excel

Excel '10 - A Macro to Populate Month Column Based on Date/Sched [Closed]

Your reply

Subscribe To Our Newsletter!