Previous Topic Next Topic

HELP IN MACRO

Closed
ANU - Jan 3, 2011 at 01:52 AM
rizvisa1 Posts 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
How to convert number into text in Excel
boratechandu -
Raj -

9 responses
Macro to insert row based on variable cell value (text)
deadxcell -
vcoolio -

1 response