| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I Write A Macro That Will Execute Fomula In The First Empty Ce
Hi,
I have a spreadsheet looks like this: QID C1 C2 C3 C4 %a %b %c %d 13123 b b b b 0 100% 0% 0% 13124 d d d d 0% 0% 0% 100% 13125 d d d d 0% 0% 0% 100% QID is the question ID and C1 to C4 are the answers by students. Column "%a" is the percentage of "a" answered by students. I use countif function to calculate that. Everytime I copy and paste a group of answers the number of questions ( number of rows) and number of answers (number of columns) will be different. Is there any macro that will calculate (%a, %b, %c and %d) and insert the result in the first empty column? Hope this is clear enough. Any answer will be appreciated!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Write a macro that hides rows based on empty cells | Excel Discussion (Misc queries) | |||
| How can i write a fomula? | New Users to Excel | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| How do I write a macro to delete all rows from the first empty ro. | Excel Programming | |||
| How to Write a sub to execute the following | Excel Programming | |||
Threaded Mode
