Hi all
I need help on the following in EXCEL 2007:
Compare the values of sheet 1:column A with Values of Sheet2:column A
If the CELL values in sheet1 column matches with Range of values in
Sheet2 column.
copy that CELL VALUE from sheet1 and paste it adjacent column (Column
B) of sheet2. Or
Hi Rajan,
Thanks for your prompt response. After testing this code. I had the
following output:
Files created with .xml extension, according to the number of records.
These files were in the XML format, however the Tags were not as per the
column heads.
following is a sample output:
?xml
Dear All,
Plz see the attach file. I can’t understand why I m unable to do sum. What is
the problem in sheet or number? Help anybody?
Regards
LAKSHMAN
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Dear Hemant,
It can be achieved using the vlookup formula.
Suppose you have a data set in Sheet 1 from A1 to A9, which you need to
compare with the values present in column A in Sheet 2
Then in Column B, please type:
=VLOOKUP(A1,Sheet1!$A$1:$A$9,1,0)
and drag the formula down.
You will get
Dear Lakshman,
You are not able to do the SUM as the data in the last column has leading
and trailing spaces.
You can use the add-on http://www.ablebits.com/excel-trim-spaces/index.php
to quickly remove the spaces, if you regularly receive/generate such data.
Cheers,
Andy
On Wed, Dec 7, 2011 at
NOTE:
I am using the simple TRIM() function as the data you have sent contains
multiple spaces in the trail.
On Wed, Dec 7, 2011 at 2:35 PM, Aindril De aind...@gmail.com wrote:
Dear Lakshman,
You are not able to do the SUM as the data in the last column has leading
and trailing spaces.
You
Sorry NOT USING TRIM
On Wed, Dec 7, 2011 at 2:39 PM, Aindril De aind...@gmail.com wrote:
NOTE:
I am using the simple TRIM() function as the data you have sent contains
multiple spaces in the trail.
On Wed, Dec 7, 2011 at 2:35 PM, Aindril De aind...@gmail.com wrote:
Dear Lakshman,
You
Dear Hemant,
You can use below function with Conditonal Formating..
=MATCH($A1,Sheet2_range,0)
Sheet2_range is name range of Sheet2 B Column.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Hi Lakshman,
Please use the below codes:
Sub Right_Delete()
' This module will delete text from Right in selected cells.
Dim MyCell As Range
Dim Total_Chars As Integer
On Error Resume Next
Total_Chars = 2
For Each MyCell In Selection.Cells
If
Hi Friend,
Can we click on HTML button using getelementbyclass(abc).click,
if this is possible please let me know with example.
Thanks
Mithlesh Sharma
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Dear Lakshman,
Please try it and see attached Sheet..
Sub Remove_Space()
Application.ScreenUpdating = False
On Error Resume Next
For Each C In Selection
If Trim(Len(C)) 0 And C.HasFormula = False Then
C.NumberFormat = General
C.Value = CDbl(C)
End If
Next
You can create a form or report, with the required format.
It is needed to write VBA code based upon the dates given.
As u said If you require report from 01-jun-2010 to 31-aug-2010, which
will be provided as inputs to form/report
Then it is required to calculate the opening balance which is
Hello Rohan,
Even though Excel and Access are two products of MS-office, working
with them is quite different.
While in excel the core term is cell, which when culminated leads to
rows, columns, worksheets workbooks.
In excel we work with formulas functions, with relative or absolute
cell
Thanks to all with the help of all of U, I understand the main problem.
From: Maries talk2mar...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, 7 December 2011 2:45 PM
Subject: Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum
Hi
thanks to all
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, 7 December 2011 3:08 PM
Subject: Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum
Dear Lakshman,
Please try it and see attached
Hi All,
Can someone help me out to extract number from string in Excel.
Ex: 1_EB_AHR should write 1
456_EBF_RTY should write 456
1456_HGH_FG should write 1456
Thanks...
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
=LOOKUP(99^99,--(0MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A10123456789)),ROW($1:$1
On Wed, Dec 7, 2011 at 2:30 PM, Raghunandan raghunandan...@gmail.comwrote:
Hi All,
Can someone help me out to extract number from string in Excel.
Ex: 1_EB_AHR should write 1
456_EBF_RTY should
hi
please use this Array Function with Shift+Ctrl+Enter
={SUM(VALUE(LEFT(E2:E18,LEN(E2:E18)-1)))}
On Wed, Dec 7, 2011 at 2:45 PM, Maries talk2mar...@gmail.com wrote:
Hi Lakshman,
Please use the below codes:
Sub Right_Delete()
' This module will delete text from Right in selected cells.
hi
please see the attached File..
Hope this will help
Rajan.
On Wed, Dec 7, 2011 at 2:00 PM, hemant hemantda...@yahoo.com wrote:
Hi all
I need help on the following in EXCEL 2007:
Compare the values of sheet 1:column A with Values of Sheet2:column A
If the CELL values in sheet1 column
This macro will copy the template and name each sheet with the start of the
week (short names better)
If you want the first MONDAY then change ,7 to ,8
Option Explicit
Sub addsheets()
Dim i As Long
For i = Day(DateSerial(Year(Date), 1, 7) - _
WeekDay(DateSerial(Year(Date), 1, 6))) To 365 Step 7
see the attached File..
On Wed, Dec 7, 2011 at 12:34 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Dharti Kumar,
Please see attached doc to create Progress bar in Excel.
-
Thanks regards,
Noorain Ansari
Try this
For each Element in HDoc.getelementbyclass(abc)
element.click
next element
On Wed, Dec 7, 2011 at 2:34 PM, Mithlesh Sharma mtshar...@gmail.com wrote:
Hi Friend,
Can we click on HTML button using
getelementbyclass(abc).click, if this is possible please let me know with
A macro to populate column B
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: hemant
Sent: Wednesday, December 07, 2011 2:30 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Formula Help
Hi all
I need help on the following in EXCEL 2007:
Compare
You can use this as well...
=MID(C9,1,FIND(_,C9)-1)
Thanks
Rohan.
--
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
Also, select col_E press Ctrl+H to activate Find/Replace,
from the keyboard NUMERIC side (right side of the keyboard, not the top
row) Press Alt+0160 in Find What box: and click Replace All. Now you can do
a simple SUM.
Or use this Array Formula,
Great Haseeb,
Thanks for your valuable Suggestion...
Really you are magician of Excel Formula
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Hi Noorain,
The macro only worked for the first sheet, after I run it again I receive
this error #: 1004
Sheets(Sheets.Count).Name = Sheet18.Cells(i, A).Value
On Tue, Dec 6, 2011 at 8:09 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Susan,
Please try it and see attached
I copied and pasted your code from below in a blank spreadsheet and when I
run it I received the following error: Script out of range.
Please advise.
Thanks![?]
On Wed, Dec 7, 2011 at 7:04 AM, dguillett1 dguille...@gmail.com wrote:
This macro will copy the template and name each sheet with
The macro assumes that you do, indeed, have a sheet named Template that you
want to copy and name jan 03, jan 10, etc.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Susan 1
Sent: Wednesday, December 07, 2011 2:10 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Not figured out what your macro ishowever what I can suggest you
can use the Offset function to have the range of the
Conditional formating extended automatically.
Use, =Offset(A1, Counta(A:A), 0), assuming you want to apply
conditional formatting in the column A.
Put the above stated
I believe then I'll need to make a template sheet :-)... okay thanks
for clarifying it! :-)
Appreciated!!
On 12/7/11, dguillett1 dguille...@gmail.com wrote:
The macro assumes that you do, indeed, have a sheet named Template that you
want to copy and name jan 03, jan 10, etc.
Don Guillett
Attach your final result for comments
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Susan 1
Sent: Wednesday, December 07, 2011 5:56 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one
Not really. It was using the first Sunday of the current year and adding a 7
days so you would have 52 sheets.
I have changed it to use Jan 1, 2012 as the starting date, adding a week for
each sheet. See attached,
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
I'm using MS Outlook 2007 and I'm making a call to my mail folder to
get the mail items.
I need to get the email address, but it is providing me with an email
address like:
/O=mycompany/OU=SITE07/CN=RECIPIENTS/CN=hillgoogle
My code looks like:
Dim olApp As Object
Dim i As Integer
Thanks for the PPT. I'll read it try to develop VBA. Codes :)
--
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
Hello All,
Firstly, Thanks for all the contribution to this wonderful community. Has
been a lot of help always.
Coming to my Query...I need to get the data in certain cells (text and
numeric) to display single quotes at the start and the end.
Have tried this saving the excel sheet in all
Great Macro Don! Very helpful for my task... I really appreciate your
assistance with this and you were also very fast at responding.
You are awesome :-)
Sunnie
On Wed, Dec 7, 2011 at 4:51 PM, dguillett1 dguille...@gmail.com wrote:
Not really. It was using the first Sunday of the current
Hi Macro team,
I have a lot of tables in excel that I need to paste on powerpoint. Please help
me.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Thanks to all for the Prompt reply.
The problem is solved.
Regards
Hemant Dange
On Dec 7, 9:55 pm, dguillett1 dguille...@gmail.com wrote:
A macro to populate column B
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: hemant
Sent: Wednesday, December
Please add the following code.
rst.update
after assigning values to the fields
Also instead of using rst.fields(0), --- you can use
rst.fields(fileno) which will be more legible and readable.
Private Sub cmdsave_Click()
Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset(select * from
Dear Lakshman,
You can also use simple...
First Select Range
Goto DataText to ColumnDelematedRemove SpaceEnter
Then you can use SUM Function
-
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
41 matches
Mail list logo