Scheduling "Program"

feelkg211

New Member
Joined
Apr 12, 2017
Messages
30
Hey guys!

Currently making sort of a scheduling program on Excel.

I need to make a scheduling calendar that keeps note of the delivery shipments. I first used VBA to make a data entry form which lists all the data on another sheet.

My problem is matching the data from this sheet onto the calendar. If the product name matches and shipping date matches, the quantity ordered should appear. Also, I have to make sure that when someone inputs another set of data for the same item and shipping date, the quantity shown on the calendar should be their sum.

Photo for reference: Imgur: The most awesome images on the Internet

Any tips?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
@feelkg211, I can't read the headers, but I assume Columns B:AF are just the days of the month, correct?

Which cell contains your month name ("July" in the image)? Is that held in A1? If not, which cell? And how is it stored in the cell (e.g., "July" as text, 7 as a number, etc.)?

What is the name of your table in the "Orders" tab?

When you say "shipping date" in your original post, are you referring to "Customer Delivery" (Column C in the "Orders" table), or to "DIPI Shipping" (Column D in the "Orders" table)?
 
Upvote 0
Hey there!

Found a way for it to work already!

Just used the SUMIFS function.

Now I'm working on autohighlighting a cell when modified.

Got tips? Learning as I go. :rofl:

@feelkg211, I can't read the headers, but I assume Columns B:AF are just the days of the month, correct?

Which cell contains your month name ("July" in the image)? Is that held in A1? If not, which cell? And how is it stored in the cell (e.g., "July" as text, 7 as a number, etc.)?

What is the name of your table in the "Orders" tab?

When you say "shipping date" in your original post, are you referring to "Customer Delivery" (Column C in the "Orders" table), or to "DIPI Shipping" (Column D in the "Orders" table)?
 
Upvote 0
I would recommend starting a NEW thread with the separate request on auto-highlighting. Otherwise, people won't check this one, seeing it as something for which you've already received responses.

Auto-highlighting will require a VBA solution. I don't believe it's possible with conditional formatting alone. However, think carefully about why you want such auto-formatting; because once it's in play (i.e., once any cell has been modified at all), it will always be seen as "modified"; and so after the first time the highlight is applied, it will just always be applied that way, even if you change it 50 more times (i.e., it will only tell you anything ONE time: the first time it's modified).
 
Upvote 0
Yeah, I realized that too.

Thank you, tho!

I would recommend starting a NEW thread with the separate request on auto-highlighting. Otherwise, people won't check this one, seeing it as something for which you've already received responses.

Auto-highlighting will require a VBA solution. I don't believe it's possible with conditional formatting alone. However, think carefully about why you want such auto-formatting; because once it's in play (i.e., once any cell has been modified at all), it will always be seen as "modified"; and so after the first time the highlight is applied, it will just always be applied that way, even if you change it 50 more times (i.e., it will only tell you anything ONE time: the first time it's modified).
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,619
Latest member
Shiv1198

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