One possibility: combine all the individual tabs into a single tab to
create a data table of >all< the information, then create a pivot table to
quickly summarize data.
On Wednesday, June 17, 2015 at 1:50:33 AM UTC-4, Kumar Bhanushali wrote:
>
> *Dear Sir,*
>
> I had attached a file, in this f
Here's one way to do it in a formula: use this website ( ascii-code.com )
to look up the ASCII equivalent of each character. It turns out to be this:
/47
\92
*42
?63
"34
<60
>62
|124
Then use a FIND formula to look for the ASCII equivalent. I tried the
SEARCH form
Our department has started using XL 2010, and we must respond to a client's
proposal using XL 2007. Based on this article by Microsoft,
http://technet.microsoft.com/en-us/library/cc179167.aspx, we can create a
file in 2010, avoid the new statistical functions, sparklines, slicers,
conditional
That's what I'm looking for, thanks Kris and Don!
--
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 b
Continuation:
What I'm hoping to find is a specific way to learn which worksheets
have been grouped. I'm happy to build my own array: is there a boolean
that indicates whether a given sheet is selected? Maybe something
like...
dim TabName as worksheet
For each TabName in Sheets
if TabName.Select
In Excel, is there a VBA function or syntax that captures the contents
of the array that holds the sheet names of grouped sheets?
Thanks,
Dave O
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
One way may be to manually copy the data from the three columns, one
at a time, into a single column. In the column next to the Product #
column, write a formula to isolate the number:
=VALUE(MID(A2,FIND(" ",A2,1)+1,LEN(A2)-9))
where column A contains the list and 9 is the length of the word
"Produ
Troubleshooting a colleague's file: on a print-out he wants to show
"Page X of Y" in the footer. The tab contains 5 pages of formatted
material. Print preview shows "Page 7 of 5" and it appears that way on
paper as well. There are no hidden rows or columns; no conflicting
PrintArea named ranges; th
I have code that writes a set of names to an array; when that set of
names is complete a userform opens and the array populates a listbox.
The user double clicks on a name to select it, and the userform hides.
This process repeats numerous times.
On the first cycle if the user selects the third na
I didn't see your note, Paul, thanks for your response. I thought the
equivalent of date(2012,2,30) would return an error and not get
counted in the SUMPRODUCT. Instead, as you say it gets counted as the
next day and throws the count off.
--
FORUM RULES (925+ members already BANNED for violation)
Thanks, Don and Sam- I appreciate your responses and I'll study them
to understand them fully.
--
FORUM RULES (925+ 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 Advi
I've written this formula to count Fridays in a month, where cell b1
contains a date such as 11/1/2011:
=SUMPRODUCT(--(WEEKDAY(DATE(YEAR(B1),MONTH(B1),ROW($A$1:$A$31)))=6))
This formula works for any month except February. Can anyone suggest a
reason why this happens?
--
FORUM RULES (925+ member
I just spent some hours figuring this out, so I'll post this here in
case anyone searches on this in the future.
In Page Setup the user can adjust print scaling to "Adjust to" and
enter a zoom percentage, or the user can set scaling to "Fit to" and
enter a number of pages wide and number of pages
I have values in an array that I want to appear in a userform listbox.
How do I assign array values to a listbox? I googled and found this
code, but it returns an error:
ListBox1.List() = ArrayName()
Then, once the listbox is populated, I want the user to doubleclick a
listbox entry and store it t
I have a scenario in which a user needs to perform a "fuzzy" match
between a name and a variation of that name in a list about 4500 names
long. For example, the user may be looking for "Smith, John" but needs
to match to "Smith,John Jr" in the longer list.
My plan is to write the long list to an a
Did a search but got no hits.
I created a file in xl 2003 that included a button with some code
attached. I imported that file into xl 2010 and the button flashes on
and off quickly with no pattern. The code attached to the button still
runs; when I right click the button to assign properties it s
When I ran your code I got an error on this line:
Range(L2) = LHour
... and had to add parens around the L2, comme ca:
Range("L2") = LHour
If that still doesn't run, you might try this construct:
If IsError(Hour(Range(CellAlpha))) Then
LHour = 0
Range("L2") = LHour
Else
LHour = Hour(Range(Ce
Dave,
I use a version of this code to examine the "white space" in a file to
see if it is empty- if empty, I delete that range, and reduce file
size. So if the code locates a cell that is populated either with a
number or formula, it moves the cell pointer to that cell so I can
determine if that ce
I wrote some code to search a range of cells to locate non-blank cells
and cells with dependents. (A clever contributor on these forums, Jim
Cone, was pivotal- thank you, Jim!)
I had this code running correctly at one point, but lost the file that
contained the working code. I've tried to recreate
Does code exist that returns a True when a cell has one or more
dependents?
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
20 matches
Mail list logo
