Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create a Macro?
I'm trying to create a macro that will look for a value from a Column and if
it finds that value copy a $ amount in second column on the same row to a third column. I am trying to seperate Credits and Debits in the same column to 2 different columns. Column 1 has a value of C or D. Column 2 has the $ amount. I want to take all of the $ amounts in Column 2 that have a C in Column 1 and copy it to a third column. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create a Macro?
Since I can't see how this serves any real purpose and would best be
done with a worksheet function as opposed to a macro, my guess is that this is homework. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Dave Baden" <Dave wrote in message ... I'm trying to create a macro that will look for a value from a Column and if it finds that value copy a $ amount in second column on the same row to a third column. I am trying to seperate Credits and Debits in the same column to 2 different columns. Column 1 has a value of C or D. Column 2 has the $ amount. I want to take all of the $ amounts in Column 2 that have a C in Column 1 and copy it to a third column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
create a macro | Excel Discussion (Misc queries) | |||
Macro to Create .pdf | Excel Discussion (Misc queries) | |||
How to create a Macro.. | Excel Discussion (Misc queries) | |||
Using a macro to create a macro in another workbook | Excel Worksheet Functions |