Evening all (from the UK),
I am having a spot of bother with my spreadsheet, when trying to automate some functionality. As a heads up, I am proficient in Excel - but not on the programming/VGA side, so I will need a helping hand here.
Effectively what I am trying to do is...
- With a comprehensive Project Plan press a button that extracts the information of cells that are marked as Critical.
- This information would pull through onto a separate Dashboard sheet, so that those critical items can get flagged to the Project Team.
- The data cannot be copied as a complete table, as there are various columns of data that I do not require copying.
- I have tried recording a macro with me 'filtering' the project plan for critical items and then copying that data across.
- This however only returns the cells originally marked as Critical, it does capture any changes to cells outside of the range in the code.
So,
- In Column C of 'Project Plan' sheet, I have tasks marked as "Critical" or blank.
- I want to copy data of those 'Critical' rows of data, from Columns B,D,F,I
- This data is then to go into the 'Dashboard' sheet, in Columns B,C,E,F.
I embed the code below, from my feeble attempt:
Please Login or Register to view this content.
THANK YOU VERY MUCH IN ADVANCE. You are the best guys, really appreciate help of any kind. Once the urgency disappears, I think I'll be looking to start some VGA training. Any advice on a free place to start (I've done HTML coding before)?
Bookmarks