Data input and database record using macro's

  • Thread starter Thread starter Sum Limit and marking
  • Start date Start date
S

Sum Limit and marking

Is there a way to program Excel to complete the following actions using a
macro:

Worksheet 1: Input the following information –

Quarter
Year
Name
Grade

Worksheet 2: Database of record from Worksheet 1. Data is automatically
transferred into this worksheet upon inputting the above information. Data
within this worksheet is organized as listed above in separate columns.

Worksheet 3: Upon inputting the information from Worksheet 1, a line graph
is produced based on the Name inputted from Worksheet 1. Line graph will
only show the previous Grade of that Name.

Please let me know if you can help me on this?

Thank you.
 
Is this something I can even complete in Excel or is this something I should
complete in Access??

Thanks.
 

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

Similar Threads

Excel 2013 Merge Data 2
Trouble with ActiveX Control - Combo Box 4
Editing Recorded Macros in Excel - VB 1
Auto update some spreadsheets inside a shared workbook and NOT others 0
Changing name of worksheet based on data in cell of another worksheet 14
fill in data that is not empty 1
copying a template sheet and inputting a formula into another sheetthat references the new sheet 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top