Previous Topic Next Topic

HELP IN MACRO

Closed
ANU - Jan 3, 2011 at 01:52 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 - Feb 9, 2011 at 05:05 PM
Hello,

happy nEW year i need your help in macro . i have some data like below in excel

A B C E F
Customer Name RDS ID Device ID Product Name Installation Date (dd-mm-yyyy)
abc MSR01437 MSR01437 iR2230 22-04-2010

G H I J K L M
Date and Time LastReceived Total BA3 BA4 CA3 CA4 B C
31-12-2010 12:16 516299 5221 511078 0 0 516299 0


AND I NEED ABOVE DATA CONVERT LIKE BELOW FORMAT


A B C D E
Customer Name RDS ID Device ID Counter Date
ABC MSR01437 MSR01437 516299 31-12-10
ABC MSR01437 MSR01437-BA3 5221 31-12-10
ABC MSR01437 MSR01437-BA4 511078 31-12-10
ABC MSR01437 MSR01437-CA3 0 31-12-10
ABC MSR01437 MSR01437-CA4 0 31-12-10
ABC MSR01437 MSR01437-B 516299 31-12-10
ABC MSR01437 MSR01437-C 0 31-12-10

Thanks in advance for your answer!


1 reply

Answer 1 / 1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Feb 9, 2011 at 05:05 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note: your data need not be to be real data but a good representative of how data looks like
0