hi pascal,
Thanks for explaining.It really helped me.I'm a beginner in macros so i
used to follow all experts.
On Tuesday, July 24, 2012 5:48:08 PM UTC+5:30, bpascal123 wrote:
> This forum is a great place to learn, contributors I closely follow;
> Noorain, Asa, Don...
>
> On Monday, July 23,
This forum is a great place to learn, contributors I closely follow;
Noorain, Asa, Don...
On Monday, July 23, 2012 5:25:31 PM UTC+1, bpascal123 wrote:
>
> My Vba coding style is much inspired from Kris who from what I know,
> posts here and on excelfox.com. If you can read his code, you should
My Vba coding style is much inspired from Kris who from what I know, posts
here and on excelfox.com. If you can read his code, you should learn many
tricks.
If rCol > 1 Then
> v = Array(r)
> .Rows(i + 1 & ":" & i + rCol - 1).Insert
>
> .Range(.C
hi Pascal
Thanku so muchit really helped meappreciate your help.& even it
increased my knowledge in VB...
plz explain below part of code...& thanks again
If rCol > 1 Then
v = Array(r)
.Rows(i + 1 & ":" & i + rCol - 1).Insert
.Ra
This line should allow you to run this macro from the workbook where the
data is ... if the file is not xlsx (it can then be xls, xlsm, xlsb )
Set wbIn = ThisWorkbook
(the line...worksheet add... that was commented out i forgot to delete
wouldn't work anyway-i just found it easier to run the co
hi pascal,
i didn't understand this part of code...what should i write if i run this
macro in new workbook
Set wbIn = Workbooks("Book1 - Copy.xlsm")
'Set wsInOut = wbIn.Worksheets.Add: wsInOut.Name = "sorted data ok2"
Set wsInOut = wbIn.Worksheets("sorted data")
Set wsIn = wbIn.Worksheets("sp
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 if it takes time for many rows, ask again i like to search on
the web trick to improve
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 f
It's difficult to understand and help as you've posted different version of
your data, at first there you start with a certain number of columns and
then you end up with different column like : Study Name Coder(SC) 1.Coder
/Qer name for scorecards 2.Type Of Errors Final for Scorecard
I also try
You will have to SHOW me in the file
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: SG
Sent: Tuesday, July 17, 2012 4:54 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Error Cleaning
Hi Don,
My question is that after running the
il.com
>
> *From:* SG
> *Sent:* Monday, July 16, 2012 10:26 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Re: Error Cleaning
>
> Yes, if you see..from row 12 to row 40, the data is blank..can it be
> possible after running the macro
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 in a
Hi SG,
If you have so many rows and need to have data sorted in a table way,
Access might be a better solution than Excel.
I understand you can have one and only Project number, one and only one
person Name for a project and one to many error codes. I don't have strong
Access skills but if you
Developer
SalesAid Software
dguille...@gmail.com
From: SG
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
oper
> SalesAid Software
> dguille...@gmail.com
>
> *From:* SG
> *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 proble
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: SG
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 o
I don’t understand. Look at before/after sheets to see what macro is doing.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: SG
Sent: Monday, July 16, 2012 9:30 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Error Cleaning
Hi Don
ze
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* SG
> *Sent:* Monday, July 16, 2012 8:49 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Re: Error Cleaning
>
> Hi Don,
>
>
@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 to the macro.Can
you please explain the "option Explicit" & use of "resize" & would i run this
macro after text to column spl
> *From:* SG
> *Sent:* Monday, July 16, 2012 3:42 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Error Cleaning
>
> Sorry for Replying late.Yes, i choose delimit & choose comma for
> it.Problem is this that the data is in thousandsr rows
ubject: $$Excel-Macros$$ Re: Error Cleaning
Sorry for Replying late.Yes, i choose delimit & choose comma for it.Problem is
this that the data is in thousandsr rows & manually it takes so much time.i
have attached a file & i hope it clears the doubts brfore cleaning the data &
afte
Sorry for Replying late.Yes, i choose delimit & choose comma for it.Problem
is this that the data is in thousandsr rows & manually it takes so much
time.i have attached a file & i hope it clears the doubts brfore cleaning
the data & after cleaning the data.
On Friday, July 13, 2012 5:33:35 PM U
Hi,
Please attach file with sample data to make it more clear.
Regards,
Lalit Mohan
On Sat, Jul 14, 2012 at 3:11 AM, bpascal123 wrote:
> Hi,
>
> You say:
>
> 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
Hi,
You say:
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
What settings do you apply for text to columns?
If you first ch
24 matches
Mail list logo
