Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

[Ricardo®]

Hi Suyog Kulkarni,

See how build an Excel Add -In

http://www.fontstuff.com/vba/vbatut03.htm

Regards,

Basole


2014-04-05 1:22 GMT-03:00 Suyog Kulkarni :

> Hi Basole,
>
> It's working fine now following are the only problems remaining.
> 1. While creating macro, I have assigned "ctrl+q" shortcut which is not
> working now
> 2. How can we save the code as "Add In" or can we add any buttom in
> existing toolbar ? so I that I can share the same with my co-workers.
>
> I can't see, save as option in vba window. Pl help.
> Thanks to all group members, because of you all I made this code.
>
> With Regards,
> Suyog
>
> *Below is the modified code. *
>
> Sub ReportWriter()
>
> ' Format Macro
> '
> ' Keyboard Shortcut: Ctrl+q
> '
> ' This lines are two fill white color
> Cells.Select
> With Selection.Interior
> .Pattern = xlSolid
> .PatternColorIndex = xlAutomatic
> .ThemeColor = xlThemeColorDark1
> .TintAndShade = 0
> .PatternTintAndShade = 0
> End With
>
>
> ' This is range for Report Headings
> Range("A1:I4").Select
> Selection.ClearContents
> With Selection
> .HorizontalAlignment = xlCenter
> .VerticalAlignment = xlCenter
> End With
> Selection.Merge
>
> ' This is range for Report Header Line
> Range("A5:I5").Select
> With Selection.Interior
> .Color = 13434879
> Selection.Font.Bold = True
> End With
>
> ' This is "total non blank area of any report. Or Cell range with
> Text/value
> x = Cells(Rows.Count, "A").End(xlUp).Row
> y = Cells(x, Columns.Count).End(xlToLeft).Column
> Range("A1:" & Cells(x, y).Address).Select
> With Selection.Borders
> .LineStyle = xlContinuous
> .Weight = xlThin
> End With
> Cells.Select
> With Selection.Interior
> Selection.Font.Name = "Calibri"
> Selection.Font.Size = 11
> Selection.Font.ThemeFont = xlThemeFontMinor
> End With
> Cells.Select
> Selection.Columns.AutoFit
> With Selection
> .VerticalAlignment = xlCenter
> .HorizontalAlignment = xlCenter
> .VerticalAlignment = xlCenter
> End With
> Range("A5").Select
> ActiveWorkbook.Save
> MsgBox "Formatting is done. Only add project details properly.",
> vbOKOnly, "Code by Suyog Kulkarni"
> End Sub
>
>
>
>
>
> On Saturday, 5 April 2014 02:32:12 UTC+5:30, Basole wrote:
>
>> Hi, try this:
>>
>> x = Cells(Rows.Count, "A").End(xlUp).Row
>> y = Cells(x, Columns.Count).End(xlToLeft).Column
>> Range("A1:" & Cells(x, y).Address).Select
>>
>>
>> Regards,
>>
>> Basole.
>>
>>
>>
>>
>>
>>
>> 2014-04-04 11:17 GMT-03:00 Suyog Kulkarni :
>>
>>> Hello All,
>>>
>>> I made my first macro code. Kindly review. Now only problem remain is
>>> instead of *Range("A1:I100"), I want excel to choose "last row & last
>>> column" which contain text/value.*
>>>
>>> PL help.
>>>
>>> Regards,
>>> Suyog
>>>
>>> " Below is my code"
>>>
>>> *Sub Format()*
>>>
>>> ' Format Macro
>>> ' Keyboard Shortcut: Ctrl+q
>>> ' This is range for Report Headings
>>> Range("A1:I4").Select
>>> Selection.ClearContents
>>> With Selection
>>> .HorizontalAlignment = xlCenter
>>> .VerticalAlignment = xlCenter
>>> End With
>>> Selection.Merge
>>>
>>> ' This is range for Report Header Line
>>> Range("A5:I5").Select
>>> With Selection.Interior
>>> .Color = 13434879
>>> Selection.Font.Bold = True
>>> End With
>>>
>>> ' This is "total non blank area of any report. Or Cell range with
>>> Text/value
>>> *Range("A1:I100").Select*
>>> With Selection.Borders
>>> .LineStyle = xlContinuous
>>> .Weight = xlThin
>>> End With
>>> Cells.Select
>>> With Selection.Interior
>>> Selection.Font.Name = "Calibri"
>>> Selection.Font.Size = 11
>>> Selection.Font.ThemeFont = xlThemeFontMinor
>>> End With
>>> Cells.Select
>>> Selection.Columns.AutoFit
>>> With Selection
>>> .VerticalAlignment = xlCenter
>>> .HorizontalAlignment = xlCenter
>>> .VerticalAlignment = xlCenter
>>> End With
>>> Range("A5").Select
>>> ActiveWorkbook.Save
>>> MsgBox "Formatting is done. Only add project details properly.",
>>> vbOKOnly, "Made by Suyog Kulkarni"
>>> *End Sub*
>>>
>>>
>>>
>>>
>>>
>>> On Friday, 4 April 2014 15:11:52 UTC+5:30, Suyog Kulkarni wrote:

 Hello All,

 Refer attached excel, I've tried to develop macro using recording for
 repetitive formatting. Now my problem is how can I assign range for all
 "Non-blank" cell. Because my current will work only upto "Row 13 & Column
 I".

 How can assign the code which can work till last row & column which
 contain text / value. Short cut for macro is Ctrl

Re: $$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

[ashish koul]

you need to select the range and then run proper, upper , lower etc as per
your requirement



On Sat, Apr 5, 2014 at 9:54 PM, Falina Gan  wrote:

> Hi Ashish,
>
> Good day,
>
> I have tested your codes but the texts are not changes at all. The macro
> have asked me which one to run and I have run all the sub function but
> still can't see the results.
>
> Thanks
>
>
> 
> Here is my images for your reference.
>
> On Saturday, April 5, 2014 1:38:03 PM UTC+8, Falina Gan wrote:
>>
>> To Whom It May Concern,
>>
>> We would like to know if we are creating a column for uppercase,
>> lowercase and initial case like the image as below:
>>
>> 
>>
>>
>> Hope to hear from you soon.
>>
>> Thanks.
>>
>  --
> 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 thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

[Bipin Singh]

Glad to Help you.

Much Obliged,



On Sat, Apr 5, 2014 at 12:42 PM, prkhan56  wrote:

> Thanks Vicky.
> Works like a charm
>
>
> On Saturday, April 5, 2014 3:45:49 AM UTC+4, Vicky wrote:
>
>> Rashid Sir,
>>
>> I have made some changes. Now you can change your input column to any
>> column in the sheet and output will be 3 column forward and 1 row down from
>> the input data.. If you require data in different column other then this
>> then change offset value as per your requirement inside the loop.
>>
>> Also please ensure that you data should always start from first row i.e.
>> in first row headings and then required data.
>>
>>
>> Hope this helps.
>>
>> 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 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 Col S then it should work for Col S and T...
>>> The output, if required can be on a new sheet
>>> Thanks for your time and help
>>>
>>>
>>> On Thursday, April 3, 2014 12:03:07 AM UTC+4, Vicky wrote:
>>>
 Rashid Sir, Hope attached will help?


 On Wed, Apr 2, 2014 at 4:39 PM, Rashid Khan  wrote:

> Dear All,
> I am using Excel 2010.
> I have attached a sample file with my problem.
>  Please see before and after
>
> Any macro help would be appreciate.
> Regards
> 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 of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros...@googlegroups.com.
> To post to this group, send email to excel-...@googlegroups.com.
>
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

  --
>>> 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 thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
> 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 thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and the

$$Excel-Macros$$ Re: Delete button on Sequence Column

[Falina Gan]

Hi Ashish,

After the delete button it will show the pattern column.

Thanks for asking. :)

On Saturday, April 5, 2014 1:00:26 PM UTC+8, Falina Gan wrote:
>
> To Whom It May Concern,
>
> Could you guide me with VBA codes, on these steps:-
>
> 1) Create a sequence column as image below ( all in alphabets )
> 2) Delete button to delete the sequence column
> 3) Then the pattern column is in "A" column. ( refer to your right side )
>
> Hope to hear from you. Thanks
>
>
> 
>   
>  
>

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

[Falina Gan]

Hi Ashish,

Good day,

I have tested your codes but the texts are not changes at all. The macro 
have asked me which one to run and I have run all the sub function but 
still can't see the results.

Thanks


Here is my images for your reference.

On Saturday, April 5, 2014 1:38:03 PM UTC+8, Falina Gan wrote:
>
> To Whom It May Concern,
>
> We would like to know if we are creating a column for uppercase, lowercase 
> and initial case like the image as below:
>
>
> 
>
>
> Hope to hear from you soon.
>
> Thanks.
>

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Macro for copying from a notepad and creating a record in excel

[ashish koul]

can u share how your output look likes


On Thu, Apr 3, 2014 at 10:25 PM, Subhra Sardar  wrote:

>
>
> I am new to VBA and I need a little help with VBA.The file is attached.
>
> As you can see below *column B *(EVENT TYPE) there is a field named *JOB* and
> below the field *JOB* there is a field named *OCCURS*.For some fields you
> can see there is also another field below the job field named *WHEN*.So
> all I need to do is cut/copy Everything after *OCCURS* and *WHEN* and put
> it under another Column after column named LAST TIME on the same sheet.Now
> one important point is the statement after *WHEN can be very long and I
> need the total statement to fit in one cell.*
>
> Please I need help with these.Let me know if you need any other details.
>
> --
> 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 thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Delete button on Sequence Column

[ashish koul]

who will be creating the pattern column ?

On Sat, Apr 5, 2014 at 10:30 AM, Falina Gan  wrote:

> To Whom It May Concern,
>
> Could you guide me with VBA codes, on these steps:-
>
> 1) Create a sequence column as image below ( all in alphabets )
> 2) Delete button to delete the sequence column
> 3) Then the pattern column is in "A" column. ( refer to your right side )
>
> Hope to hear from you. Thanks
>
>
> 
>
>
> --
> 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 thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Compare two worksheet Trial Balance

[ashish koul]

please share a sample workbook with some dummy data


On Sat, Apr 5, 2014 at 8:02 PM, Sandeep Kumar Chhajer <
chhajersand...@gmail.com> wrote:

> Dear Excel gurus,
>
> Kindly check the trailing mail.
> Thanks & Regards,
> Sandeep Kumar Chhajer
> Mumbai
> India
>
> Sent on my BlackBerry(R) from Vodafone
>
> -Original Message-
> From: "Sandeep Kumar Chhajer" 
> Sender: excel-macros@googlegroups.com
> Date: Sat, 5 Apr 2014 04:21:56
> To: Excel Macros
> Reply-To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Compare two worksheet Trial Balance
>
> Dear Excel gurus,
>
> Every day I have to compare two identical formatted worksheet trial
> balance. I want macro to compare both the trial balance.
> Macro should work as below:
> It will give me an option to choose which two workbook contains (workbook
> only contains one worksheet containing trial balance).
> Both Work book contains data like below:
> TB 1st April
> G/L code.  Amount
> 10005632.   -100
> 20004128.  50
> 30008721. -50
> 40007214. 100
>
> TB 2nd April
> G/L code.  Amount
> 10005632.   -100
> 10009841. -10
> 20004128.  60
> 30008721. -50
> 40007214. 100
>
> I used to compare both the sheet with vlookup and prepare report like below
>
> Changes in TB
> G/L code.   Amount.  Mode
>   Change
> 10009841.  -10.   New code
> 20004128.10.  Change in amount
>
> (sorry for reason of confidentiality I can't share file with you all. I
> hope you all understand)
>
> If any one can help me out to automate the report I will be highly
> grateful.
>
> Thanks in advance.
>
> Thanks & Regards,
> Sandeep Kumar Chhajer
> Mumbai
> India
>
> Sent on my BlackBerry(R) from Vodafone
>
> --
> 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 thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> 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 thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may

Re: $$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

[ashish koul]

Sub propercase()
Dim cl As Range
For Each cl In Selection.Cells
If cl.HasFormula = False And Not IsEmpty(cl) And Not IsDate(cl) Then
cl = StrConv(cl.Text, vbProperCase)
End If
Next
End Sub


Sub uppercase()
Dim cl As Range
For Each cl In Selection.Cells
If cl.HasFormula = False And Not IsEmpty(cl) And Not IsDate(cl) Then
cl = StrConv(cl.Text, vbUpperCase)
End If
Next
End Sub

Sub lowercase()
Dim cl As Range
For Each cl In Selection.Cells
If cl.HasFormula = False And Not IsEmpty(cl) And Not IsDate(cl) Then
cl = StrConv(cl.Text, vbLowerCase)
End If
Next
End Sub


On Sat, Apr 5, 2014 at 11:13 AM, Falina Gan  wrote:

> To Whom It May Concern,
>
> In VBA please. thanks.
>
> On Saturday, April 5, 2014 1:38:03 PM UTC+8, Falina Gan wrote:
>>
>> To Whom It May Concern,
>>
>> We would like to know if we are creating a column for uppercase,
>> lowercase and initial case like the image as below:
>>
>> 
>>
>>
>> Hope to hear from you soon.
>>
>> Thanks.
>>
>  --
> 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 thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Help to merge text from difference cell

[ashish koul]

please share a sample workbook


On Sat, Apr 5, 2014 at 1:18 PM, Ashish Bhalara wrote:

> Dear experts,
>
> I want merge cell containing text value and want comma(,) between all cell
> value in cocatenate function but my query is that when cell value is blank,
> the comma should not be display. Is it possible, kindly guide regarding
> this.
>
> Thanks & regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>  --
> 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 thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Compare two worksheet Trial Balance

[Sandeep Kumar Chhajer]

Dear Excel gurus,

Kindly check the trailing mail.  
Thanks & Regards,
Sandeep Kumar Chhajer
Mumbai
India 

Sent on my BlackBerry(R) from Vodafone

-Original Message-
From: "Sandeep Kumar Chhajer" 
Sender: excel-macros@googlegroups.com
Date: Sat, 5 Apr 2014 04:21:56 
To: Excel Macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Compare two worksheet Trial Balance

Dear Excel gurus,

Every day I have to compare two identical formatted worksheet trial balance. I 
want macro to compare both the trial balance.
Macro should work as below:
It will give me an option to choose which two workbook contains (workbook only 
contains one worksheet containing trial balance).
Both Work book contains data like below: 
TB 1st April
G/L code.  Amount
10005632.   -100
20004128.  50
30008721. -50
40007214. 100

TB 2nd April
G/L code.  Amount
10005632.   -100
10009841. -10
20004128.  60
30008721. -50
40007214. 100

I used to compare both the sheet with vlookup and prepare report like below

Changes in TB
G/L code.   Amount.  Mode 
  Change
10009841.  -10.   New code
20004128.10.  Change in amount

(sorry for reason of confidentiality I can't share file with you all. I hope 
you all understand)

If any one can help me out to automate the report I will be highly grateful.

Thanks in advance.
 
Thanks & Regards,
Sandeep Kumar Chhajer
Mumbai
India 

Sent on my BlackBerry(R) from Vodafone

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Help to merge text from difference cell

[Ashish Bhalara]

Dear experts,

I want merge cell containing text value and want comma(,) between all cell
value in cocatenate function but my query is that when cell value is blank,
the comma should not be display. Is it possible, kindly guide regarding
this.

Thanks & regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

[prkhan56]

Thanks Vicky.
Works like a charm

On Saturday, April 5, 2014 3:45:49 AM UTC+4, Vicky wrote:
>
> Rashid Sir,
>
> I have made some changes. Now you can change your input column to any 
> column in the sheet and output will be 3 column forward and 1 row down from 
> the input data.. If you require data in different column other then this 
> then change offset value as per your requirement inside the loop.
>
> Also please ensure that you data should always start from first row i.e. 
> in first row headings and then required data.
>
>
> Hope this helps.
>
> 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 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 Col S then it should work for Col S and T...
>> The output, if required can be on a new sheet 
>> Thanks for your time and help
>>
>>
>> On Thursday, April 3, 2014 12:03:07 AM UTC+4, Vicky wrote:
>>
>>> Rashid Sir, Hope attached will help?
>>>
>>>
>>> On Wed, Apr 2, 2014 at 4:39 PM, Rashid Khan  wrote:
>>>
 Dear All,
 I am using Excel 2010.
 I have attached a sample file with my problem.
  Please see before and after

 Any macro help would be appreciate.
 Regards
 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 of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners 
 and members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google 
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send 
 an email to excel-macros...@googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.

 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>  -- 
>> 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 thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message becau