HI,
Try this :
Please revert with Calculation Output,, I did not covert last two point in
this :
Sub Test()
Dim wksSheet As Worksheet
Set wksSheet = Sheet1
With wksSheet
.Rows.AutoFit
.Columns.AutoFit
.Cells.MergeCells = False
.Rows("1:25").Delete
.Columns("A:F").Delete
.Cells.WrapText = False
.Range("A" & .Range("A" &
.Rows.Count).End(xlUp).Row).CurrentRegion.EntireRow.Copy Sheet2.Range("A1")
.Range("A" & .Range("A" &
.Rows.Count).End(xlUp).Row).CurrentRegion.EntireRow.Delete
.Range("A2:I2").Cells.SpecialCells(xlCellTypeBlanks).EntireColumn.Delete
.Cells.Replace "*3181", ""
.Cells.Replace "Source Agent: PATROL_AGENT_LINUX ", ""
Intersect(.UsedRange, .UsedRange.Offset(1)).Sort Key1:=Range("C2")
End With
End Sub
Thanks
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of RAJA SHEKAR
Sent: Jan/Sun/2012 09:02
To: excel-macros@googlegroups.com
Subject: Fwd: $$Excel-Macros$$ Reports in excel
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
--
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
