Look Up and Enter New Data

[CareerServices]

I am pretty advanced with excel and formulas; but am new to macros and that is what I believe needs to be created to achieve the desired results.

I have attached my spreadsheet as reference but I am trying to accomplish several things

• If a name on the "placed" sheet has a 1 in column G on the "BPPE" sheet then: delete the row on the "placed" sheet
• If a name on the "placed" sheet has a 0 in column F on the "BPPE" sheet then: change font to red
• If there is a 1 in column F on the "BPPE" report and the is no row for that student on the "placed" sheet then create new row on the "placed sheet" with column A-E
  • Column F and G will be manually entered - but the are formulas in column H and J to track specific dates so if a new row on the "placed" sheet is entered the formulas in H and J remain

I hope this makes since - feel free to reach out with any questions.

 

[CareerServices]

I cant find where to go to upload my spreadsheet

 

[sandy666]

I cant find where to go to upload my spreadsheet

post a link to the shared (using OneDrive, GoogleDrive or any similar) excel file with representative source reflected structure and type of data and expected result.

 

[CareerServices]

Here is the data: https://drive.google.com/file/d/1WruHIOgpmD2DSb6Lmbr8DltfOYF6laiZ/view?usp=sharing