Dear Basole,
I am using 64 Bit version.
It gives error.
How can I fix it please?
Regards
Rashid
On Saturday, March 3, 2018 at 9:20:40 PM UTC+4, Basole wrote:
>
> Hi Franz, put the PDFs files in the same folder as the workbook.
>
> regards.
>
> Basole.
>
>
>
> Em terça-feira, 3 de setembro de 201
Dear All
I have two workbooks which I use for Data entry and for updating the Master
Data Sheet
Both the *workbooks are open* at the time of Data Entry.
*Data Entry is done on the Active Sheet of File1*
eg:
File1.xlsx – *From file*
File2.xlsx (Cells transferred to Sheetname ‘DATA’) – *To File*
Hello All,
I am using Office 2010 and have found this code which works perfect
But I need the following amendments to the code
1) The code should *read all the files in the Folder* - now it runs on a
single word document
2) It should paste the *All Word table Data under the last available Row on
Please add me
8291577844
Rashid
On Monday, September 5, 2016 at 10:00:12 AM UTC+4, Prabhakar Thakur wrote:
>
> please add me 9953736776
>
> Thanks,
> Prabhakar Thakur
> New Delhi
> +919953736776
>
> On Fri, Sep 2, 2016 at 5:49 PM, Prashant Pednekar > wrote:
>
>> please add me 8308800600
>>
>> On
I am using Excel 2010
I have a problem as shown in the attached sample data
In the directory C:\Product\Pictures I have many files with the names
shown in Column A under the Code group eg: 1.jpg, 2.jpg ….and so on
The size of inserted picture should be of the same height and width of the
cell in
-
>
>
>
>
>
>
>
> *“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*
> --
ually let me know if you need help...
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Sun, Nov 9, 2014 at 11:33 PM, prkhan56
> > wrote:
>
>> Hi Vaibhav,
>> Please find the attached file
>> Your macr
Hi Pramod
The data can be in many columns
See sheet 'tan'
On Sunday, November 9, 2014 6:46:10 PM UTC+4, pramodb35 wrote:
>
> Can u send us with a big dummy data.
>
> Then we can change on this.
>
> Pramod
> On 9 Nov 2014 19:11, "prkhan56" > wrote:
&g
this for you. God is here working through me for you.*
>
> On Sun, Nov 9, 2014 at 1:48 PM, prkhan56 >
> wrote:
>
>> Hello All,
>> I am using Excel 2010
>> I need a macro to transpose several Rows into respective Columns
>>
>> Please see attached samp
Thanks
Works great
A small problem
The date comes as serial no. in transposed data
Can you fix this please
Regards
On Sunday, November 9, 2014 4:18:10 PM UTC+4, pramodb35 wrote:
>
> Hi Prkhan,
>
>
> PFA...
>
> On Sun, Nov 9, 2014
Hello All,
I am using Excel 2010
I need a macro to transpose several Rows into respective Columns
Please see attached sample file for 'Before' and 'After'
TIA
Rashid
--
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
Application.CutCopyMode = False
End If
End If
End Sub
On Wednesday, September 24, 2014 1:49:11 PM UTC+4, pramodb35 wrote:
>
> Hi Dear.
>
> You can self change of range that which range u want and remove the come
> workbook.save /close. And create one new modul an
again if we click on the
colored cell.
Also File 2 will be open. Your code saves and close the file
File 1 and File 2 both will be opened by me when I am running Macro 1 and
Macro 2
On Wednesday, September 24, 2014 8:01:22 AM UTC+4, pramodb35 wrote:
>
> Hi prkhan56 ,
>
> Please f
Hello All,
Can someone help me with the Second Macro?
Thanks
On Monday, September 22, 2014 7:34:17 PM UTC+4, prkhan56 wrote:
> Hi Pramod,
> Thanks for your prompt reply.
> Works great!
>
> The second macro should run when the Cell Pointer is in Column T on a
> Highlighted C
which would be on the shared folder Path S:\..\...\
Hope it is clear now.
Thanks once again for your time.
Rashid
On Monday, September 22, 2014 5:23:52 PM UTC+4, pramodb35 wrote:
>
> Hi Dear,
>
>
> Please find the Attached file ...
>
>
> Regards
> P
>
> On Mon,
Dear All,
I am using Excel 2010 and have the problem as shown in the attached file.
Input Sheet shows the Data I have at present
Output Sheet is the desired result.
I need a macro which should create an ‘Output’ sheet by doing the following
on the Input Sheet
1) 1) Insert a Blank Column
& c.Value & FileExtStr, _
FileFormat:=FileFormatNum
Any solution so I can test it further please?
Thanks once again.
Rashid Khan
On Saturday, May 3, 2014 10:13:53 AM UTC+4, Vabz wrote:
>
> Hi
>
> PFA
>
> HTC//Cheers
>
>
&
when prompted for selecting range you need to select range from I4 to
> down..
>
> Cheers!!
>
>
>
> On Thu, May 1, 2014 at 3:18 PM, Vaibhav Joshi >wrote:
>
>> Hi
>>
>> Pfa. Click to run Macro. Put "\" at the end of folder name.
>
Hello Paul,
I don't how to write a macro...and I request someone to write it for me
please.
Thanks
Rashid
On Wednesday, April 30, 2014 5:21:27 PM UTC+4, Paul Schreiner wrote:
>
> Do you know how to write macros and are asking for help?
> or are you asking for someone to write the macro?
>
> *
Dear Vicky,
Thanks for your time and help.
As mentioned by you, at present the data format is required from these 4
columns
Can it give me an option to say which Columns from all the sheets should be
copy/pasted on the Result sheet.
Regards
On Monday, April 14, 2014 10:53:46 PM UTC+4, Vicky wrot
> Regards,
>
>
>
> On Thu, Apr 3, 2014 at 6:40 PM, prkhan56 >wrote:
>
>> Hello Vicky,
>> Your solution works as per the current set of Data. (Col G & H for input)
>> & (Col L & M for output)
>> I was looking for a solution which should wor
Thanks Ravinder.
But your solution does not meet my requirements.
On Thursday, April 3, 2014 9:32:22 AM UTC+4, ravinder negi wrote:
>
> pfa
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Bipin Singh
> *Sent:* Thursday, April 03, 2014 1:33 AM
>
Hello Vicky,
Your solution works as per the current set of Data. (Col G & H for input) &
(Col L & M for output)
I was looking for a solution which should work for any two adjacent columns.
Is that possible?
I will run the macro from say Values in Col A then it should work for Cols
A and B...if Co
Thanks a lot
works like a charm
You are a star
On Sunday, August 25, 2013 4:03:48 PM UTC+4, De Premor wrote:
> PFA
>
> Pada 25/08/2013 18:22, prkhan56 menulis:
>
> Hello De Premor,
> It shows only blanks. No data at all.
> Please check
> Thanks for your time o
Kode, Data, Colx, 0) &
> IIf(RemoveDelimiter, " ", Delim)
> End If
> Next
> LookForCode = Trim(Tmp)
> End Function
>
>
>
>
> Pada 25/08/2013 14:43, prkhan56 menulis:
>
> Dear De Premor,
> One small request please
> I
Dear De Premor,
One small request please
Is it possible to amend your code to retain the ] in the output.
Thanks for your time.
Regards
Rashid
On Wednesday, August 21, 2013 11:14:57 PM UTC+4, prkhan56 wrote:
> Thanks De Premor,
> Your code works on any sheet.
> Regards
> Rashid
tached (addin File) where you want to save.
> second step :-go in file -->options-->addins -->click on go
> button--->browse and then select attached file where have u have
> saved.pls revert if not working.
>
> Thanks & Regards
> Ravinder Negi
>
>
>
t;]")
> Dim Kode, Tmp As String
> For Each Kode In Split(Str, Delim)
> If Kode <> "" Then Tmp = Tmp & " " &
> WorksheetFunction.VLookup(Kode, Data, Colx, 0)
> Next
> LookForCode = Trim(Tmp)
> End Function
>
>
Thanks Ravinder,
Couple of things if you would kindly rectify it please.
1) For some reason, the UDF does not work for codes which is not on the
active sheet. I had posted my problem for sake of explanation on the same
sheet but in reality it is on other sheet.
2) If you could please convert
Hello,
Thanks for the reply.
Output required is group concatenate. As you can see I have shown that in
the sample file.
Codes are used to mark the questions.
Then it will come as an output in the Answers Column.
I need to get the concatenated values from the Text Columns
Hope it is clear
Regards
So basically, if the total number of days between B2 and C2 is 1044, then
> the total days within 2010 + the total within 2011 and the total within
> 2012 should equal 1044.
>
> Is that what you're trying to get to?
>
>
> *Paul*
>
>
Thanks for the response. Both the solution does not give the result I wish
to have...
Let me try to explain it with the Data in S.No. 1 only
I wish to have a formula in D2 which will calculate the elapsed days
between the Start and End Date under that particular year.
For example S.No. under 2010
Thanks Ashish. Works like charm,
As always you all are a great help.
On Thursday, January 31, 2013 8:56:30 PM UTC+4, ashish wrote:
> *Try this code*
>
> Sub SJ()
> Application.DisplayAlerts = False
> Dim i As Long, j As Long
>
> On Error Resume Next
> Sheets("Output").Delete
1, intNameColNo).EntireColumn.Cut*
> *.Cells(1, intDateTimeColNo).EntireRow.Insert*
> *End If*
> *End With*
> *If Not Application.ScreenUpdating Then Application.ScreenUpdating =
> True*
> *
> *
> *End Sub*
>
> Regards,
> Lalit Mohan
>
> O
left side
> there is a sheet named sample goto its properties visible and select visible
>
> Regards,
> Lalit Mohan
> Sent from BlackBerry® on Airtel
> ------
> *From: * prkhan56 >
> *Sender: * excel-...@googlegroups.com
> *Date: *Thu, 3 Jan 2013 02
check the same.
>
> Reagrds,
> Lalit Mohan
>
> On Thursday, 3 January 2013 00:57:11 UTC+5:30, prkhan56 wrote:
>>
>> Hello Lalit,
>> I tried the macro and it works perfectly on the sample data I uploaded in
>> my first post.
>>
>> But very very sorry,
>>
>> Sorry for that i will send you the file by today evening itself
>>
>> Regards,
>> Lalit Mohan
>>
>> On Tuesday, 1 January 2013 13:37:21 UTC+5:30, prkhan56 wrote:
>>>
>>> Hello Lalit
>>> I cannot see the complete code. If I go
Hello Lalit
I cannot see the complete code. If I go and check the original and paste
the code I get lot of unwanted characters in the code
If you cannot send me in a file then can you please send the code to me as
a text file.
thanks for your time and help
Rashid Khan
On Monday, December 31, 2
Hello Experts,
Is this possible or not?
I am reposting my query once again
Regards
Rashid Khan
On Monday, December 24, 2012 10:58:15 AM UTC+4, prkhan56 wrote:
> Hello Lalit
> Thanks for the reply.
> Please see the sample sheet which I have attached with my first post.
>
> T
oyee and how we know who are the employees. Is
> there any list of employee?
>
> Regards,
> Lalit Mohan
>
> On Wednesday, 19 December 2012 16:17:43 UTC+5:30, prkhan56 wrote:
>>
>> Hello All
>>
>> I am using excel 2007
>>
>&g
Hello all experts
Any help on my problem please
Rashid
On Saturday, December 22, 2012 12:15:33 AM UTC+4, prkhan56 wrote:
> Hello Prince
> I posted the reply yesterday but I cannot see it posted. So posting again.
>
> *Where is the out time of the employees.*
> Please see this
you want 100 sheets in the workbook*
Yes. Newly created sheet would be as per the number of employees
Thanks for your time.
Regards
Rashid Khan
On Wednesday, December 19, 2012 2:47:43 PM UTC+4, prkhan56 wrote:
> Hello All
>
> I am using excel 2007
>
>
On Wednesday, December 19, 2012 2:47:43 PM UTC+4, prkhan56 wrote:
>
> Hello All
>
> I am using excel 2007
>
> I have data in the Master Sheet for various Employees
>
> I want to create separate sheet for each employee viz A, B, C and so on
chart-317/**
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *prkhan56
> *Sent:* 20 October 2012 10:03
> *To:* excel-...@g
Reposting - any help on this please?
Regards
On Wednesday, October 17, 2012 10:20:15 PM UTC+4, prkhan56 wrote:
> Hello there,
> Thanks for the reply
> Can you guide me how to setup my data please?
> Regards
> Rashid Khan
> On Tuesday, October 16, 2012 9:31:53 PM UTC+4,
Hello there,
Thanks for the reply
Can you guide me how to setup my data please?
Regards
Rashid Khan
On Tuesday, October 16, 2012 9:31:53 PM UTC+4, Sushil Kumar wrote:
> Hi Rashid,
> Your graph not correct
> and graph looks the image of waterfall chat so you need to setup the cross
> of x-axes and
o specify which version of office u r using
> Sent on my BlackBerry® from Vodafone
> --
> *From: * prkhan56 >
> *Sender: * excel-...@googlegroups.com
> *Date: *Sat, 13 Oct 2012 12:01:09 -0700 (PDT)
> *To: *>
> *ReplyTo: * excel-...@googlegroups.
Dear Ashish,
I am still waiting some guidance from your end
Regards
Rashid khan
On Tuesday, October 9, 2012 11:08:19 PM UTC+4, prkhan56 wrote:
> Hello Ashish,
> Any guidance to solve the problem I am facing?
> Thanks
> Rashid Khan
>
> On Sunday, October 7, 2012 8:59:04 PM UTC
Hello Ashish,
Any guidance to solve the problem I am facing?
Thanks
Rashid Khan
On Sunday, October 7, 2012 8:59:04 PM UTC+4, prkhan56 wrote:
> Hello Ashish,
>
> When I run call_pivot
> It gives Run-time Error '9'
> Subscript out of range
> and highlights
.Function = xlSum
> .Position = 2
> End With
> With .PivotFields("Skills %")
> .Orientation = xlDataField
> .Function = xlSum
> .Position = 3
> .NumberFormat = "0%&qu
ion = xlDataField
> .Function = xlSum
> .Position = 2
> End With
> With .PivotFields("Skills %")
> .Orientation = xlDataField
> .Function = xlSum
> .Position = 3
>
On Monday, October 1, 2012 9:11:00 PM UTC+4, prkhan56 wrote:
>
> I posted this yesterday...it seems it did not get through..so posting once
> again
>
> Hello All,
>
> I am using Excel 2010. I have a List of Names in Sheet name “List”
>
>
> I have at
Congrats!
On Wednesday, October 3, 2012 3:43:49 PM UTC+4, NOORAIN ANSARI wrote:
>
> I can say only...
>
> यूँ ही बरकरार रखो भाई अपने Expertise के छाप को.
> और अपनी तरक्की से छोटा कर दो आसमा के माप को.
> हम दोस्तों की दुआए,सदा संग बन के रहे साए...
> मेरे ओर से लाख-लाख बधाई, राजन बा
Hello Ashsh,
I posted my query and dont see it
Did it get through.
Rashid
On Monday, October 1, 2012 9:11:00 PM UTC+4, prkhan56 wrote:
> I posted this yesterday...it seems it did not get through..so posting once
> again
>
> Hello All,
>
> I am using Excel 2010. I have a List
Hello All,
Works great!
Thanks to everybody for their time and helpn
Rashid Khan
On Saturday, September 15, 2012 3:52:57 PM UTC+4, prkhan56 wrote:
> Hello Experts,
> I am using Excel 2010 and have the following problem.
> If an employee no. is duplicate and he has worked in both Work Are
n press the button
> Highlight.
>
> regards
> prince
>
> On Saturday, 15 September 2012 17:22:57 UTC+5:30, prkhan56 wrote:
>>
>> Hello Experts,
>> I am using Excel 2010 and have the following problem.
>> If an employee no. is duplicate and he has worked in both
On Sunday, September 9, 2012 11:50:05 PM UTC+4, prkhan56 wrote:
>
> Hello All,
>
> We have a group of employees having various Grades and Position.
>
> 1) A fixed target of sales to be achieved every month as shown in
> Col D (Target).
>
> 2) Each level has d
en.
>
> Rgds//Vabz
>
> On Monday, September 10, 2012 1:20:05 AM UTC+5:30, prkhan56 wrote:
>>
>> Hello All,
>>
>> We have a group of employees having various Grades and Position.
>>
>> 1) A fixed target of sales to be achieved every month
> Microsoft Excel Developer
> SalesAid Software
> dguil...@gmail.com
>
> *From:* prkhan56
> *Sent:* Sunday, August 26, 2012 3:19 AM
> *To:* excel-...@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Macro to convert date at the time of entry
>
> Hello,
&g
is entered.
Thanks for your time anyway.
Regards
Rashid Khan
On Saturday, August 25, 2012 5:16:07 PM UTC+4, prkhan56 wrote:
> Hello All,
> I found the following function from ozgrid
> which reverses a text string
>
> Option Explicit
>
> Public Function Reverse
Hello Don Sir,
I tried the code
when I entered 30062012 - it changed to 12201632 instead of 20120630
I entered 08122012 it changed to 12208122 instead of 20121208
Can you please check
Thanks
On Saturday, August 25, 2012 5:55:22 PM UTC+4, Don Guillett wrote:
> Right click sheet tab>copy/past
Great Work Noorain Bhai..Keep it up
On Friday, August 3, 2012 9:40:25 PM UTC+4, Ayush Jain wrote:
>
> Dear members,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> July'12. He has posted 143 posts in July 2012 and helped many forum members
> through his excel ex
Thanks Pascal.
WOW!!! the code runs like a Magician Wand.
I am not aware why the last row shows as #NA (as I am not knowledgeable
to that level)
I am eagerly waiting for your 'Magic Touch' for the output of Category,
Name, Hours and EOM
Thanks once again.
Rashid
On Saturday, July 28, 2012 2:08
Hi Pascal,
Thanks for the code.
I changed the code according to my limited knowledge..
I think I missed something probably..pardon me for my ignorance
When I run the code it gives an error...
Block If without and EndIf and highlights End Function
Can you please paste the whole code
This is the
Hello Pascal,
Your code does not pick up the General Category Activity from Row 911 in
Original Sheet.
Please look into this.
Thanks for your effort
On Wednesday, July 25, 2012 11:42:41 PM UTC+4, bpascal123 wrote:
> Hi Anil,
>
> I have started looking at your query. I'm getting somewhere with th
Hello,
With the present data, I cannot.
That is what I will do when I get all the Emp details in a summary sheet.
Now the Emp names are in columns.
I wish to have their details one below other so I can use it in a Pivot
Table
On Wednesday, July 25, 2012 12:53:20 AM UTC+4, bpascal123 wrote:
> Hav
Hello Krishna
I cannot open the file.
Can you please check your file?
Thanks
Rashid Khan
On Thursday, June 21, 2012 6:57:23 PM UTC+4, Krishnaraddi wrote:
> Hi All
>
> Please find the attached PPT consists of few useful excel functions
> explained. I have prepared this document for training purpo
ents\Downloads\New Folder\[Stock.xls]Sheet1'!$C$5:$C$914,1,0))),"NO","
> ")
>
> On Sun, Jun 3, 2012 at 10:11 PM, prkhan56 wrote:
>
>> Thanks.
>> But it is showing "Yes" for Blanks also.
>> I wish to show Blank for Blanks.
>>
Thanks.
But it is showing "Yes" for Blanks also.
I wish to show Blank for Blanks.
On Saturday, June 2, 2012 12:12:39 PM UTC+4, vijayajith VA wrote:
> Hi Rashid
> As you requested.. Please find ...attached file...Thanks
>
>
> On Sat, Jun 2, 2012 at 1:14 PM, Rashid Khan wrote:
>
>> Hello All
>>
>>
Hi Noorain,
Pls send me the file Excel VBA Ebook 2007 on prkha...@gmail.com
Thanks
On Thursday, May 31, 2012 1:10:54 PM UTC+4, NOORAIN ANSARI wrote:
> Dear All,
>
> I have send ebook on your email ID.
>
> Please check and confirm me.
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari
70 matches
Mail list logo
