I am trying to create a Excel spreadsheet for students ordering lunch items.
I need to know the answers to the following:
a. Is there a way to run a macro when a Excel workbook is initially opened?
b. Is there a way to read a calendar using the current date to identify the
cell where the date is located?
c. If the answer from b is yes, is there a way to move data from the 4
cells below the cell containing the matching date to 4 cells in a different
worksheet?
d. Is there a way to scan a series of cells for a specific character, such
as, as X?

a. Yes, Workbook_Open() runs when workbook is opened.
b. Not clear but today() formula returns today's date
c. Yes, but through VBA Code
D. Yes

"Dave G." wrote:

I am trying to create a Excel spreadsheet for students ordering lunch items.
I need to know the answers to the following:
a. Is there a way to run a macro when a Excel workbook is initially opened?
b. Is there a way to read a calendar using the current date to identify the
cell where the date is located?
c. If the answer from b is yes, is there a way to move data from the 4
cells below the cell containing the matching date to 4 cells in a different
worksheet?
d. Is there a way to scan a series of cells for a specific character, such
as, as X?