Scheduling "Program"

[feelkg211]

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?

 

[inactiveuserps07]

@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)?

 

[feelkg211]

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.

@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)?

 

[inactiveuserps07]

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).

 

[feelkg211]

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).

 

[inactiveuserps07]

Hope it's coming together for you.