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 parse
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
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 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 swapnilp1...@gmail.com wrote:
Hi,
Use following
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
On Jun 24, 5:11 pm, MOKSH.. krishna.ange...@gmail.com
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 mail_to_s...@yahoo.com
Dear List members
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
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
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
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
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
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 dilipan...@gmail.com 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)
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,
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
pls attach the workbook with an eg will be easy 2 get it
On Wed, Jun 24, 2009 at 6:55 AM, Bakul Patel bakulpatel...@yahoo.comwrote:
give an example. that would be gr8.
--- On *Tue, 6/23/09, Pavan Kumar VVN nagapavan@gmail.com* wrote:
From: Pavan Kumar VVN nagapavan@gmail.com
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
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
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 PANDEY
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:
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 (,).
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 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.
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
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 Ankur,
http://groups.google.com/group/excel-macros/files
regards
Hari kumar
On Wed, Jun 24, 2009 at 10:09 PM, ankur ankurpande...@gmail.com 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
Thanks a ton Dave..It's working fine..
Regards,
Dharmendra
On Jun 25, 8:21 pm, Dave Bonallack davebonall...@hotmail.com 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
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, Dave
see the atteched file... I´ve created another column and another names
2009/6/24 Anderson, Jim jim.ander...@bankofamerica.com
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,
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
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 ankitmehr...@gmail.com wrote:
Hello Group,
First of all, Thanks
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
31 matches
Mail list logo
