Shekar,
When you ask for a solution, it would be best for people who volunteer to
help to understand exactly how your final output would look like.
If you ask me, I could not understand step 9 above, what to replace. The
code below will do everything above.
Sub Consolidator()
Dim rngCell As Range, bytPos As Byte
With ActiveSheet
With .UsedRange
.UnMerge
.WrapText = 0
End With
Set rngCell = .Cells(1, 1)
Do While Not .UsedRange.Offset(1).Find(What:="Index ",
LookAt:=xlWhole) Is Nothing
.Range(rngCell, .UsedRange.Offset(1).Find(What:="Index ",
LookAt:=xlWhole)(bytPos)).EntireRow.Delete: bytPos = 1
Set rngCell = .Cells(1, 7).End(xlDown)(2)
Loop
.Range("A:F").Delete xlToLeft
.Range("B:D").Delete xlToLeft
.Range("E:E").Delete xlToLeft
.Range("C:C").Delete xlToLeft
End With
End Sub
Regards,
Sam Mathai Chacko
On Sun, Jan 8, 2012 at 9:02 AM, RAJA SHEKAR <jrsjrs...@gmail.com> wrote:
> Hi Team,
>
> Any update per my below mail. Need your help..
>
> Regards,
>
> Shekar
>
> ---------- Forwarded message ----------
> From: RAJA SHEKAR <jrsjrs...@gmail.com>
> Date: Wed, Jan 4, 2012 at 9:47 PM
> Subject: Fwd: $$Excel-Macros$$ Reports in excel
> To: excel-macros@googlegroups.com
>
>
> Hi Rajan,
>
> Any update per my below mail. Your help is required to create macros.
> Please advise.
>
> Regards,
>
> Shekar
>
> ---------- Forwarded message ----------
> From: RAJA SHEKAR <jrsjrs...@gmail.com>
> Date: Sat, Dec 31, 2011 at 10:13 PM
> Subject: Re: $$Excel-Macros$$ Reports in excel
> To: excel-macros@googlegroups.com
>
>
> Hi Rajan,
>
> I usually get 2 different mails for Linux & Windows which has their CPU &
> Memory usage for the day.
>
> I have attached two file (Windows CPU & Memory, Linux CPU & Memory).
>
> When you open the Linux file, you may find that the column-row A1-A287 to
> O1-O287 has been highlighed.
>
> Steps I do:
>
> First & foremost thing I have to copy the data from my mailbox to an empy
> excel sheet. Then,
>
> 1. Remove Wrap Text
>
> 2. Remove Merge & Center
>
> 3. Remove Row 1 to Row 25 & then to remove row 122 to row 136
>
> 4. Remove Column A to F
>
> 5. Cut & Copy row 122 to 242 to sheet no. 2
>
> 6. Delete Column A to F
>
> 7. Delete column B,C,D
>
> 8. Delete Column C & E
>
> 9. Replacing the Linux Memory, CPU (Memory & Source Agent: Patrol Agent
> Linux & the number after the server name (:3181) with none.
>
> 10. Data sorting (Ascending)
> 11. For Linux Memory - Inserting two more columns next to Avg Value (%). I
> have to calculate the Avg value by subtracting the Avg value from 100.
> Inserting % symbol & concatanate the % symbol with the Avg. value. Eg:
> 100-93.43 = 6.57. Then inserting % symbol in next column. Then
> concatanating (6.57,%)/1 gives me the value 6.569999. Now I have to insert
> % symbol again and to decrease the decimal points to 2. The final value
> would come as 6.57%. And for Linux Max value, I have to subtract Min value
> from 100 to get Max value. Rest of steps is same as above. This is
> applicable only for Linux Memory.
> For Linux CPU no need to subtract the value from 100. I have to just
> concatanate the cells only & rest is same as above to get the final value.
> 12. For Windows Memory & CPU - Same as Linux CPU steps
>
> The final figures (Windows CPU & Memory, Linux CPU & Memory) needs to be
> given to the management.
> To make things more quick I need to have a simple way of doing by creating
> some kind of macro assigned to some button/tab which would help me gain
> some time.
>
> Request you to help in this matter.
>
> Regards,
>
> Shekar
>
>
> On Sat, Dec 31, 2011 at 6:42 AM, Rajan_Verma <rajanverma1...@gmail.com>wrote:
>
>> 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
>>
>
>
>
> --
> FORUM RULES (986+ 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
>
--
Sam Mathai Chacko
--
FORUM RULES (986+ 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
