Summary in Excel using macros

jammy January 27, 2009 at 02:16:07
Specs: Windows XP, 1 gb
I need to write a macro in excel 2007 to generate an summary , as in Summary is a different sheet in my workbook there are 2 in total.
In the first sheet there are columns results, i need the macro to automatically update on the summary sheet the status of the result column in the first sheet, the values in result column are pass,fail,blank . I know this is probably simple but the tutorials for writing macros is greek to me. I am a user not a programmer. Please help.

See More: Summary in Excel using macros

Report •

January 27, 2009 at 05:36:19
Let's say that "the result column in the first sheet" is in cell A10 then in sheet2 just use =Sheet1!A10 and it will automatically show whatever is in A10 on Sheet1.

No macro needed.


Report •
Related Solutions

Ask Question