Hi Paul,
Its working. ☺☺ But can we add a option to select folder. (Like a file
which I am using to merge files)
Please check Add-Ins option in attached file.
On Tue, Dec 1, 2015 at 11:23 PM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:
> Thanks Paul.
>
> I will try to run this macro t
Or we can put the file in a folder & run the macro & it will detect the
folder location where the file is & it will split the files in folder.
OR we can use a user form to assign the folder path
Whichone one is easier, please assist.
On Wed, Dec 2, 2015 at 1:59 PM, Devendra Sahay <
devendrasahan
ok here is the full table of sheet 1 to show you.
Reject counter for Zone 0, Station 18 (Vaccum) 276 363 231 146 54 175 172
180 208 238 Station 12 Height Measure out of range 69 116 85 107 48 60 52
59 96 74 Station 12 Inspection part fails 59 112 47 66 21 61 28 24 27
25 Station
17 (InsertPad) 8
Dear Friends
pls help to merge one by one rows in one cell
file attached
--
*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook pag
Share a example sheet. Q & A
*Pankaj Sharma *
*MIS Analyst*
*Greater Kailash-1, New Delhi*
*Email *
*p ankaj123...@gmail.com *
*Skype** pankaj.sharma_pj*
On Wed, Dec 2, 2015 at 6:10 AM, Nilkanth Raval
wrote:
> Hi All,
>
> Can you plea
Your first option is pretty simple.
replace your line:FolderName = "C:\test\"
with:FolderName = ThisWorkbook.Path & "\"
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
Thanks Paul
On Wed, Dec 2, 2015 at 6:57 PM, Paul Schreiner
wrote:
> Your first option is pretty simple.
>
> replace your line:
> FolderName = "C:\test\"
>
> with:
> FolderName = ThisWorkbook.Path & "\"
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good
Forgot to answer.
"list of reject descriptions"
Is that the column titled "Station Name"? Yes
then: the SQL query returns the rejects in "descending order".
that's descending order by COUNT, not description? Yes
Regards alan
On Wed, Dec 2, 2015 at 9:12 AM, Alan Walsh wrote:
> ok here is the
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
*Title : .net Developer *
*3- 4 month contract*
*located in Northwest Houston---LOCALS ONLY F@F must*
*rate $40/hr on c2c only*
>From Manager:
“We’re converting our Core banking system from Symitar Ep
so now, you have an array of data.
and a query that returns a station name and number.
so what are you looking up?
are you trying to find the row with the matching station name,locate the
matching value and return the day/shift??
Paul-
“Do all the good you
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
*Title: Senior Business Systems Analyst (Pega)*
*Location: Norwalk, CT*
*Position Overview:*
The Senior Pega Business Systems Analyst is a specialist practitioner
accountable for the execution of business
Correct, but the row with the matching station name has extra text in it.
Regards Alan
On 2 Dec 2015 14:42, "Paul Schreiner" wrote:
> so now, you have an array of data.
>
> and a query that returns a station name and number.
>
> so what are you looking up?
>
> are you trying to find the row with
Are you saying that the SQL query returns:
Reject counter for Zone 0, Station 12 (CheckPresence)
but the Station Name is only: Station 12 (CheckPresence)
??
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
*Title :Oracle DBA *
*Start Date January 2016*
*Assignment Length 12 month + contract *
*Need Certified and local candidates *
*Job Details*
Database Administration for Oracle 10g, 11g or 12c.
-
>
> Check this attachment !! regards, Mandeep
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor t
Correct
On 2 Dec 2015 17:02, "Paul Schreiner" wrote:
> Are you saying that the SQL query returns:
>
> Reject counter for Zone 0, Station 12 (CheckPresence)
>
> but the Station Name is only: Station 12 (CheckPresence)
>
> ??
>
>
> *Paul*
> -
>
>
>
>
>
>
>
>
Hello Everyone,
Please find the above attached sheet in which i need your help on the below
said points.
1) When i click on date the Date-picker should be popup and when i select
the date it should enter only in cell *E6.*
2) All column of Saturday and Sunday needs to be highlighted in color
alt
Dear Experts:
Do you know if Excel VBA has the capability to automate the transfer of
data from a spreadsheet to a website (a web based database)?
I have heard that Excel's API may be able to do it. Is that so?
Thank you!!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
*Title : Sr. Java Developer *
*Location :Downtown *
*Duration :12 months+*
I have a Consultant leaving a project this Friday the client needs someone
to backfill his position.
*Must have skills: JSP a
Hi All,
Expecting your valuable reply on this _
Regards,
V!kas
On Dec 3, 2015 12:32 AM, "vikas khen" wrote:
> Hello Everyone,
>
> Please find the above attached sheet in which i need your help on the
> below said points.
>
> 1) When i click on date the Date-picker should be popup and when i sel
>
> Here is attached two files , install the addin windatepicker.xlam first
>> and then run that Att file, Double click on date which u want to select.
>
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join offici
>
> Please follow the group rules, Post question related to Excel , Try this.
>
> http://www.labnol.org/internet/transfer-gmail/28088/
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
22 matches
Mail list logo
