Tab Content
No Recent Activity
About Hands

Basic Information


Please login or register to view this members information

Statistics


Total Posts
Total Posts
3
Posts Per Day
0.00
Total Thanks
Total Thanks
0
  • Thanked 0 Times in 0 Posts
Wiki
Total Edits
0
Pages Created
0
General Information
Last Activity
5th May 2012 12:57 AM
Join Date
29th March 2012
Referrals
0
View Hands's Blog

Recent Entries

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

by Hands on 5th May 2012 at 12:46 AM
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

Read More

Categories
Uncategorized

5th May 2012