Variable Help
 

I'm sure this is an easy task for the experts around here, but I'm having
some troubles strating out. Basically I would like to be able to bring a
gross margin value from our "Costing" and then recall that value onto a
"Change Order Sheet". That much is simple enough, but next I want to be able
to record that value permanently and then adjust and save to a new variable
as we add or subtract values from out bill. We would like to essentially have
a record of how our margin is affected as we change the order. Hopefully this
is enough information for someone to offer up some solution. Thanks for any
help.

Variable Help
 

Can you offer any more information...

Do you have any code so far?

I would suggest setting the variable when the macro runs (possibly from a
value in a cell), and then set a second variable from the first in the macro
that can be changed as needed.

My $0.02 worth...


Mark



"Darek" wrote in message
...
I'm sure this is an easy task for the experts around here, but I'm having
some troubles strating out. Basically I would like to be able to bring a
gross margin value from our "Costing" and then recall that value onto a
"Change Order Sheet". That much is simple enough, but next I want to be
able
to record that value permanently and then adjust and save to a new
variable
as we add or subtract values from out bill. We would like to essentially
have
a record of how our margin is affected as we change the order. Hopefully
this
is enough information for someone to offer up some solution. Thanks for
any
help.

Variable Help
 

I have no code thus far. I'm working with a simple sheet we have used to
calculate our Gross Margin. I dont know anything about programming in VBA so
perhaps I am getting ahead of myself here, but this is would I would like to
accomplish someday with my workbook.

"Mark Ivey" wrote:

Can you offer any more information...

Do you have any code so far?

I would suggest setting the variable when the macro runs (possibly from a
value in a cell), and then set a second variable from the first in the macro
that can be changed as needed.

My $0.02 worth...


Mark



"Darek" wrote in message
...
I'm sure this is an easy task for the experts around here, but I'm having
some troubles strating out. Basically I would like to be able to bring a
gross margin value from our "Costing" and then recall that value onto a
"Change Order Sheet". That much is simple enough, but next I want to be
able
to record that value permanently and then adjust and save to a new
variable
as we add or subtract values from out bill. We would like to essentially
have
a record of how our margin is affected as we change the order. Hopefully
this
is enough information for someone to offer up some solution. Thanks for
any
help.

Variable Help
 

Darek,

If you can send me a workbook I can work with and some detailed information
(like which cell(s) has/have the information and how you want to store it),
I will give this one a shot...


Mark Ivey



"Darek" wrote in message
...
I have no code thus far. I'm working with a simple sheet we have used to
calculate our Gross Margin. I dont know anything about programming in VBA
so
perhaps I am getting ahead of myself here, but this is would I would like
to
accomplish someday with my workbook.

"Mark Ivey" wrote:

Can you offer any more information...

Do you have any code so far?

I would suggest setting the variable when the macro runs (possibly from a
value in a cell), and then set a second variable from the first in the
macro
that can be changed as needed.

My $0.02 worth...


Mark



"Darek" wrote in message
...
I'm sure this is an easy task for the experts around here, but I'm
having
some troubles strating out. Basically I would like to be able to bring
a
gross margin value from our "Costing" and then recall that value onto a
"Change Order Sheet". That much is simple enough, but next I want to be
able
to record that value permanently and then adjust and save to a new
variable
as we add or subtract values from out bill. We would like to
essentially
have
a record of how our margin is affected as we change the order.
Hopefully
this
is enough information for someone to offer up some solution. Thanks for
any
help.