Auto Date Stamp Column A when data in Column B

**medihx** · 10-31-2011, 04:16 PM

Hi Everyone

I have a workbook with a button called Archive and when this is pressed it takes data from Sheet 4 and places it in Sheet 3. Now i would like to add a date in column A of sheet 3 when the data is placed there.

I have a little code that works great by itself but when used in conjunction with the archive button it just fills columns B to AB with the number 40847 i dont know where this is coming from. Columns AC to BE work ok.

Any help on this would be great thanks

**JBeaucaire** · 10-31-2011, 05:25 PM

40847 is the actual "number" that is Excel's reference for dates. Just format that cell(s) with the date format you want and you'll see.

40847 = 10/31/2011

Happy Halloween!

**medihx** · 10-31-2011, 05:39 PM

Thanks for the quick responce and clarification on where 40847 was coming from i thought it was strange.

The problem that i still have is that the cells where this number is populated should have data that is transfered from Sheet 4 not the date which should only be in column A on sheet 3.

**JBeaucaire** · 10-31-2011, 06:56 PM

The problem was caused by the worksheet_change macro in your "Archive" sheet. Change to:

Please Login or Register  to view this content.

You need to rename your COPY macro to something else... COPY is an Excel VBA command, this is just asking for trouble using that as a macro name. Name it ArchiveData instead.

Also, I cleaned it up the other macros just a little bit.