Hi Asa,
your code really works exact for me.Thanks for the help but can u please
explain why you have done this Character As String * 1.
On Monday, June 4, 2012 9:14:07 PM UTC+5:30, Asa R. wrote:
I re-read your query and I see you only wanted alphabet characters. I
had this include
Hi david.
that e was bymistake.I want to clean special characters spaces it's
done by Asa's code.
thanks for your concern.
On Tuesday, June 5, 2012 6:11:41 AM UTC+5:30, David Grugeon wrote:
Hi Sonal
I hope you realise that if you apply any of the suggested solutions to
your string
Rajan...Thanks for the help but still your code is returning numbers .
On Monday, June 4, 2012 9:11:22 PM UTC+5:30, Rajan_Verma wrote:
Ah , *Cod* is just a integer type *variable* , that will hold the *ACSII
Code* or each character in string,
* *
*Regards*
*Rajan verma*
*+91
is irregular i.e you
have the Current week data in all the files.Each files takes so much of
time to get open.Then, i put weeknum function in the file copy the data
at my end.Please suggest any solution(if any macro) if it can be resolved.
Thanks
SG
--
FORUM RULES (986+ members already BANNED
on it.
Thanks
On Thursday, July 5, 2012 6:46:25 PM UTC+5:30, NOORAIN ANSARI wrote:
Dear SG.
Please try it..
Option Explicit
Sub SHRINK_EXCEL_FILE_SIZE()
Dim WSheet As Worksheet
Dim CSheet As String 'New Worksheet
Dim OSheet As String 'Old WorkSheet
Dim Col As Long
Dim
+5:30, SG wrote:
Hi Experts,
I need your help again.We extract the data from database each user got
some errors on different projects.I need to clean the error data to get the
count of errors.For this,i do text to column on error column.Then, in each
column after error column, i take
Developer
SalesAid Software
dguille...@gmail.com
*From:* SG sonal...@gmail.com
*Sent:* Monday, July 16, 2012 8:49 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Re: Error Cleaning
Hi Don,
Thanks for the help. I haven't run the macro.I'm a begineer
dguille...@gmail.com
*From:* SG sonal...@gmail.com
*Sent:* Monday, July 16, 2012 9:30 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Re: Error Cleaning
Hi Don,
It's working perfectly.but one more problem is this i have shown only 3
columns in my sample
Hi Pascal,
Thanks for the suggestion but after cleaning the data, we have to perform
other things in excel.Ialso don't have knowledge of Access,I'll try it.
On Tuesday, July 17, 2012 1:03:29 PM UTC+5:30, bpascal123 wrote:
Hi SG,
If you have so many rows and need to have data sorted
it.
On Monday, July 16, 2012 9:03:57 PM UTC+5:30, Don Guillett wrote:
You might try expanding column C to find out that that is NOT
true
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* SG sonal...@gmail.com
Hi Experts,
Please find attached sheet for cleaning. What i want is this after
splitting , each error gets a unique row like i manually done in the third
sheet.Problem is that the no. of columns can increase Code used by user
will always be in the end,so, macro will copy the complete row
data)
On Friday, July 20, 2012 2:37:37 AM UTC+5:30, bpascal123 wrote:
Hi SG,
This code below should help you. You can run it from the vba ide in the
attached file.
I'm not as comfortable as Don is with vba objects and methods so maybe
Don's code is better for this.
I don't run
.ScreenUpdating = True
End With
Set r = Nothing
Set wbIn = Nothing
Set wsIn = Nothing
Set wsInOut = Nothing
End Sub
---
Pascal
On Friday, July 20, 2012 2:34:04 PM UTC+1, SG wrote:
hi pascal,
i didn't understand this part of code...what should i write if i run this
macro in new
think if you already have some knowledge of Vba, you can use these Vba
tools as I'm trying to present you.
Pascal Baro
On Monday, July 23, 2012 2:03:26 PM UTC+1, SG wrote:
hi Pascal
Thanku so muchit really helped meappreciate your help. even
it increased my knowledge
Hi Experts,
I'm again in to a problem whic is silly but still i can't make it.I
calculate the scores for individuals seperately but this time i want to
make all under one table.For this, i have created a pivot table for
Calculating the Score, I have used Calculated field which is not giving
Experts,
plz help mei need solution.plz look in to this
On Monday, September 17, 2012 8:20:53 PM UTC+5:30, SG wrote:
Hi Experts,
I'm again in to a problem whic is silly but still i can't make it.I
calculate the scores for individuals seperately but this time i want to
make all
Regards
CK
On Wed, Sep 19, 2012 at 2:45 PM, SG sona...@gmail.com javascript:wrote:
Experts,
plz help mei need solution.plz look in to this
On Monday, September 17, 2012 8:20:53 PM UTC+5:30, SG wrote:
Hi Experts,
I'm again in to a problem whic is silly but still i can't make it.I
field button to define formula.. thats it.
There was error in formula given by me was working well in chetan's file.
Rgds//Vabs
On Thursday, September 20, 2012 6:54:45 PM UTC+5:30, SG wrote:
hi Chetan/vabz
thanks for the help. I got the solutions.plz explain what you have done
to get
any update plz...
plz help me to understand this.
On Monday, September 24, 2012 9:06:59 PM UTC+5:30, SG wrote:
hi Vabz,
Still i'm not able to find the difference.Though i have also used the same
formula in calculated field in my sheet.
Plz let me know...so that i would be able to help
Hi Experts,
I need your help in one of my problem.I want to consolidate the
multiple excel files of a folder with same name numbered as 1,2,3 in to a
one excel file.I have tried but unable to create a macro on it.There is
only one criteria in this consolidation is that on column D of every
/*
* *
* *
* *
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *SG
*Sent:* 14 December 2012 7:19
*To:* excel-...@googlegroups.com javascript:
*Subject:* $$Excel
]*
* *
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *SG
*Sent:* 14 December 2012 7:54
*To:* excel-...@googlegroups.com javascript:
*Subject:* Re: $$Excel-Macros$$ Consolidating Multiple files
hi Rajan,
Thanks
,*
* *
*Open Visula Basic Editor*
*Goto the Tool- Reference –Select **Microsoft scripting runtime***
* *
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *SG
as ever you can.” - John Wesley
*-
--
*From:* SG sona...@gmail.com javascript:
*To:* excel-...@googlegroups.com javascript:
*Sent:* Fri, December 14, 2012 10:11:52 AM
*Subject:* Re: $$Excel-Macros$$ Consolidating Multiple
experts please help me with this.i have also attached the file .
On Monday, December 17, 2012 1:59:39 PM UTC+5:30, SG wrote:
hi Paul,
Sorry for the inconvenience.PFA file names of excel file are 1,2,3.
Please suggest.
On Friday, December 14, 2012 9:03:11 PM UTC+5:30, Paul Schreiner
Hi Experts,
I want to create a report in which data would be extracted on basis of
atleast 4 filters from base data sheet.please help me with a macro example.
Thanks in advance.
--
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
.
Thanks
On Wed, Jul 3, 2013 at 7:30 PM, SG sona...@gmail.com javascript:wrote:
Hi Experts,
I want to create a report in which data would be extracted on basis of
atleast 4 filters from base data sheet.please help me with a macro example.
Thanks in advance.
--
Are you =EXP(E:RT
, SG sona...@gmail.com javascript:wrote:
thanx for the response.
PFA example.What i want is to filter the data as oer the Form sheet
extract name it's accuracy paste in the data section.the data is so
huge that's why i want it by macro.
On Wednesday, July 3, 2013 7:41:24 PM UTC+5:30
hi Ashish,
thanks for the help.please help me in result as i want only name accuracy
to show.
On Wednesday, July 3, 2013 8:49:33 PM UTC+5:30, ashish wrote:
try the attachment . if ur data is in lakhs best is u use access
Regards
Ashish
On Wed, Jul 3, 2013 at 8:42 PM, SG sona
hi Experts,
I'm in a great problem as i'm beginner in macros.I have created a template
in which the data would be extracted on basis on 3 criterias.However, by
using macro, i'm unable to extract it.For criterias, i have created
drop-down list by using Data validation name manager.
Now
plz experts..spare some time on my problem.
looking forward for your help.
On Friday, July 5, 2013 5:25:27 PM UTC+5:30, SG wrote:
hi Experts,
I'm in a great problem as i'm beginner in macros.I have created a template
in which the data would be extracted on basis on 3 criterias.However
.
On Saturday, July 6, 2013 10:30:04 AM UTC+5:30, Vabz wrote:
Hi
PFA, You have to ensure criteria range is in same sheet in which you apply
filter.
you also need to extend your range to accommodate rest of data..
Thaks
On Fri, Jul 5, 2013 at 5:25 PM, SG sona...@gmail.com
Hi Experts,
Once again I neeed your help.I have one excel worksheet which is common for
all workbooks. However, that worksheet is not added in the workbooks. I
have atleast 50 excel workbooks in a folder in which i have to add that
single worksheet manually.The name of all worbooks are same
(fil.Path)
ThisWorkbook.Sheets(sample).Copy After:=wkb.Sheets(wkb.Sheets.Count)
wkb.Save
wkb.Close
Set wkb = Nothing
Next
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub
see if it helps
On Mon, Sep 9, 2013 at 7:45 PM, SG sona...@gmail.com
:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *SG
*Sent:* Tuesday, September 10, 2013 2:36 PM
*To:* excel-...@googlegroups.com javascript:
*Subject:* Re: $$Excel-Macros$$ Macro needed to add worksheet
Thanks for the help but it's
** **
Application.ScreenUpdating = True
Application.DisplayAlerts = True
** **
** **
End Sub
** **
** **
* *
*Warm Regards,*
*Ravi Kumar.*
** **
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *SG
*Sent
. When we use “_” it will
continue our current line with next new line. You can see above number 1
and 2 point both are same
* *
*Warm Regards,*
*Ravi Kumar.*
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *SG
*Sent
Hi Experts
please help
On Wednesday, September 11, 2013 7:55:14 PM UTC+5:30, SG wrote:
hi Ravi,
This code is throwing error subscript out of range.
Please suggest.
On Wednesday, September 11, 2013 5:44:17 PM UTC+5:30, Ravi Kumar wrote:
No dear,
Point 1)
Workbooks
Hi experts
Please help me with your effective solution. I’m working on a training
template in which individual scores would be analyzed scores for all
trainees comes in summary sheet. For this, in each individual sheet I have
used radio buttons. What I need is for a parameter, if I click
O yes.
Thanku so much. I guess the idea behind its working is that you have
unfreezed the linked cell in properties.
Am i right sir??
On Monday, February 17, 2014 6:23:08 PM UTC+5:30, Abhi wrote:
Something like this?
On Mon, Feb 17, 2014 at 4:58 PM, SG sona...@gmail.com
further help with this.
Regards,
Abhishek
On Mon, Feb 17, 2014 at 6:42 PM, SG sona...@gmail.com javascript:wrote:
O yes.
Thanku so much. I guess the idea behind its working is that you have
unfreezed the linked cell in properties.
Am i right sir??
On Monday, February 17
the group box first, draw it to the size on
sheet, then you put option buttons in there. After you have put all the
buttons, just right click on any of them (without selecting the group box)
and choose the reference cell where the value would be placed.
On Mon, Feb 17, 2014 at 7:23 PM, SG sona
Hi Experts,
I need a solution to sort the data on basis of location highest marks.
For this, i have created a dynamic named range to call it by macro then
sort. My problem comes when the range also selects the blank formulas in
sheet which shouldn't be selected. Only visible data should
:
PFA
Thx
On Thu, Apr 17, 2014 at 1:28 PM, SG sona...@gmail.com javascript:wrote:
Hi Experts,
I need a solution to sort the data on basis of location highest marks.
For this, i have created a dynamic named range to call it by macro then
sort. My problem comes when the range also
Amazing Vabz...thanksss..Can you please explain the idea behind this???
On Wednesday, June 18, 2014 6:30:28 PM UTC+5:30, Vabz wrote:
Hi
In cell C2 put * (only asterik) instead of ALL.
Cheers!!
On Wed, Jun 18, 2014 at 6:10 PM, SG sona...@gmail.com javascript:
wrote:
Hi Experts,
I'm
used where command was Dir *.*
Cheers!!
On Wed, Jun 18, 2014 at 6:48 PM, SG sona...@gmail.com javascript:
wrote:
Amazing Vabz...thanksss..Can you please explain the idea behind this???
On Wednesday, June 18, 2014 6:30:28 PM UTC+5:30, Vabz wrote:
Hi
In cell C2 put * (only asterik
Thankyou so much Vabz
On Wednesday, June 18, 2014 8:50:04 PM UTC+5:30, Vabz wrote:
Chek this,,,
On Wed, Jun 18, 2014 at 7:08 PM, SG sona...@gmail.com javascript:
wrote:
yeah got it...one more thing..in reports, we can't say customer to select
* for All because it's not user
Hi Experts,
I need your help in preparation of a feedback sheet through macro. My
requirement is to create name wise feedback worksheet in a workbook
which contains their data from scorecard sheet. one of the criteria is
to create the name wise sheet for only region uk location b users.
I
??
Cheers!!
On Tue, Aug 19, 2014 at 7:39 PM, SG sona...@gmail.com javascript:
wrote:
Hi Experts,
I need your help in preparation of a feedback sheet through macro. My
requirement is to create name wise feedback worksheet in a workbook
which contains their data from scorecard sheet
!!
On Tue, Aug 19, 2014 at 7:39 PM, SG sona...@gmail.com javascript:
wrote:
Hi Experts,
I need your help in preparation of a feedback sheet through macro. My
requirement is to create name wise feedback worksheet in a workbook
which contains their data from scorecard sheet. one
wrote:
hi
dont use double click, it is for only single sheet update.
You have to just run a macro, check this file, click blue button..
Make sure both files are open.
Cheers!!
On Wed, Aug 20, 2014 at 8:20 PM, SG sona...@gmail.com javascript:
wrote:
Hi Vabz,
i'm really not getting
+5:30, Vabz wrote:
FA
Cheers!!
On Thu, Aug 21, 2014 at 1:43 PM, SG sona...@gmail.com javascript:
wrote:
Hi Vabz
Great.. :) Thanku so much..please only one change is needed in total
external errors internal errors(row 9 10 of feedback sheet), the sum of
errors should come
!!
On Aug 21, 2014 5:24 PM, SG sona...@gmail.com javascript: wrote:
Vabz sirhats offthnku so much...really gr88
now i have some questions so that i can clear my doubt. what you have
created a code name create old feedback what is the use of
Option Explicit
Public MyFile As String
:37:52 PM UTC+5:30, SG wrote:
Thanku so much vabz for clarification...
On Friday, August 22, 2014 12:11:04 PM UTC+5:30, Vabz wrote:
Old module is for creating files in wrokbook insted in feedback sheet.
I have also created Macro for updating only 1 sheet, wherein you needed
to keep open
Hi Vabz,
Any update on this. Can it be consolidated in any other way.
please,can anybody else also look in to this.
On Monday, August 25, 2014 7:50:13 PM UTC+5:30, SG wrote:
some of the criterias are to consolidate the
scores of users for region UK location b. The header yellow
, August 26, 2014 1:51:29 PM UTC+5:30, Vabz wrote:
How do you want data in feed back sheet, do you want to add for 2 period
or in separate sheet?
On Tue, Aug 26, 2014 at 1:11 PM, SG sona...@gmail.com javascript:
wrote:
Hi Vabz,
Any update on this. Can it be consolidated in any other way
26, 2014 2:38 PM, SG sona...@gmail.com javascript: wrote:
Vabz,
This would be used for monthly feedback. For monthly, i have to
consolidate those 4 scorecard files which are prepared on weekly baisi
then i prepare the feedback for each.
This requires the consolidation of scores of those 4
gr88...then will you please help me on this.
On Tuesday, August 26, 2014 4:27:32 PM UTC+5:30, Vabz wrote:
yes
On Tue, Aug 26, 2014 at 3:36 PM, SG sona...@gmail.com javascript:
wrote:
yes sir..absolutely right..
is it feasible na?
On Tuesday, August 26, 2014 2:59:02 PM UTC+5:30, Vabz
PM, SG sona...@gmail.com javascript:
wrote:
gr88...then will you please help me on this.
On Tuesday, August 26, 2014 4:27:32 PM UTC+5:30, Vabz wrote:
yes
On Tue, Aug 26, 2014 at 3:36 PM, SG sona...@gmail.com wrote:
yes sir..absolutely right..
is it feasible na?
On Tuesday, August 26
ed sheet. The difference in headers are typo errors.
Regards,
SG
On Thursday, January 7, 2016 at 1:11:40 PM UTC+5:30, Mandeep Baluja wrote:
>
> Hi SG,
>
> Things I would like to know !!!
> 1) What is required You need formula in column "I" or You need to
> d
Hi Mandeep,
Please refer to the comment in attached sheet.
I hope it would get clear now. :)
On Thursday, January 7, 2016 at 2:06:11 PM UTC+5:30, Mandeep Baluja wrote:
>
> Hey SG,
>
> Correct me if I am wrong !!
> 1)If Parameter M(Fatal) is No, then total score would be 0
Hi Masters,
Need your help again. I need to do some changes in my file.
First, when the user enters the start & end time with same day with their
name, it would become red highlighted & message popped out to change the
time to void duplicate (row 10 & 13).
Second, when they click the submit
Hi Experts,
Please help.
On Monday, June 6, 2016 at 1:46:58 PM UTC+5:30, SG wrote:
>
> Hi Experts,
>
> I need your help in presenting the week wise time used in an account. What
> i need is to prepare a chart in which when i select month & name,
> the no.
Hi Experts,
I need your help in presenting the week wise time used in an account. What
i need is to prepare a chart in which when i select month & name,
the no. of weeks & its values in that particular month would be the source
data of chart.
For e.g, if i select 6 as month (which is june) &
Hi Experts...
please help me on this.
On Tuesday, June 7, 2016 at 4:25:32 PM UTC+5:30, SG wrote:
>
> Hi Masters,
>
> Need your help again. I need to do some changes in my file.
>
> First, when the user enters the start & end time with same day with their
> name, it wou
Thanks for the idea Gowri. I know this trick but this time , i forgot to
use. :)
Thanks for recalling it.
On Monday, June 6, 2016 at 3:58:16 PM UTC+5:30, a.gowri wrote:
>
> please find the attachment.
>
> On Mon, Jun 6, 2016 at 3:15 PM, SG <sona...@gmail.com >
> w
>
>
>
> *“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*
> -----
>
>
> On Thursday,
person, per month with available
slots as per the slab. PFA for you.
Also, Rand function don't have any impact in selection of samples. Am i
right?
Please check if this can be solved as this is the condition for sampling.
On Friday, January 29, 2016 at 11:58:04 AM UTC+5:30, SG wrote:
>
> No P
Paul, have you checked it?
On Wednesday, January 27, 2016 at 6:45:26 PM UTC+5:30, SG wrote:
>
> Thanks for your quick response Paul. The line ""In case, any slot not
> available, it should pick so on" means that in case any slot is not
> available, it should skip it
alls
it has. It must cover all agent with number of calls they have in that
month. Honestly speaking, You have really done the efforts in this file
but my purpose is not getting solved neither i'm able to do it. :( If you
can again relook this..please check otherwise..really thanks
Regard
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*
> -
>
>
> On Monday, February 1, 2016 5:34 AM, SG <sona...@gmail.com >
> wrote:
>
>
>
> Hi Paul,
&
od 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*
> -
>
>
> On Monday, February 1, 2016 8:33 AM, SG <sona...@g
Hi Experts
I need your help in choosing the samples for quality check. The only idea
in my mind is the Random function but this wouldn’t suffice as there are
2-3 conditions on basis of which sampling should be done.
It should be done for 4 calls per month per type (column A for type).
ant to do in this case.
> In your explanation, you said:
> "In case, any slot not available, it should pick so on."
>
> I have no idea what you mean by "it should pick so on".
>
>
> *Paul*
> -
>
>
>
>
>
74 matches
Mail list logo
