Jump to content
EduGeek EdSec 2026 is Go! 27th Oct in Derby! Join us for a day of EdTech security focused talks, networking, and an evening social ×
  • entry
    1
  • comment
    1
  • views
    177

Entries in this blog

Excel Macro to Populate a Range based on Info in Another Area of Workbook

Here is the input: Activity, start week, end week   Based on the above info in the the first three columns of a spreadsheet, put a number or a string in the same row under the appropriate week number. So if an activity happens from week 18 (this week) to week 25, the corresponding columns would be filled with the number 1. So far I have not been able to figure out how to do this using macros. Seems pretty simple but I'm struggling since I have zero experience with Visual Basic and objects,

Hands

Hands

×
×
  • Create New...