macro for populating a time sheet with values from another excel sheet - TechRepublic
Question
June 18, 2009 at 12:27 AM
sakshiv7777

macro for populating a time sheet with values from another excel sheet

by sakshiv7777 . Updated 17 years ago

I am relatively new to Visual Basic and need little help in this problem that I am having

I have two excel sheets – one of which contains –

Start Week, Start Month, Days worked per week, Number of working weeks
eg:-
1 Jan-2009 2 12
3 Feb-2008 5 50


Using this I have to fill another time sheet in the same workbook which contains columns corresponding to months and weeks… so lets say –
starting from week 1 of Jan-2008 i hav to fill the next 12 columns with the value 2

I am in a kindof fix with this problem 🙁 and have to finish off this task in the next week…It would be really gr8 if you could help me out… If required I can also send you the excel sheets…

This discussion is locked

All Comments