HI,
This is more like a word forum issue?
Anyways, here is the solution.
You need to do it in word than in excel.
After you start mail merge and before you update all the fields (merged
fields), you need to get the individual field codes in the document. Once
you get the field codes
Hello I have two columns from a pivot table I put together. Column D
contains ID-numbers & E contains values. I need a macro that selects
values from Column E that are greater than 5,000 and copies that value
into a column along with the corresponding ID number from column D.
Two new columns with
You need to change your code. It would be better you send your code, so that
a minor modification will be sufficient in stead of writing the whole code
for you.
Akhilesh Kumar Karna
On Thu, Jun 25, 2009 at 4:25 AM, Ankit Mehra wrote:
> Hello Group,
>
> First of all, Thanks a lot for showing yo
Dear Hanumant,
It is very difficult to estimate the number of pages that are there for
search in google. This is because, the google crawlers keep on searching the
WWW servers for newer pages that have been added, 24/7.. so they keep
increasing their search database.. almost every day.
However for
see the atteched file... I´ve created another column and another names
2009/6/24 Anderson, Jim
> Thanks, Paul. But unless there’s something I’m not understanding, that
> doesn’t work, and it doesn’t work in the sense than when I copy the formula
> down column C, the indexes don’t adjust as
You're welcome!
> Date: Thu, 25 Jun 2009 10:32:44 -0700
> Subject: $$Excel-Macros$$ Re: how to extract a "comment" to a cell
> From: dharmendrakumar...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Thanks a ton Dave..It's working fine..
>
> Regards,
> Dharmendra
>
> On Jun 25, 8:21 pm,
Thanks a ton Dave..It's working fine..
Regards,
Dharmendra
On Jun 25, 8:21 pm, Dave Bonallack wrote:
> Hi Dharmendra,
> Have a look at the attachment, click the button and see if it does what you
> want.
> Have a look at the code. It's really just 1 line.
> I've added the second line just to u
Hi Ankur,
http://groups.google.com/group/excel-macros/files
regards
Hari kumar
On Wed, Jun 24, 2009 at 10:09 PM, ankur wrote:
>
> hello excel gurus
> thanks for helps to my earlier queries
>
> i can work properly with excel sheets,but no familiar with macros. i
> can record macros,but dont un
can we know how many pages we have got for our search in google.e.g
i searched "Dictionary" in google and i found 10 pages and each page
contains lets say 10 links,so can i know how many pages i have got for my
search?
please help me its very imp for me.
--~--~-~--~~~
Hi Friend's
The following formula are useful when you have one cell containing
text which needs
to be split up.
One of the most common examples of this is when a persons Forename and
Surname
are entered in full into a cell.
The formula use various text functions to accomplish the task.
Each of
Hi Nourredine,
Do as Below :
1. In the word merged document, right click the merged field for which
you want to change the format.
2. Click "Toggle Field Code"
3. You will see something like { MERGEFIELD Dollar_Value} where
"Dollar_Value" is the merge Field.
4. Ap
Thanks you Dilip, I got it.
- Original Message -
From: Dilip Pandey
To: excel-macros@googlegroups.com
Sent: Thursday, June 25, 2009 7:09 PM
Subject: $$Excel-Macros$$ Re: Date Problem
Hi Sandeep,
Query solved and attached with this email. Thanks.
Note:- try to get the
Hi Dilip,
It doesn t wotk it comes back when merging
6027642.719997
2009/6/25
>
> Hi Nourredine,
>
> Try changing the number format in MS Excel itself. To achieve this, Go to
> Format - > Cells -> On the Number tab, choose "number" with two decimal
> places and check "Use 1000 Seperator (
Hi Dharmendra,
Have a look at the attachment, click the button and see if it does what you
want.
Have a look at the code. It's really just 1 line.
I've added the second line just to undo the auto Word Wrap feature.
Regards - Dave.
> Date: Wed, 24 Jun 2009 23:43:02 +0530
> Subject: $$Excel-Macros
Hi Nourredine,
Try changing the number format in MS Excel itself. To achieve this, Go to
Format - > Cells -> On the Number tab, choose "number" with two decimal
places and check "Use 1000 Seperator (,)".
After changing the number format, continue with your mail merge.
Thanks,
--
DILIP KUMAR PA
Hi All,
Hope you are all fine.
I have an issue with the Word Function Mail Merge.
I have an xls with columns Adress Cust Name Invoice Amount Date.
When I m doing the Mail Merge the Number Format is as below ;
6027642.719997
I want to change it to 6,027,642.72
Can you please help with th
Hi Ankit,
Here you go..!!
Earlier, I have created the scenario based on your data, as you have the
data starting with numbers only.
Koi ni...!! please find the revised solution attached herewith. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
pls attach the workbook with an eg will be easy 2 get it
On Wed, Jun 24, 2009 at 6:55 AM, Bakul Patel wrote:
> give an example. that would be gr8.
>
>
>
>
> --- On *Tue, 6/23/09, Pavan Kumar VVN * wrote:
>
>
> From: Pavan Kumar VVN
> Subject: $$Excel-Macros$$ Excel Tip of Week # 26
> To: excel-
Dear All,
As i have conditional formatting in my excel workbook where all cell
consisting formullae is
red beackground By using HasFormula.
As I want without deleting HasFormula from our Name Manager (Excel
2007) i want to take print
As normal i.e Background color should not appear in our print
Hi Dilip,
First thing first, Thanks a lot for your response.
I used the file and the formula as suggested by you. However, i am facing
little challenges with the same.
In the example that you have taken (where all the data are starting with a
number), if my data is starting with an alphabet, the
Frnd,
You can use this formula =round(A1,-2), then it will convert to nearest 100.
On Wed, Jun 24, 2009 at 10:53 AM, Dilip Pandey wrote:
> Hi ddp,
>
> It is not as big as you have presented. Try the below formula and you will
> have the required result.
>
> =+MROUND(A3,100)
> 'where A3 is the
hello excel gurus
thanks for helps to my earlier queries
i can work properly with excel sheets,but no familiar with macros. i
can record macros,but dont understand the coding concept
i have no programming background, so its very hard me to understand
any macro in excel
In today's era knowing e
Thanks Aindril,
There is still no files, I'm using Office XP. I had solve the problem by using
substitute() function.
(I don't have your file)
Is you did it by find and replace?
Is it possible in Office 2003?
- Original Message -
From: Aindril De
To: excel-macros@googlegroups.
Hi,
I am new to Macros and VBA and trying to find my way around them.
I have a macro set-up so the lowest bid is automatically highlighed
and the company with the lowest bid is displayed as per below:
But when I paste the list on the same spreadsheet the macro does not
separate and when I change i
But that only works for cells within the same row. When I try it, for
example, to create a formula in C2 referencing for the 2nd row in Even
and the 3rd row in Odd it works correctly for C2, but when I copy C2
to subsequent rows in C, the formula continues to point to the
original vales in Even an
Hello Group,
First of all, Thanks a lot for showing your promptness and for your response
for my previous query. I am sure that all of you would help me in resolving
the below mentioned query:
I am working on a sheet (Time Tracker) that has start time and end time for
a transaction processed. I h
Dear Rajesh
Thanks for taking time to send a complete VBA script... This shows how
helpful this group is. Truly amazing folks and moderators.
However as I asked the last time and forgot again :-(
could you please add a line or two on where to cut and paste this code
for it to work
TIA & reg
Thanks, Paul. But unless there’s something I’m not understanding, that
doesn’t work, and it doesn’t work in the sense than when I copy the
formula down column C, the indexes don’t adjust as they do when I’m
not using range names.
Jim
On Jun 24, 1:12 pm, Paul Schreiner wrote:
> I'm sure that you
On Jun 24, 5:11 pm, "MOKSH.."
wrote:
> it will help u
>
> =UPPER(LEFT(C3,1))&LOWER(RIGHT(C3,LEN(C3)-1))
>
> with regards
> Moksh
>
Bingo Krishna
Worked like a charm...thanks a ton..
regards
subu
> 2009/6/24 Subu
>
>
>
>
>
> > Dear List members and XL Gurus
>
> > I have an XL
Dear Jayavelu
Thanks for the reply. That you have taken time and effort to reply my
query speaks volumes of your commitment.
However as a constructive feedback and to make you provide even better
answers, I say the following :
- As you would notice from my mail I wish to change the first letter
Yes true..learning comes out from within..go..experiment..explore and
if stuck up..you are at the right place..let the group know..we will
be happy to help.
Mike, for your current problem (amazon one), let us know your MS
Office version (2003/07).
Dharmendra
On 6/24/09, Dilip Pandey wrote:
> Hi
Thanks a Ton to all the enthusiasts and Gurus who responded
Like the last time I am overwhelmed by the response.
If I may be permitted, I wish to add some comments BELOW the replies I
have seen so far
On Jun 24, 3:45 pm, Swapnil Palande wrote:
> Hi,
> Use following formula:
> =UPPER(LEFT(B15
Hi members,
Greetings!
Please help: how to extract a "comment" to a cell (inside the cell,
not as comment); say "comment" of A1 to B1 (inside the cell, not as
comment).
Please go through the attached file for clarification.
Thanks in advance.
Regards,
Dharmendra
--~--~-~--~~--
Thanks, Paul. But unless there's something I'm not understanding, that
doesn't work, and it doesn't work in the sense than when I copy the
formula down column C, the indexes don't adjust as they do when I'm not
using range names. Example s/s attached.
Jim
F
It is called "text to columns" and it is located under Data on the
toolbar. no macro needed, just delimit by a character or define the
fixed with.
On May 8, 3:12 am, Radhe Sham L wrote:
> Hi Group ,
>
> Members working on Oracle E business Suite 11i would be aware that the
> report generated
Hi Levi,
We need to know how this data range looks.
Any chance of attaching a sample workbook?
Regards - Dave.
> Date: Wed, 24 Jun 2009 07:12:03 -0700
> Subject: $$Excel-Macros$$ Parse through a data range
> From: rlsmalls...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> I am wanting to p
36 matches
Mail list logo
