Macro to format date correctly

[celeazul]

Hi,
Can someone please help me fix the macro for the "Maroon" tab. So it formats the date correctly MM-DD-YY, when it copies from yellow to maroon tab?
I believe the problem lies here

Please Login or Register  to view this content.

See attached doc

Once you click on "Copy Cancelled" button on the Cancellations Report (maroon tab), it does everything perfectly. Except its not formatting the date on column I correctly. Can you help? Thanks in advance.

Cele

[ikboy]

Try this:

Please Login or Register  to view this content.

[celeazul]

unfortunately that did not work

[AB33]

You are copying column J which has nil values in to column I.
If you want to copy column I, use this line instead,

Please Login or Register  to view this content.

OR use these lines

Please Login or Register  to view this content.

[celeazul]

One last question. This last tab on the far right's macro, is acting up, can you help?
When I filter column Q on the yellow tab (Renewal Report) by y and by n its supposed to copy and paste the following columns to the tab in the far right called Report-All
See illustration below on how whats supposed to be copy where:

[AB33]

You have a table, not a range. The code have will not work, it is just hidden by an error trap. See new code on module 3.

[celeazul]

See below. When i click on the button to paste the info it should paste these columns. See below

[AB33]

I hope I have missed any column.

[celeazul]

Almost there. The only thing that needs to be fix, is that it should not be adding extra columns after column I. Can that be done?

[AB33]

I do not see where the code is adding any data after column I. It is most likely these data have already been there. Clear all rows and run the code.
Could you show me with attached sample?

[celeazul]

Please see attach

[AB33]

You have already got existing data. You need to clear them first and run my code. My code does not clear anything, only populates the data.

[celeazul]

Yeah thats what i was afraid of. I need the code to leave things alone, and move these columns only. Not the whole set.

[AB33]

I have lost you. The code does not touch any other columns. When you run the code, do you see any data except the above columns? Show me where exactly the extra data are added?

[celeazul]

See illustration below. Whats after column I. I circled it in red.

[AB33]

I do not understand why keep attaching a picture, instead of an excel workbook. I went the extra length to show you the code on a sample book, but you keep showing me in a picture. I can not see or test the code on pictures. You need to show me in excel book why the code is not working.

[celeazul]

i sent the attachment 4 messages ago, and you you said you didnt understand. thats why i sent the picture. here is the attachment once again.

[AB33]

Which you code you are running on the attached file? Is it the code on sheet Report - all(copy for Friday report)? The button is attached to a different code.
You need to manually run the code called Sub you_have_a_table() or attach this code to a button. I keep running this code from my end and still do not see the issue. You have many codes.

[celeazul]

I am running Report - all code. And when the button is pressed, what i attached on the prior message is what happens. I copies all rows on the blue tab called Report - all. Its only supposed to copy the columns i mentioned above.

[AB33]

As I said, you have many codes. I do not know how are you running these codes, but as far as I am concerned, I run the code directly and I do not see what you are getting. You need to go to the code itself and press f5 to run it and see if the code is right or not. There is only one code on module3, all you have to do is go in to that module and run it.

[celeazul]

Understood. See attached. Everything records properly except column G the Report - all tab is pasting the wrong info. Column G on the Report - all should be pasting data from column Q on the yellow tab (Renewal Report).

[AB33]

That is not to say the code was posting in columns outside column I. You now seem to accept the code was right, excepting it is copying the wrong column. Yes, I might counted wrong columns.

[celeazul]

I wanted to take the opportunity to thank you for all your help. This looks great. A million thanks again, for everything you've done! You're the best.