| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column values
Hi, I have a worksheet that very 3 columns are grouped, they are not merged but every 3 columns are related. example it starts from column (D,E,F) (G,H,I) (J,K,L) and so on. I am trying to make a macro that will look into the first column example (D9) and see; if (D9) is = to the number in (F9) then Delete the Values in (E9) and (F9) if (D9) is < to the number in (F9) then enter "of" on (E9) and if (D9) is (empty, no value) then Delete the Values in (E9) and (F9) and then move to the next row in that columns all the way from (D9:D71) after it is done then next group (G,H,I) (G9) the Sheet is (Active Sheet) the Cells are from D9:IL71 I would appreciate if anyone can help me with this. Thank You |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column values
Marc,
Are there any empty (no data) cloumns between the sets of three? " wrote: Hi, I have a worksheet that very 3 columns are grouped, they are not merged but every 3 columns are related. example it starts from column (D,E,F) (G,H,I) (J,K,L) and so on. I am trying to make a macro that will look into the first column example (D9) and see; if (D9) is = to the number in (F9) then Delete the Values in (E9) and (F9) if (D9) is < to the number in (F9) then enter "of" on (E9) and if (D9) is (empty, no value) then Delete the Values in (E9) and (F9) and then move to the next row in that columns all the way from (D9:D71) after it is done then next group (G,H,I) (G9) the Sheet is (Active Sheet) the Cells are from D9:IL71 I would appreciate if anyone can help me with this. Thank You |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column values
Hi,
No empty cloumns between the sets of three. Thanks. On Jul 9, 11:53*am, JR Form wrote: Marc, Are there any empty (no data) cloumns between the sets of three? " wrote: Hi, I have a worksheet that very 3 columns are grouped, they are not merged but every 3 columns are related. example it starts from column (D,E,F) (G,H,I) (J,K,L) and so on. I am trying to make a macro that will look into the first column example (D9) and see; if (D9) is = to the number in (F9) then Delete the Values in (E9) and (F9) if (D9) is < to the number in (F9) then enter "of" on (E9) and if (D9) is (empty, no value) then Delete the Values in (E9) and (F9) and then move to the next row in that columns all the way from (D9:D71) after it is done then next group (G,H,I) (G9) the Sheet is (Active Sheet) the Cells are from D9:IL71 I would appreciate if anyone can help me with this. Thank You- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
| Autosum column values, if separate column values equal certain val | Excel Worksheet Functions | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Calculating values to column D with formula based on values column A | Excel Programming | |||
| How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming | |||
Linear Mode
