LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 258
Default Macro to Automate Row Results.

I wonder if you can help me to setup this macro.
I have values located in the excel cell as shown below:

A B C D E F G H
1 bag 24 24 24 =SUM(A1:C1) 63 top
2 tube 24 24 21 =SUM(A2:C2)
3 cord 24 24 18 =SUM(A3:C3)
4
5 top 24 21 18 =SUM(A11:C11)
6 center 24 21 15 =SUM(A12:C12)
7 paper 24 21 12 =SUM(A13:C13)


Basically, what I am doing is:
1.- Taking the sum for each row.
2.- Compare them with the number located in the cell €œ G1€.
3.- Find the row that match the number in the cell €œG1€.
4.- Write in the cell €œH1€ description of the row found.

In my sample the selected row is number 5 which is cell €G1=63€ and cell €œH1
= top€.
Do you thing you can help me to get a macro to automate this procedure?

Thanks in advance.
Maperalia

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automate Macro Jeremy Excel Discussion (Misc queries) 3 June 29th 09 11:22 PM
Automate Macro Chiku Excel Discussion (Misc queries) 0 December 15th 05 12:25 AM
Automate Autofilter Results - Copy to New Sheet Annie Excel Programming 2 November 4th 05 11:03 PM
Automate grading of performance test results rkm Excel Worksheet Functions 1 May 24th 05 09:28 PM
How can I list the results of my macro without overwritng previous results? mattip Excel Programming 3 November 28th 03 03:45 AM


All times are GMT +1. The time now is 01:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"