Hi Muneer
In essence this is almoost impossible.
The width of each letter varies so if you type
and
they each contain the same number of characters but the width of each is
very different.
The only way I know of to work out how much of a particular string will fit
in a given ce
Dear Expert
Please help me on Excel function
Questions
1
I've 2 sheet (BOM and Forecast)
2
Forecast give me customer demand and BOM give me the requirement of component
part
3
Fomular requirement is need to sum up component part per day based on customer
(Finish good)
Can do it without
David,
I've spent time in the past in an exercise much as you've described.
I actually did work out something one time, but it did not work with
Proportional Width fonts.
Which means that HOOD and ILLS may contain the same number of characters,
but some letters are wider than others.
MM has an
Dear Paul,
Your solution is good to some extent, but the thing is I don't want to
use the merge or any option that is default in excel.
I need a vba coding to control the text flow unto the page break only,
when one line is finish it should go to the another line.
Ur example for merge
Dear Friends,
I need to work on huge data in excel 2007. Whenever I use any formula it
generally slows down & keeps on calculating on every move.
Please provide me tips/suggestion for improving performance.
Best Regards,
Amit
Disclaimer: This message and its a
Well, then it looks like we're back to David's comment.
It's almost impossible to do.
There are WAY too many variables.
Do we assume that if the cell above contains information then it is part of the
same paragraph?
We COULD assume a "base" character width based on font size.
Then only allow X n
check these links for some tips
http://chandoo.org/wp/2012/03/27/75-excel-speeding-up-tips/
http://www.brighthub.com/office/home/articles/1830.aspx
On Wed, Aug 15, 2012 at 7:18 PM, Amit Desai (MERU)
wrote:
> Dear Friends,
>
> ** **
>
> I need to work on huge data in excel 2007. Whenever I
use this formula in conditional format
=AND(TEXT($A2,"ddd")="Fri")
On Wed, Aug 15, 2012 at 12:09 PM, vijayajith VA wrote:
> use ths below code...
>
> .
>
> Sub highlight_friday()
> Dim rng As Range
> Dim cell As Range
> Dim sh As Worksheet
> Set rng = Sheet1.Range("A2:A" & Sheet1.Range("A" &
>
You did not elaborate on your formulas but I’ll bet you are using entire
columns instead of limiting to needed area.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Amit Desai (MERU)
Sent: Wednesday, August 15, 2012 8:48 AM
To: excel-macros@googlegroups.com
No I am using formula on selected columns only...
I am using formula like, vlookup, sumproduct (for counting sum of unique
values)
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: 15 August 2012 19:52
To: excel-macr
Examples and why
I want cell__in sheet ___ to be ___
because__ from where
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: attapan_chainarongb...@ck-mail.com
Sent: Wednesday, August 15, 2012 6:15 AM
To: excel-macros@goog
Sorry for unclearify questions and example
I posted new file, please see my requirement and example
On Wednesday, August 15, 2012 6:15:16 PM UTC+7, Attapan wrote:
>
>*Dear Expert*
>
> Please help me on Excel function
>
> *Questions*
>
> 1
>
> I've 2 sheet (BOM and Forecast)
>
I’m sorry, I meant to say entire ROWS.
Post your formula examples.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Amit Desai (MERU)
Sent: Wednesday, August 15, 2012 9:46 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Tips for working on h
I would suggest u keep ur option of calculating on MANUAL mode and when u need
to calculate press F9. And go for coffee ;)
Reduce pivots active as much as possible.
Cheers
Rahul.
Sent from BlackBerry® on Airtel
-Original Message-
From: "dguillett1"
Sender: excel-macros@googlegroups.com
- Try to select all the blank columns to the right and delete
- Select all the blank line below and delete
If you delete the space that they try to wait long to wait, when you're done,
save and close the file. Now open the file out to see the results.
2012/8/15
> I would suggest u keep ur option
Dear Ayush,
Please take action on it.
This gentleman is continue posting job ad
On Wed, Aug 15, 2012 at 10:02 PM, Karan Bhatia wrote:
> Please respond to ka...@hmgamerica.com
>
> *Position: *Unix Administrator*
> Location: *Houston, TX*
> Duration: *6 months extendable contract*
> Jo
How much is "huge data"?
I have a workbook that originally was in Excel 97.
Luckily, by the time I exceeded 64,000 rows, Excel 2007 was available.
I'm now in Excel 2010, and have nearly 119,000 rows. x 72 columns.
I PERSONALLY consider this a "large" file rather than "huge".
(I've seen "huge", an
Hi All,
>
>
> please find attached file and solve my problem urgent.
>
>
> Thanks
>
> Pravesh
>
--
*Thanks & Regards*
*Pravesh Kumar*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use conci
Ever read Forum Rules #1?
attachments may be removed.
So describing the problem verbally is encouraged.
I guess in a way, this is responding to your FIRST problem.
Your first step would be to: "Use concise, accurate thread titles"
Paul
-
“Do all the good y
No file and why is YOUR request more URGENT than that of anyone else?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: PRAVESH KUMAR
Sent: Wednesday, August 15, 2012 12:29 PM
To: excel-macros
Subject: $$Excel-Macros$$ plz solve pro
Please give logic(what where why) of what you want with EXAMPLES.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Attapan
Sent: Wednesday, August 15, 2012 10:15 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Sum up of Bill of material and
Hi Paul
I try to avoid putting chunks of text in merged cells (if possible) because
the cell does not adjust its height so you can easily end up with text
which is hidden and may be important. I know you can kludge this by having
a copy of the cell off to the right made the same width as the merg
Now I understand why the first requirement was first. This is a fair
implementation of that requirement IMHO.
Some weird things seem to happen if you edit a line after it has been
wrapped. That may not be an issue for MM.
I still think Excel is not cut out to be a word processor and for dealing
23 matches
Mail list logo
