Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Summary in Excel using macros
Name: jammy Date: January 27, 2009 at 02:16:07 Pacific OS: Windows XP CPU/Ram: 1 gb Product: Ibm / DONT KNOW Subcategory: Microsoft Office
Comment:
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.
Name: Bryco Date: January 27, 2009 at 05:36:19 Pacific
Reply:
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.
Summary: hi, I want to add drop down in excel using the macro. my concenpt is as follows. if we select "USA" in cell1,1 then the list of states must pop up in cell1,2 and same way for all countries. ...
Summary: I want to sample a cell in Excel and if it is empty, I want to delete that row. I can delete a row using the row number but can't do it using a variable. Example.. for row = 1 to 5 if activeheet....
Summary: I want to use macro in access to create a new column in several different tables. These columns shall consist of a prefix that I choose, typically "PM_" and then an objectID from the ObjectID column s...
0 
