Excel

D

Dave G.

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?
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top