VBA Sub procedure

M

mpstorey

New Member
Joined
Nov 7, 2010
Messages
4
Hey everyone , I was wondering if you help me. I'm having a very difficult time creating a sub procedure for the following problem.

Here it is.


to write a [FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]VBA sub procedure [/FONT][/FONT]called [FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]Timetable [/FONT][/FONT]to help him automate the conversion of his daily schedule to a timetable. Your sub procedure should read information stored in cells A2 to D5 and convert this data into a timetable as shown below. For your sub procedure you may use the following assumption:
-Time is displayed in military format (24 hours)
-You instructor always has 4 schedules per day
-Every meeting would start and end right on the hour (meeting would last at least

Here is a link for what the layout is suppose to be
www.wix.com/mpstorey/Timetable

thanks a lot , your help is very appreciated
 
Sort by date Sort by votes
okay i have the layout just like the picture that was posted up earlier..
all the infomation starts from a1 (meeting type), d1 (location), to a5(office hours), too d5 (ub3064)

the timetable starts on a8 (8:00) and the time and date located on b7-c7 the timetable stops on a8-c20

and with the code inserted, it doesnt work

i run the macro timetable and all i get is office hours ub3064 showing up in the wrong place of 19.00 to 20.00
 
Upvote 0

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sorry, I'm having a hard time following. If you can post an example on a file sharing site like box.net, I'd be more than happy to take a look.
 
Upvote 0
Without seeing your actual data set, my guess is you have a mix of text and number formats and it's throwing things off.

If you'd like to post your file on a file sharing site like box.net, I'd be more than happy to take a look, but I think that's the issue as to why you're not getting the expected results.
 
Upvote 0
The problem is, you're trying to match "10" with "10:00:00 AM" and that's not going to work. I'll sort something out tomorrow and post it.
 
Upvote 0
You must log in or register to reply here.

Similar threads

excelbytes
  • Solved
Looping Procedure In VBA Code
2 3
Replies
24
Views
503
excelbytes
excelbytes
Y
  • Question Question
VBA Code to activate the tab and and transfer data
Replies
1
Views
274
Joe4
Joe4
S
  • Solved
VBA linking Class(es) and Userforms
Replies
4
Views
557
Jaafar Tribak
Jaafar Tribak
D
  • Question Question
VBA to Create Outlook Email Not Working for All Users
Replies
9
Views
382
Logit
Logit
B
  • Solved
Formula or VBA to track pro-rated attendance hours
Replies
8
Views
406
bh24524
B

Forum statistics

Threads
1,225,149
Messages
6,183,193
Members
453,151
Latest member
Lizamaison

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top