cyberwild360
New Member
- Joined
- Apr 4, 2013
- Messages
- 1
I am in the Marine Corps and I'm trying to make my life easier.
I have an Alpha Roster which has about 120 rows of Marines info which spans from Column A:AP. The rows change often depending on Marines coming and going from the unit.
I am not good with VBA but excel formaulas I consider myself decent....
How do I have a second sheet in the workbook display the first 4 columns (A:D) along with the 6th column (F) on the second sheet based on a value in the 6th column and in the 10th column (J). The formula if it could be put into a formula would look like this:
if F4's date is within a year from today and J4 is blank or "N" populate Columns A:D and Column F to the second sheet.
I can't attach the source doc becuase of privacy but if truly needed I can create a dummy one. Please - any help would be greatly appreciated.
I have an Alpha Roster which has about 120 rows of Marines info which spans from Column A:AP. The rows change often depending on Marines coming and going from the unit.
I am not good with VBA but excel formaulas I consider myself decent....
How do I have a second sheet in the workbook display the first 4 columns (A:D) along with the 6th column (F) on the second sheet based on a value in the 6th column and in the 10th column (J). The formula if it could be put into a formula would look like this:
if F4's date is within a year from today and J4 is blank or "N" populate Columns A:D and Column F to the second sheet.
I can't attach the source doc becuase of privacy but if truly needed I can create a dummy one. Please - any help would be greatly appreciated.