Previous Topic Next Topic

Macro - Help please - Newbie on macros

Closed
jneeley001 Posts 1 Registration date Friday May 2, 2014 Status Member Last seen May 2, 2014 - May 2, 2014 at 06:56 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 8, 2014 at 10:51 AM
I am new at this macro stuff and I would like to learn more. A project I'm doing now is for staff assessment forms. I already have a working macro for creating new assessment form for each new staff (from a "Template" sheet). So now I can create assessments for ABC, DEF, etc. etc.

One thing that I need is the "Summary" tab. Is it possible that the summary table in this tab will pick up the final assessment scores from each tab? Or with a click of a button, columns with contents from each assessment tab (ex: row R of each assessment tab is the average score from all assessors that needs to go to the summary tab) will be added to the end of the summary table?

Assistance would be greatly appreciated!

Thanks in advance.
Related:

3 responses

Answer 1 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
May 6, 2014 at 11:30 AM
Hi Jneeley001,

So your final scores are all on the same location across your sheets. Then go to your summary sheet, select destination cell, hit =, go to first assessment sheet, click on the final score and hit enter. Do this for the rest of the scores.

Best regards,
Trowa
Answer 2 / 3
Ryan Neeley
May 6, 2014 at 12:55 PM
Do you have time to help me out? I can send you my file. I just can't make it work. I think I got it, but when I run it, it's not functioning as intended.
Answer 3 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
May 8, 2014 at 10:51 AM
Hi Ryan,

My suggestion was without the use of macro, thus no need of running anything.

But you can always post your workbook (careful with personal info) using a free file sharing site like www.speedyshare.com or ge.tt and then post back the download link.

If I can help you, I will.

Best regards,
Trowa

Similar discussions

Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

Hello,

I am not having any luck using this code(and haver tried others).

Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$V$4" Then Call VALIDATION_LOOKUP End If End Sub

I need to automatically start a Macro then the value of a cell that contains a calculation changes.

Thanks

1 response
How to convert number into text in Excel
boratechandu -
Raj -

Hello,

pls.send me formula to convert number into text in Excel
e.g.100001 in words like' one lakh one only"

9 responses
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

Have tried several approaches, but nothing works

Have a cell that has a formula and changes based on other cells - want to execute a macro when ever the formula causes the cell value to change

Excel 2007

any help is appreciated. . .

________________________________________________________________________

I am new to this forum - I think I put the following comments in the answer section - my apologies. . .

________________________________________________________________________


The cell address that changes (has a formula in it) based on other cells on the data input form is C...

5 responses
Code for macro that conditionally inserts rows
bfleming -
bfleming -

Hello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-table

But I don't know the first thing about code and as helpful as the answer to that post is, I have no idea how to change the code to meet my particular requirements. That is:

I have daily data where the dates sometimes skip days, e.g.:

A1: 1/1/13
A2: 1/3/13. I need to insert a row
A3: 1/4/13

I need to insert a row for 1/2/13 between A1 and A2.

In some cases the data skips two days, e.g.:

A4: 1/5/13
A5: 1/8/13
A6: 1/9/13

4 responses