Variable Help

[Darek]

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.

 

[Mark Ivey]

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]

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]

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