Need assistance to create multiple entries from one using VBA.

[Ilikeideas]

Hi Everyone,

I need a slight help to create multiple entries from the original using VBA magic. In a nutshell, here's what I want to do:

Original Entry: 1111111111 512345 6/4/2013 10:49:03 AM

I need to replicate this entry by adding and deducting 5 minutes. My expected output is:

1111111111 512345 6/4/2013 10:44:03 AM
1111111111 512345 6/4/2013 10:49:03 AM
1111111111 512345 6/4/2013 10:54:03 AM

Please see attached spreadsheet for some more examples.

Thank you in advance for your help!

Regards,
ILI

[nilem]

Hi ILI,
try

Please Login or Register  to view this content.

[Ilikeideas]

Works great on the sample. I will run it on my real data set and come back shortly.

Thanks for your kind consideration to my request.

Regards,
ILI

[Ilikeideas]

Thanks…This works great!

Just one slight issue as soon as I convert the file into a CSV the seconds get converted into 00.

Example: On conversion to a CSV the output changes from:

1111111111 512345 6/4/2013 10:49:03 AM

TO:

1111111111 512345 6/4/2013 10:49:00 AM


Could you advise as to why this may be happening?

Thanks,
ILI

[nilem]

try setting the cell format hh:mm:ss, and then save as csv

[Ilikeideas]

Sorry, was unwell…and therefore could not respond earlier!

The hh:mm:ss approach doesn’t seem to work. Please let me know if you have any other thoughts to help me counter it.

Anyways closing the thread. Thank you!