Macro to copy active cell

  • Thread starter Thread starter Kou Vang
  • Start date Start date
K

Kou Vang

I'm trying to write a macro to copy a row of data that has
only one data point across a number of columns that has
the year. So what I want to be able to do is to copy the
data, and somehow reference the year, which is in the
first row 1. So it would give me the data and the year of
the one and only data point. I was thinking it must
involve a For Each Cell statement. Thanks. Sorry if it
sounds a bit vague. It's either a macro, or go through
2300 records by hand, and I don't think I want to even
think about the second one.
 
What you write is a little confusing. Post back with some details. For
instance, you say you have one row of data with only one data point. What
does that mean? Give an example, like this cell has this, this other cell
has that, etc. Then where is this date that you want to reference? And
what do you mean by "reference the date"? HTH Otto
 
Back
Top