copying date from a spreadsheet with macros

January 4, 2011 at 09:06:42
Specs: Windows XP
everytime I try to copy the spreadsheet I have a different date in the copy

See More: copying date from a spreadsheet with macros

Report •


#1
January 4, 2011 at 09:52:24
Even though you haven't actually asked us a question, I am going to assume that you are looking for some type of assistance.

Do us a favor...

Make believe that you can't see your spreadsheet from where you're sitting (just like we can't) and then go back and reread your post. Do you think that you could offer any assistance based on the limited amount information you have provided?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 4, 2011 at 09:57:41
Sorry I guess part of my message got cut off. So I have a spreadsheet with macros and I need to create a copy od the sopreadsheet and everytime I do copy paste i have different date( than the original) in the copy. I tried format the date and it was not working.
Thank you

Report •

#3
January 4, 2011 at 10:49:48
You still haven't told us very much, such as:

Where is this date that keeps changing?
How does the date get into the spreadsheet (formula, macro, manual entry)?
What does the macro you mentioned have to do with this situation?

In addition, you say you "need to create a copy od the sopreadsheet" (sic) but copies of entire spreadsheets aren't usually done via a copy and paste.

We can't see what your doing, so you need to be very specific about the issue if you want our help.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
January 4, 2011 at 12:22:03
Im attaching examples of the original and the copy ( not copy and paste) but using the edit option. As you can see the date has changed.
Thanks

Original

7249 7486 29-Dec-10
7250 7487 4-Jan-11
7251 7487 4-Jan-11


Copy
7249 7486 28-Dec-06
7250 7487 3-Jan-07
7251 7487 3-Jan-07


Report •

#5
January 4, 2011 at 13:23:09
First:

re: "Im attaching examples of the original and the copy ( not copy and paste) but using the edit option"

What do you mean by "using the edit option"?

Second:

I guess you aren't getting my point, so I'll try one more time.

Including examples of the before and after doesn't help unless we know how the dates got in the original cell in the first place.

Click on the cell that contains 29-Dec-10 in the original document and tell me what it says in the formula bar. Does it show 29-Dec-10 or does it show a formula?

If it shows 29-Dec-10 then I see no reason for it to change when copied to the new document - although I don't know what you mean by "using the edit option" yet.

If it shows a formula, such as =TODAY(), then the formula is going to be evaluated and you'll get the current date.

We're still missing key pieces of information in order to help you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
January 4, 2011 at 13:39:24
Hi DerbyDad,
First thank you for bearing with me that long.
So when I click on the date I have the same date in the formula bar; e.g. 29 dec-10 in formula bar appears as 2010-12-29. The data is entered manually and the formatting is custom dd-mmm-aa. I copy going a tab " edit", function "move or copy this file" and created a copy in another book.
I hope this is more clear for you.
Thanks

Report •

#7
January 4, 2011 at 13:52:18
In my version of Excel 2003, it is "move or copy sheet" not "move or copy this file" but I'll assume it's the same feature.

I just followed those steps, using a 2010-12-12 formatted as dd-mmm-yy, and had no problems copying the sheet to another workbook.

You mentioned a "macro" earlier. What does this macro do?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question