Macro help

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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
 
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.
 
Back
Top