Hi sekhar. It can be easily done by VBA .please attached your sample data and write the procedure what you need to done.. Group will help you
Rajan. -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shekar Sent: Dec/Sat/2011 04:25 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Reports in excel Hi Sir, I have a good knowledge in Excel however I want to learn VBA also. I have interest in learning macros since I used to work in a BPO where simple & advanced macros were used to make the job more easier. Since my daily work includes to prepare some type of reports in excel to be send to the management. I normally uses the basic elements of computing (cut, copy, paste) & to some extent I use excel formulas. To start with I need copy a mail which has some information (server name, cpu & memory consumption) & paste it into a new excel sheet. After doing so I would allign (Wrap, Merge & deleting some the rows & coloumns) those cells to my needs. I use concatanate formula to merge 2 cells to make it into one & inserting formual to get into the output which I need. I have seen people in BPO where they use macros assigned to a particular button/tab. By clicking that tab the person retrieves the data fetched from some other resource & sheet getting filled. Now I need to have a simple way of doing by creating some kind of macro which would help me gain some time. Please advise & help. Regards, Shekar -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
