Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA macro to populate formula result in 'next blank cell'
In a business spreadsheet, every time a predetermined condition is met I need
to record information on a "running" record. Ie. When condition 'A' is met, copy data to; 'Sheet1!E {nextblank}. As there will be a few things I need to record, I would like it all on the same row. Each data point will go in a corresponding column. *Note; the remainder of the macro will be constructed using the macro recorder. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA macro to populate formula result in 'next blank cell'
I take it that you want this to happen automatically when this
"predetermined condition is met ". You will have to specify when Excel should check for this condition. Something like; When the contents of cell XX change, check this and that and act if such and such is the case. Or; When the contents of this cell is larger than that cell, act. Or Etc. Post back and provide details about this predetermined condition and how it is met. HTH Otto "Lonpuz" wrote in message ... In a business spreadsheet, every time a predetermined condition is met I need to record information on a "running" record. Ie. When condition 'A' is met, copy data to; 'Sheet1!E {nextblank}. As there will be a few things I need to record, I would like it all on the same row. Each data point will go in a corresponding column. *Note; the remainder of the macro will be constructed using the macro recorder. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA macro to populate formula result in 'next blank cell'
Ok Otto.
Here is what I am trying to accomplish. I am tracking rental units. They can be rented for a term daily to yearly. Everytime a unit is vacated, I have a macro assigned to a command button to clear the unit information and populate the "date unit vacated" cell (by referencing a cell containing {'=today()'}). I also need this command button (same macro) to record some key info about the former "renter" on a list. Items like; name, phone number, rental period, etc. Later, this list could be used to reference on a number of functions of analysis. In essence, it would track the history of every unit for every day in the past once launched. Make sense? Any idea's? Thanks, Lonpuz "Otto Moehrbach" wrote: I take it that you want this to happen automatically when this "predetermined condition is met ". You will have to specify when Excel should check for this condition. Something like; When the contents of cell XX change, check this and that and act if such and such is the case. Or; When the contents of this cell is larger than that cell, act. Or Etc. Post back and provide details about this predetermined condition and how it is met. HTH Otto "Lonpuz" wrote in message ... In a business spreadsheet, every time a predetermined condition is met I need to record information on a "running" record. Ie. When condition 'A' is met, copy data to; 'Sheet1!E {nextblank}. As there will be a few things I need to record, I would like it all on the same row. Each data point will go in a corresponding column. *Note; the remainder of the macro will be constructed using the macro recorder. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA macro to populate formula result in 'next blank cell'
I'm not sure I understand what you want help with. You say you want to copy
some data, I don't know what data, and you want to paste it somewhere, I don't know where. You did say that you want the information pasted in the first blank row. I can help you with finding that row. Below is a snippet of code for finding that row in Column A of sheet "The Sheet". With Sheets("The Sheet") Set Dest=.Range("A" & Rows.Count).End(xlUp).Offset(1) End With Post back if you need more. Otto "Lonpuz" wrote in message ... Ok Otto. Here is what I am trying to accomplish. I am tracking rental units. They can be rented for a term daily to yearly. Everytime a unit is vacated, I have a macro assigned to a command button to clear the unit information and populate the "date unit vacated" cell (by referencing a cell containing {'=today()'}). I also need this command button (same macro) to record some key info about the former "renter" on a list. Items like; name, phone number, rental period, etc. Later, this list could be used to reference on a number of functions of analysis. In essence, it would track the history of every unit for every day in the past once launched. Make sense? Any idea's? Thanks, Lonpuz "Otto Moehrbach" wrote: I take it that you want this to happen automatically when this "predetermined condition is met ". You will have to specify when Excel should check for this condition. Something like; When the contents of cell XX change, check this and that and act if such and such is the case. Or; When the contents of this cell is larger than that cell, act. Or Etc. Post back and provide details about this predetermined condition and how it is met. HTH Otto "Lonpuz" wrote in message ... In a business spreadsheet, every time a predetermined condition is met I need to record information on a "running" record. Ie. When condition 'A' is met, copy data to; 'Sheet1!E {nextblank}. As there will be a few things I need to record, I would like it all on the same row. Each data point will go in a corresponding column. *Note; the remainder of the macro will be constructed using the macro recorder. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If formula result = 0, do not display-leave cell blank | Excel Worksheet Functions | |||
Function to treat formula result as blank cell | Excel Worksheet Functions | |||
How do I have the result of a formula display in a blank cell | Excel Programming | |||
How to get Blank into a cell as a result of a formula | Excel Worksheet Functions | |||
How to get a formula result zero as blank cell | Excel Discussion (Misc queries) |