Excel 2007 : Macro to fill in a relative position

**OtisMardres** · 03-13-2011, 07:56 PM

I'm new to Excel, learning as I go along, and I have a question. I have a macro that is supposed to carry numbers from one sheet to another, but it doesn't. It over writes the same cell everytime. I want it to post the numbers by date (3/11/2011, 3/12/2011, etc) but it continuously writes a new number into the same date. Here is my macro. I'm new to Excel, please remember that, so it may be a little long.

Please Login or Register  to view this content.

that is basically it.........anyone with any help to offer would become my new best friend

Otis

**pike** · 03-13-2011, 11:35 PM

Hi OtisMardres
very hard to say wth the information provided but
maybe...

Please Login or Register  to view this content.

**OtisMardres** · 03-14-2011, 03:41 PM

Thanks Pike......I'll try that and get back to you.

**OtisMardres** · 03-15-2011, 07:17 PM

Pike,
I found the answer I was looking for. Thank you so much for your help. It's nice to know that I have resource to fall back on when needed. Thanks again.

Otis