Macro help
Chris,
Something like
Range(Baseline.Address).Copy _
Destination:= Cells(x,y)
you'll need to define Baseline.Address
or
Something like:
For x = ??? to ???
For y = ??? to ???
Cells(x,y) = Offset(Cells(x,y),???,???)
Next
Next
You may want to use Cells(x,y).Value = Offset(Cells(x,y),???,???).Value
set the ??? to fit your situation.
--
sb
"Chris" wrote in message
...
I am doing a large data entry project and I want to
automate it to a degree. I have entered into excel
a "baseline" round of data (30rows and 15 columns). I
would like to create a macro such that when I run it it
will paste the baseline at starting at the selected cell
and changing a few parameter based on inputboxes. Is
there an easy way to populate a macro with the baseline
(so that my macro will read cells(x,y) = whatever for all
the cells in my "baseline") Thanks
|