Hi All,Can you please help me to get text value in pivot table data field.Thanks,Nilkanth Raval9004280428- Original Message -
From: Nilkanth Raval
To: "excel-macros@googlegroups.com"
Date: Thu Nov 26 06:05:43 GMT+05:30 2015
Subject: Get text value in pivot data field.
Hi All,Does
Still trying to match up you narrative description with your example.
"list of reject descriptions"Is that the column titled "Station Name"?
then: the SQL query returns the rejects in "descending order".that's descending
order by COUNT, not description?
If so, I get that for Station 18, count 172
ok as simple as I can make it.
On the first sheet I have a list of reject descriptions, across which is
populated the number of rejects per shift.(see above)
The second sheet is is from a sql query that returns the rejects in
descending order. (so the second sheet is not in the same order as the
Thanks Paul.
I will try to run this macro tomorrow in Office and after after that i will
share the respoNSE. Thanks
On Dec 1, 2015 11:20 PM, "Paul Schreiner" wrote:
> This macro seemed to work with files sorted ALPHABETICALLY
> (not numerically)
>
> which means that a file named 123456789_a
This macro seemed to work with files sorted ALPHABETICALLY(not numerically)
which means that a file named 123456789_a.pdfwould come BEFORE a file named
234_a.pdf
even though 234 is numerically less than 1234567891 is less than 2
"alphabetically", and therefore 123456789 would come first.
see if y
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
*Title :BizTalk Architect*
*Location: Irving, TX *
*Duration: 6-12 months*
*Need locals and GC/citizens only – in-person interview must*
Our outstanding client is seeking a BizTalk Architect Consultant
Hi,
Hope you are doing great...
Please let me know your interest along with your updated resume and details.
(It will be of great help if you can refer someone for the same in case you
are not currently available)
[Please send resumes to pavit...@taditsolutions.com]
*Role: .Net develop
Let me test it. Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
I am taking classes of VBA & macros. So i can modify the macro.
I have a one more question, will the macro short files in order and move
them in folders.
If it will work then please write & share.☺☺
On Dec 1, 2015 9:52 PM, "Paul Schreiner" wrote:
> Absolutely no problem.
>
> In fact, you don't
Absolutely no problem.
In fact, you don't even have to use the batch file.
Excel macros have a FileSystem object that can be used to search through the
folder.
How much do you know about macros?
If I were write a macro that took the list of files in a folder and created a
folder:Folder_001and mov
Hi Paul,
I am using a batch file to get the names of files in folder and then I want
to move a batch of files( It may be a count of files) in a new folder.
I have a condition suppose i have 2000 files in a folder and i have to make
batch of 200 or more files. Right now am selecting files manually
I think you're using terms that do not have the same meaning to ME as they do
to you.
I think you're saying:- You have a folder with some files.- In excel, you HAVE
a list of the files in the folder.
You said you want to "extract these files".to ME, that means you wish to open
the files and coll
Absolutely.I do it daily.actually, nightly. It's done by the time I arrive at
work each weekday.
I use VBA macros to generate a summary of over 150,000 rows and 72 columns of
data.
Efficient design of the macro could reduce your "long time" to something much
shorter.Depending on how you summariz
I'm not sure what you're "looking up"??
Your sample data is:
| Station Name | Mon Day | Mon Night | Tue Day | Tue Night | Wed Day | Wed
Night | Thur Day | Thur Night | Friday Day | Friday Night |
| Station 18 (Vaccum) | 276 | 363 | 231 | 146 | 54 | 175 | 172 | 180 | 208 |
238 |
| Station 12 Heigh
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
*Sr. Level UX Designer / Information Architect. *
*Duration – 3 months – possibility of extension*
*Location – Irving, TX*
UX – Information Architect: Sr-level UX Designer / Information architect.
Must
Hi All
problem description. I have an excel sheet that i update manually. I want
to update automatically.
Here is what I have, A list of faults in a column, across each row is the
day and night shift, Monday to Friday.
see below.
Sheet 1
Station Name Mon Day Mon Night Tue Day Tue Night Wed Da
Dear All
It is possible to make summary of data through macro, I have done it through
formula but it is taking long time due to large data, so I need macro.
Regards,
Siraj
This email and any attachments to it may be confidential and are intended
solely for the
This email and any attachments to it may be confidential and are intended
solely for the use of the recipient(s). If you are not the intended recipient
of this email, you must neither take any action based upon its content, nor
copy or show it to anyone. Please
Thank you Mandeep.
I was not familiar with Regular Expressions - I appreciate your introducing
me.
On Monday, November 23, 2015 at 5:13:04 AM UTC-6, Mandeep Baluja wrote:
>
> Check this way !! Note Hyphen _ has been used here for searching.
>
>
>1. On the Project menu, click References.
>
Hi Experts,
I have a excel sheet of files names, which are in a folder & I want to
extract these files (which i have in excel sheet) in a new folder with the
help of a macro.
Please help me out.
--
With Regard !!!
Devendra Rahi
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w
20 matches
Mail list logo
