$$Excel-Macros$$ Need a Macro code for file automatically corrupt after a specific date

[Rohit Badola]

Hi Experts 



i need a vba macro code for the excel sheet got corrupt after a specific 
period.



Regards

Rohit Badola 

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need a macro to get consolidated report

[Vaibhav Joshi]

Great.. Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Fri, Oct 17, 2014 at 1:42 AM, Ujjwal Desai  wrote:

> Thanks Vaibhav !!!
>
>
> Your file is working perfectly matching with my requirement.
>
> --
> 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.

Re: $$Excel-Macros$$ Need a macro to get consolidated report

[Ujjwal Desai]

Thanks Vaibhav !!!


Your file is working perfectly matching with my requirement.

-- 
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$$ Need a macro to get consolidated report

[Vaibhav Joshi]

hey

somehow not able to take time in preparing macro for you, emantime you can
use this code to consol your files & do manually PVT.

Run macro & select folder to import data directly...

Hope this helps // Cheers

+
*I did not do this for you. God is here working through me for you.*

On Tue, Oct 14, 2014 at 1:11 AM, Ujjwal Desai  wrote:

> Hello
>
> i have attached three files along with sample consolidated (output) file.
>
> The expected consolidated (output) file should generate report from
> specified folder on weekly & Monthly cycle.
>
> Thanks,
> Ujjwal
>
> On Monday, October 13, 2014 5:31:37 PM UTC+5:30, Vabz wrote:
>>
>> can you share sample for conso file too..
>>
>> +
>> *I did not do this for you. God is here working through me for you.*
>>
>> On Mon, Oct 13, 2014 at 1:27 AM, Ujjwal Desai  wrote:
>>
>>> Hello ,
>>>
>>> I am in need of a macro which will help me to get a consolidated report
>>> of daily data saved in the folder.
>>>
>>> Requirement :
>>>
>>> 1.Need a consolidated report of each excel file saved in a particular
>>> folder (Tab "Workflow").
>>> 2.Also report should get automatic pivot option once all the data are
>>> consolidated from the different file.
>>>
>>> Note : Data to be consolidated for tab workflow only in each excel file
>>> (sample attached)
>>>
>>> Thanks,
>>> Ujjwal
>>>
>>> --
>>> 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+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

Re: $$Excel-Macros$$ Need a macro to get consolidated report

[Vaibhav Joshi]

can you share sample for conso file too..

+
*I did not do this for you. God is here working through me for you.*

On Mon, Oct 13, 2014 at 1:27 AM, Ujjwal Desai  wrote:

> Hello ,
>
> I am in need of a macro which will help me to get a consolidated report of
> daily data saved in the folder.
>
> Requirement :
>
> 1.Need a consolidated report of each excel file saved in a particular
> folder (Tab "Workflow").
> 2.Also report should get automatic pivot option once all the data are
> consolidated from the different file.
>
> Note : Data to be consolidated for tab workflow only in each excel file
> (sample attached)
>
> Thanks,
> Ujjwal
>
> --
> 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.

Re: $$Excel-Macros$$ Need a Macro to find Variable Cost

[Shaik Waheed]

Thanks Mahesh & Vaibhav,

Its working fine :)

Thanks,
Waheed
On Tue, Sep 9, 2014 at 11:27 AM, Mahesh Patil  wrote:

> Hi,
> PFA
>
>
> On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed  wrote:
>
>> Hi friends,
>>
>> I need your help to create a macro, its motive is to find out the
>> variable cost of physicians >4000.
>>
>> Attached is the sample data for your reference.
>>
>> Thanks in advance.
>>
>> Waheed
>>
>> --
>> 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.

Re: $$Excel-Macros$$ Need a Macro to find Variable Cost

[Mahesh Patil]

Hi,
PFA


On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed  wrote:

> Hi friends,
>
> I need your help to create a macro, its motive is to find out the variable
> cost of physicians >4000.
>
> Attached is the sample data for your reference.
>
> Thanks in advance.
>
> Waheed
>
> --
> 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.


Macro_Variable Cost .xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Need a Macro to find Variable Cost

[Vaibhav Joshi]

Hi

Click blue button to run macro..

Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed  wrote:

> Hi friends,
>
> I need your help to create a macro, its motive is to find out the variable
> cost of physicians >4000.
>
> Attached is the sample data for your reference.
>
> Thanks in advance.
>
> Waheed
>
> --
> 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.


Macro ph cost.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Need a Macro to find Variable Cost

[Shaik Waheed]

Hi friends,

I need your help to create a macro, its motive is to find out the variable
cost of physicians >4000.

Attached is the sample data for your reference.

Thanks in advance.

Waheed

-- 
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.


Macro.xlsx
Description: MS-Excel 2007 spreadsheet

RE: $$Excel-Macros$$ Need a macro to open & copy data from a given path

[Ravinder]

PFA, first select paths.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kartik Dale
Sent: Tuesday, December 17, 2013 1:54 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need a macro to open & copy data from a given path

 

Hello Experts, 

 

I need a macro to open a particular folder from excel and should copy the
file name & sheet name & A1 value from each sheet. PFA

 

Thanks
Kartik 

-- 
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/groups/opt_out.

-- 
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/groups/opt_out.


extractvalues from diff path.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Need a macro to open & copy data from a given path

[Kartik Dale]

Hello Experts,



I need a macro to open a particular folder from excel and should copy the
file name & sheet name & A1 value from each sheet. PFA


Thanks
Kartik

-- 
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/groups/opt_out.


Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Need a macro to copy cells based upon a values in other cell.

[Best Of Luck]

hi,
Happy new  year,
 
I need a macro that would copy  cells  based upon values in other cells. I 
am using Excel 10.
I have a worksbook that has about 20 worksheets in it. Each of these 
worksheets has 2 columns A8:A108 & B8:B108.. I want a macro that would do 
the following:

   1. Select the activesheet & read the values in the source columns 
   B8:B108 and if there are no corrosponding values in the target columns 
A8:A108  to copy cells  from  the source B8:B108 to target A8:A108 and 
   clear the contents of source cells B8:B108 .
   2.  But if there are values in the target cells A8:A108 to leave the 
   values in those cells alone  and still clear the contents of source cells 
   B8:B108 but  Insert a comment saying "Old File" in the corrosponding  
   target cells A8:A108 .

 
 
Both source cells B8:B108  & target  cells A8:A108 are formated as text,
 
thanks...

-- 
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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

Thanks a lot Ashish, this is what exactly what i am looking.

I small addition required, Once the Formula is placed and formula resulted
converted to % format, the value should highlight in red font if the value
is more than > 10%  only for that result row.

Is this possible?

On Tue, Dec 11, 2012 at 10:57 PM, ashish koul  wrote:

> try the attachment
>
> paste the full path of files in column A and run the macro
>
> Regards
> Ashish
>
>
>
>
> On Tue, Dec 11, 2012 at 12:56 PM, Puttu *  wrote:
>
>> please help on this request..
>>
>>
>> On Mon, Dec 10, 2012 at 6:46 PM, Puttu *  wrote:
>>
>>> Any update experts?
>>>
>>>
>>> On Mon, Dec 10, 2012 at 2:02 PM, Puttu *  wrote:
>>>
 Thanks for your response David,

 Sorry If I wasn't clear. Below is the answer for your questions.
 Attached is the reports and master excel how i am expecting.
 Let me know if you need any other details
  On Mon, Dec 10, 2012 at 12:52 PM, David Grugeon 
 wrote:

> Insufficient information provided.
>
> You have posted 4 apparently identical workbooks although Report1.xls
> is slightly larger than the others so there must be some difference.  What
> is it? --> *Attached is the new smaple 4 worksheets*
>
> Could you provide a workbook called, say, Result.xls with at least 2
> or the source reports included.  This will give us much more information.
> --> *Final all the 4 or 5 reports data should be saved in new
> worksheet called Master Workbook (Attached is the final result one*
>
> Will the source workbooks always have only 1 sheet called 16.0, or
> will there sometimes be more than one sheet in the workbooks or will the
> sheet names vary?* It will be the same every time*
>
> With regard to requirement 3 *(**3. This procedure should continue
> untile i say no more workbook to use)*.  Computers do not normally
> respond to spoken commands.  Do you want it to process all the files in 
> the
> folder, or do you want a message box to come up after each one with "Do 
> you
> want me to process another?" and yes and no buttons. *--> I need
> message box to popped up for every report Whether I need to process 
> another
> or not*
>
> Are the files to be consolidated in a single directory?  Is it the
> same directory as the summary file (with the code) will be in?  If not 
> what
> is its full path?  --> *Yes all the file in same directory and yes
> result/Master report also should be in same directory*
> Are they the only files in that directory? *Yes*
>
> Full answers to these questions will get us a lot nearer to being able
> to produce some workable code.
>
>
>  Regards
> David Grugeon
>
>
>
> On 10 December 2012 15:54, Puttu *  wrote:
>
>> can any one please...
>>
>> Need a macro to 5 workbook data to paste in single workbook, on one
>> by one in the same sheet
>>
>>
>> On Mon, Dec 10, 2012 at 12:05 AM, Puttu *  wrote:
>>
>>> SOME ONE HELP ME PLS
>>>
>>>
>>> On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:
>>>
 Yogananda thanks for your prompt response.

 My requiements is below

 1. I have more than 5-10 work book in the folder
 2. Macro should open one workbook and copy the data and past it new
 workbook called as master and close the source workbook
 3. Again it should open 2nd workbook and copy and past the data to
 master workbook and close it.
 4. In the same way it should continioue untile i say no more
 workbook for selction
 5. all the workbook data should be pasted in the same Master
 workbook sheet1 one by one below giving the one row space.

 Let me know if you need any help.


 On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
 yogananda.mutha...@gmail.com> wrote:

> Hi,
>
> Please try this if this can work out for u
>
>
>
> On Sat, Dec 8, 2012 at 10:21 PM, Puttu * wrote:
>
>> Experts please help me
>>
>> Need multiple data to pasted in one single workbook
>>
>>
>> On Sat, Dec 8, 2012 at 7:38 PM, Puttu * wrote:
>>
>>> Hi Experts
>>>
>>> I need a macro where i can use multiple workbooks to in single
>>> new workbook
>>>
>>> 1. I have multiple workbook in perticular folder, all that
>>> workbook used range data need to be copied to single work book.
>>> 2. Every single workbook end of the data it should show the
>>> comparasion result formula =(B56-B55)/B55, row back ground coloured 
>>> yellow
>>> and any thing more than >10% should be highlighted in different 
>>> font color
>>

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

please help on this request..

On Mon, Dec 10, 2012 at 6:46 PM, Puttu *  wrote:

> Any update experts?
>
>
> On Mon, Dec 10, 2012 at 2:02 PM, Puttu *  wrote:
>
>> Thanks for your response David,
>>
>> Sorry If I wasn't clear. Below is the answer for your questions. Attached
>> is the reports and master excel how i am expecting.
>> Let me know if you need any other details
>>  On Mon, Dec 10, 2012 at 12:52 PM, David Grugeon wrote:
>>
>>> Insufficient information provided.
>>>
>>> You have posted 4 apparently identical workbooks although Report1.xls is
>>> slightly larger than the others so there must be some difference.  What is
>>> it? --> *Attached is the new smaple 4 worksheets*
>>>
>>> Could you provide a workbook called, say, Result.xls with at least 2 or
>>> the source reports included.  This will give us much more information. -->
>>> *Final all the 4 or 5 reports data should be saved in new worksheet
>>> called Master Workbook (Attached is the final result one*
>>>
>>> Will the source workbooks always have only 1 sheet called 16.0, or will
>>> there sometimes be more than one sheet in the workbooks or will the sheet
>>> names vary?* It will be the same every time*
>>>
>>> With regard to requirement 3 *(**3. This procedure should continue
>>> untile i say no more workbook to use)*.  Computers do not normally
>>> respond to spoken commands.  Do you want it to process all the files in the
>>> folder, or do you want a message box to come up after each one with "Do you
>>> want me to process another?" and yes and no buttons. *--> I need
>>> message box to popped up for every report Whether I need to process another
>>> or not*
>>>
>>> Are the files to be consolidated in a single directory?  Is it the same
>>> directory as the summary file (with the code) will be in?  If not what is
>>> its full path?  --> *Yes all the file in same directory and yes
>>> result/Master report also should be in same directory*
>>> Are they the only files in that directory? *Yes*
>>>
>>> Full answers to these questions will get us a lot nearer to being able
>>> to produce some workable code.
>>>
>>>
>>>  Regards
>>> David Grugeon
>>>
>>>
>>>
>>> On 10 December 2012 15:54, Puttu *  wrote:
>>>
 can any one please...

 Need a macro to 5 workbook data to paste in single workbook, on one by
 one in the same sheet


 On Mon, Dec 10, 2012 at 12:05 AM, Puttu *  wrote:

> SOME ONE HELP ME PLS
>
>
> On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:
>
>> Yogananda thanks for your prompt response.
>>
>> My requiements is below
>>
>> 1. I have more than 5-10 work book in the folder
>> 2. Macro should open one workbook and copy the data and past it new
>> workbook called as master and close the source workbook
>> 3. Again it should open 2nd workbook and copy and past the data to
>> master workbook and close it.
>> 4. In the same way it should continioue untile i say no more workbook
>> for selction
>> 5. all the workbook data should be pasted in the same Master workbook
>> sheet1 one by one below giving the one row space.
>>
>> Let me know if you need any help.
>>
>>
>> On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
>> yogananda.mutha...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> Please try this if this can work out for u
>>>
>>>
>>>
>>> On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:
>>>
 Experts please help me

 Need multiple data to pasted in one single workbook


 On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:

> Hi Experts
>
> I need a macro where i can use multiple workbooks to in single new
> workbook
>
> 1. I have multiple workbook in perticular folder, all that
> workbook used range data need to be copied to single work book.
> 2. Every single workbook end of the data it should show the
> comparasion result formula =(B56-B55)/B55, row back ground coloured 
> yellow
> and any thing more than >10% should be highlighted in different font 
> color
> 3. This procedure should continue untile i say no more workbook to
> use
>
>
>
> Attached is the sample report with one example
>
> Any help is much appreciated.
>
> --
> Putta
>
> --
> 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 r

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

Yogananda thanks for your prompt response.

My requiements is below

1. I have more than 5-10 work book in the folder
2. Macro should open one workbook and copy the data and past it new
workbook called as master and close the source workbook
3. Again it should open 2nd workbook and copy and past the data to master
workbook and close it.
4. In the same way it should continioue untile i say no more workbook for
selction
5. all the workbook data should be pasted in the same Master workbook
sheet1 one by one below giving the one row space.

Let me know if you need any help.


On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
yogananda.mutha...@gmail.com> wrote:

> Hi,
>
> Please try this if this can work out for u
>
>
>
> On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:
>
>> Experts please help me
>>
>> Need multiple data to pasted in one single workbook
>>
>>
>> On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:
>>
>>> Hi Experts
>>>
>>> I need a macro where i can use multiple workbooks to in single new
>>> workbook
>>>
>>> 1. I have multiple workbook in perticular folder, all that workbook used
>>> range data need to be copied to single work book.
>>> 2. Every single workbook end of the data it should show the comparasion
>>> result formula =(B56-B55)/B55, row back ground coloured yellow and any
>>> thing more than >10% should be highlighted in different font color
>>> 3. This procedure should continue untile i say no more workbook to use
>>>
>>>
>>>
>>> Attached is the sample report with one example
>>>
>>> Any help is much appreciated.
>>>
>>> --
>>> Putta
>>>
>>> --
>>> 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 post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Putta
>>
>> --
>> 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 post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
>
>
>
> Regards
> Yogananda Muthaiah
> Ph : 973 123 7267
>
>  --
> 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://gr

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

Any update experts?

On Mon, Dec 10, 2012 at 2:02 PM, Puttu *  wrote:

> Thanks for your response David,
>
> Sorry If I wasn't clear. Below is the answer for your questions. Attached
> is the reports and master excel how i am expecting.
> Let me know if you need any other details
>  On Mon, Dec 10, 2012 at 12:52 PM, David Grugeon wrote:
>
>> Insufficient information provided.
>>
>> You have posted 4 apparently identical workbooks although Report1.xls is
>> slightly larger than the others so there must be some difference.  What is
>> it? --> *Attached is the new smaple 4 worksheets*
>>
>> Could you provide a workbook called, say, Result.xls with at least 2 or
>> the source reports included.  This will give us much more information. -->
>> *Final all the 4 or 5 reports data should be saved in new worksheet
>> called Master Workbook (Attached is the final result one*
>>
>> Will the source workbooks always have only 1 sheet called 16.0, or will
>> there sometimes be more than one sheet in the workbooks or will the sheet
>> names vary?* It will be the same every time*
>>
>> With regard to requirement 3 *(**3. This procedure should continue
>> untile i say no more workbook to use)*.  Computers do not normally
>> respond to spoken commands.  Do you want it to process all the files in the
>> folder, or do you want a message box to come up after each one with "Do you
>> want me to process another?" and yes and no buttons. *--> I need message
>> box to popped up for every report Whether I need to process another or not
>> *
>>
>> Are the files to be consolidated in a single directory?  Is it the same
>> directory as the summary file (with the code) will be in?  If not what is
>> its full path?  --> *Yes all the file in same directory and yes
>> result/Master report also should be in same directory*
>> Are they the only files in that directory? *Yes*
>>
>> Full answers to these questions will get us a lot nearer to being able to
>> produce some workable code.
>>
>>
>>  Regards
>> David Grugeon
>>
>>
>>
>> On 10 December 2012 15:54, Puttu *  wrote:
>>
>>> can any one please...
>>>
>>> Need a macro to 5 workbook data to paste in single workbook, on one by
>>> one in the same sheet
>>>
>>>
>>> On Mon, Dec 10, 2012 at 12:05 AM, Puttu *  wrote:
>>>
 SOME ONE HELP ME PLS


 On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:

> Yogananda thanks for your prompt response.
>
> My requiements is below
>
> 1. I have more than 5-10 work book in the folder
> 2. Macro should open one workbook and copy the data and past it new
> workbook called as master and close the source workbook
> 3. Again it should open 2nd workbook and copy and past the data to
> master workbook and close it.
> 4. In the same way it should continioue untile i say no more workbook
> for selction
> 5. all the workbook data should be pasted in the same Master workbook
> sheet1 one by one below giving the one row space.
>
> Let me know if you need any help.
>
>
> On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
> yogananda.mutha...@gmail.com> wrote:
>
>> Hi,
>>
>> Please try this if this can work out for u
>>
>>
>>
>> On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:
>>
>>> Experts please help me
>>>
>>> Need multiple data to pasted in one single workbook
>>>
>>>
>>> On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:
>>>
 Hi Experts

 I need a macro where i can use multiple workbooks to in single new
 workbook

 1. I have multiple workbook in perticular folder, all that workbook
 used range data need to be copied to single work book.
 2. Every single workbook end of the data it should show the
 comparasion result formula =(B56-B55)/B55, row back ground coloured 
 yellow
 and any thing more than >10% should be highlighted in different font 
 color
 3. This procedure should continue untile i say no more workbook to
 use



 Attached is the sample report with one example

 Any help is much appreciated.

 --
 Putta

 --
 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 al

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[David Grugeon]

Insufficient information provided.

You have posted 4 apparently identical workbooks although Report1.xls is
slightly larger than the others so there must be some difference.  What is
it?

Could you provide a workbook called, say, Result.xls with at least 2 or the
source reports included.  This will give us much more information.

Will the source workbooks always have only 1 sheet called 16.0, or will
there sometimes be more than one sheet in the workbooks or will the sheet
names vary?

With regard to requirement 3 *(**3. This procedure should continue untile i
say no more workbook to use)*.  Computers do not normally respond to spoken
commands.  Do you want it to process all the files in the folder, or do you
want a message box to come up after each one with "Do you want me to
process another?" and yes and no buttons.

Are the files to be consolidated in a single directory?  Is it the same
directory as the summary file (with the code) will be in?  If not what is
its full path?
Are they the only files in that directory?

Full answers to these questions will get us a lot nearer to being able to
produce some workable code.


Regards
David Grugeon



On 10 December 2012 15:54, Puttu *  wrote:

> can any one please...
>
> Need a macro to 5 workbook data to paste in single workbook, on one by one
> in the same sheet
>
>
> On Mon, Dec 10, 2012 at 12:05 AM, Puttu *  wrote:
>
>> SOME ONE HELP ME PLS
>>
>>
>> On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:
>>
>>> Yogananda thanks for your prompt response.
>>>
>>> My requiements is below
>>>
>>> 1. I have more than 5-10 work book in the folder
>>> 2. Macro should open one workbook and copy the data and past it new
>>> workbook called as master and close the source workbook
>>> 3. Again it should open 2nd workbook and copy and past the data to
>>> master workbook and close it.
>>> 4. In the same way it should continioue untile i say no more workbook
>>> for selction
>>> 5. all the workbook data should be pasted in the same Master workbook
>>> sheet1 one by one below giving the one row space.
>>>
>>> Let me know if you need any help.
>>>
>>>
>>> On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
>>> yogananda.mutha...@gmail.com> wrote:
>>>
 Hi,

 Please try this if this can work out for u



 On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:

> Experts please help me
>
> Need multiple data to pasted in one single workbook
>
>
> On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:
>
>> Hi Experts
>>
>> I need a macro where i can use multiple workbooks to in single new
>> workbook
>>
>> 1. I have multiple workbook in perticular folder, all that workbook
>> used range data need to be copied to single work book.
>> 2. Every single workbook end of the data it should show the
>> comparasion result formula =(B56-B55)/B55, row back ground coloured 
>> yellow
>> and any thing more than >10% should be highlighted in different font 
>> color
>> 3. This procedure should continue untile i say no more workbook to use
>>
>>
>>
>> Attached is the sample report with one example
>>
>> Any help is much appreciated.
>>
>> --
>> Putta
>>
>> --
>> 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 post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en
>> .
>>
>>
>>
>
>
>
> --
> Putta
>
> --
> 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 

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

any help

Moderator could you please help on this

On Mon, Dec 10, 2012 at 11:24 AM, Puttu *  wrote:

> can any one please...
>
> Need a macro to 5 workbook data to paste in single workbook, on one by one
> in the same sheet
>
>
> On Mon, Dec 10, 2012 at 12:05 AM, Puttu *  wrote:
>
>> SOME ONE HELP ME PLS
>>
>>
>> On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:
>>
>>> Yogananda thanks for your prompt response.
>>>
>>> My requiements is below
>>>
>>> 1. I have more than 5-10 work book in the folder
>>> 2. Macro should open one workbook and copy the data and past it new
>>> workbook called as master and close the source workbook
>>> 3. Again it should open 2nd workbook and copy and past the data to
>>> master workbook and close it.
>>> 4. In the same way it should continioue untile i say no more workbook
>>> for selction
>>> 5. all the workbook data should be pasted in the same Master workbook
>>> sheet1 one by one below giving the one row space.
>>>
>>> Let me know if you need any help.
>>>
>>>
>>> On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
>>> yogananda.mutha...@gmail.com> wrote:
>>>
 Hi,

 Please try this if this can work out for u



 On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:

> Experts please help me
>
> Need multiple data to pasted in one single workbook
>
>
> On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:
>
>> Hi Experts
>>
>> I need a macro where i can use multiple workbooks to in single new
>> workbook
>>
>> 1. I have multiple workbook in perticular folder, all that workbook
>> used range data need to be copied to single work book.
>> 2. Every single workbook end of the data it should show the
>> comparasion result formula =(B56-B55)/B55, row back ground coloured 
>> yellow
>> and any thing more than >10% should be highlighted in different font 
>> color
>> 3. This procedure should continue untile i say no more workbook to use
>>
>>
>>
>> Attached is the sample report with one example
>>
>> Any help is much appreciated.
>>
>> --
>> Putta
>>
>> --
>> 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 post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en
>> .
>>
>>
>>
>
>
>
> --
> Putta
>
> --
> 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



 --



 Regards
 Yogananda Muthaiah
 Ph : 973 123 7267

  --
 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 Hel

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

can any one please...

Need a macro to 5 workbook data to paste in single workbook, on one by one
in the same sheet

On Mon, Dec 10, 2012 at 12:05 AM, Puttu *  wrote:

> SOME ONE HELP ME PLS
>
>
> On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:
>
>> Yogananda thanks for your prompt response.
>>
>> My requiements is below
>>
>> 1. I have more than 5-10 work book in the folder
>> 2. Macro should open one workbook and copy the data and past it new
>> workbook called as master and close the source workbook
>> 3. Again it should open 2nd workbook and copy and past the data to master
>> workbook and close it.
>> 4. In the same way it should continioue untile i say no more workbook for
>> selction
>> 5. all the workbook data should be pasted in the same Master workbook
>> sheet1 one by one below giving the one row space.
>>
>> Let me know if you need any help.
>>
>>
>> On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
>> yogananda.mutha...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> Please try this if this can work out for u
>>>
>>>
>>>
>>> On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:
>>>
 Experts please help me

 Need multiple data to pasted in one single workbook


 On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:

> Hi Experts
>
> I need a macro where i can use multiple workbooks to in single new
> workbook
>
> 1. I have multiple workbook in perticular folder, all that workbook
> used range data need to be copied to single work book.
> 2. Every single workbook end of the data it should show the
> comparasion result formula =(B56-B55)/B55, row back ground coloured yellow
> and any thing more than >10% should be highlighted in different font color
> 3. This procedure should continue untile i say no more workbook to use
>
>
>
> Attached is the sample report with one example
>
> Any help is much appreciated.
>
> --
> Putta
>
> --
> 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



 --
 Putta

 --
 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 post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.



>>>
>>>
>>>
>>> --
>>>
>>>
>>>
>>> Regards
>>> Yogananda Muthaiah
>>> Ph : 973 123 7267
>>>
>>>  --
>>> 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 r

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

SOME ONE HELP ME PLS

On Sun, Dec 9, 2012 at 4:42 PM, Puttu *  wrote:

> Yogananda thanks for your prompt response.
>
> My requiements is below
>
> 1. I have more than 5-10 work book in the folder
> 2. Macro should open one workbook and copy the data and past it new
> workbook called as master and close the source workbook
> 3. Again it should open 2nd workbook and copy and past the data to master
> workbook and close it.
> 4. In the same way it should continioue untile i say no more workbook for
> selction
> 5. all the workbook data should be pasted in the same Master workbook
> sheet1 one by one below giving the one row space.
>
> Let me know if you need any help.
>
>
> On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah <
> yogananda.mutha...@gmail.com> wrote:
>
>> Hi,
>>
>> Please try this if this can work out for u
>>
>>
>>
>> On Sat, Dec 8, 2012 at 10:21 PM, Puttu *  wrote:
>>
>>> Experts please help me
>>>
>>> Need multiple data to pasted in one single workbook
>>>
>>>
>>> On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:
>>>
 Hi Experts

 I need a macro where i can use multiple workbooks to in single new
 workbook

 1. I have multiple workbook in perticular folder, all that workbook
 used range data need to be copied to single work book.
 2. Every single workbook end of the data it should show the comparasion
 result formula =(B56-B55)/B55, row back ground coloured yellow and any
 thing more than >10% should be highlighted in different font color
 3. This procedure should continue untile i say no more workbook to use



 Attached is the sample report with one example

 Any help is much appreciated.

 --
 Putta

 --
 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 post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.



>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>> --
>>> 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 post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>
>>
>> --
>>
>>
>>
>> Regards
>> Yogananda Muthaiah
>> Ph : 973 123 7267
>>
>>  --
>> 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 Googl

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

[Puttu *]

Experts please help me

Need multiple data to pasted in one single workbook

On Sat, Dec 8, 2012 at 7:38 PM, Puttu *  wrote:

> Hi Experts
>
> I need a macro where i can use multiple workbooks to in single new workbook
>
> 1. I have multiple workbook in perticular folder, all that workbook used
> range data need to be copied to single work book.
> 2. Every single workbook end of the data it should show the comparasion
> result formula =(B56-B55)/B55, row back ground coloured yellow and any
> thing more than >10% should be highlighted in different font color
> 3. This procedure should continue untile i say no more workbook to use
>
>
>
> Attached is the sample report with one example
>
> Any help is much appreciated.
>
> --
> Putta
>
> --
> 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
Putta

-- 
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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Need a Macro

[NOORAIN ANSARI]

Dear NRao,

Please try it...

Change path as per your requirement and Select Tools-Reference-Microsoft
Scripting Runtime before run the macro

Sub Consodilate_workbook()
Dim wb As Workbook
Dim rng As Range
Dim fil As File
Dim i As Integer
Set wb = ThisWorkbook
Dim fld As Folder
Dim FSO As FileSystemObject
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.DisplayAlerts = False
Set FSO = New FileSystemObject
Set fld = FSO.GetFolder("D:\FSO\")
For Each fil In fld.Files
i = wb.Sheets(1).Cells(Rows.Count, "A").End(xlUp).Row + 1
Workbooks.Open fil
'For Heading
ActiveWorkbook.Sheets(1).Range("A1:C1").Copy wb.Sheets(3).Cells(1, 1)
ActiveWorkbook.Sheets(2).Range("A2:C" &
ActiveWorkbook.Sheets(1).Cells(Rows.Count, "c").End(xlUp).Row).Copy
wb.Sheets(1).Cells(i, 1)
ActiveWorkbook.Save
ActiveWorkbook.Close
Next fil
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
Application.DisplayAlerts = True

End Sub


On Tue, Jul 24, 2012 at 10:58 AM, NRao Mynampati
wrote:

> Hi Team,
>
> I have a morethan 10 workbooks in a folder , I need a macro for
> consoldate all workbooks into single workbook.
>
> 1) some of the sheets have morethan 70,000 recoreds (rows) filled
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>


-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.blogspot.com
http://accesssqclinic.blogspot.in/

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Need a Macro

[NRao Mynampati]

Hi Team,

I have a morethan 10 workbooks in a folder , I need a macro for
consoldate all workbooks into single workbook.

1) some of the sheets have morethan 70,000 recoreds (rows) filled

-- 
-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)

[vishal angre]

see attached file

On Wed, Jul 4, 2012 at 11:53 AM, vijay yadav
wrote:

> Hi,
>
> how to conditional format for a changed alpahnumerical cell  value? is it
> possible?
>
> if i have a filled worksheet where
>
>  tb3 is value in cell A1 and
>
> *tb4 is value in cell A2*
> and
>
>  I change cell *A1 value to tb4*
>
> the "macro" would
>
> *change only cell A1 background*.
> It *shouldn'*t change cell A2 value
>
>
> I think this is not possible with conditional formatting.
> conditional formatting will highlight all cells with some condition
> i want to highlight only cell which has a changed value...
>
>
> Please help me in this regard
>
> Best regards
> Vijay yadav
>
> On Wednesday, 4 July 2012 11:04:32 UTC+5:30, Annu wrote:
>
>> Dear Vijay,
>>
>> For this you may use conditional formatting. There is no need to make
>> macro.
>>
>>
>> Thanks & Regards,
>> Gawli Anil
>>
>> On Wed, Jul 4, 2012 at 11:00 AM, vijay yadav <> wrote:
>>
>>> Hi Members / Experts
>>>
>>> I need a macro to change the background color of  a cell as soon as i
>>> change the value (alphanumeric).
>>> The background is originally yellow and as soon  I change a value it
>>> should become no fill (or white ).
>>>
>>> Sometimes the changed value might be same as previous value ..in that
>>> case what should be done so that the
>>> background color changes to white ?
>>> like should I enter the cell and write the value again or any
>>> other option
>>>
>>> Please help me in this regard
>>>
>>> Vijay yadav
>>>
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>> --**--**
>>> --**
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to excel-macros+unsubscribe@**
>>> googlegroups.com 
>>
>>
>>
>>
>> --
>> Thanks & Regards,
>> Gawli Anil Narayan
>> Software Developer,
>> Abacus Software Services Pvt Ltd
>>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With Regards,
*Vishal K. Angre*
E-mail :  visha...@gmail.com
 vishal.k.an...@gmail.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)

[vijay yadav]

Hi,
 
how to conditional format for a changed alpahnumerical cell  value? is it 
possible?
 
if i have a filled worksheet where
 
 tb3 is value in cell A1 and 
 
*tb4 is value in cell A2*
and
 
 I change cell *A1 value to tb4* 
 
the "macro" would 
 
*change only cell A1 background*.
It *shouldn'*t change cell A2 value
 
 
I think this is not possible with conditional formatting.
conditional formatting will highlight all cells with some condition
i want to highlight only cell which has a changed value...
 
 
Please help me in this regard
 
Best regards
Vijay yadav

On Wednesday, 4 July 2012 11:04:32 UTC+5:30, Annu wrote:

> Dear Vijay,
>  
> For this you may use conditional formatting. There is no need to make 
> macro.
>  
>  
> Thanks & Regards,
> Gawli Anil
>
> On Wed, Jul 4, 2012 at 11:00 AM, vijay yadav <> wrote:
>
>> Hi Members / Experts
>>  
>> I need a macro to change the background color of  a cell as soon as i 
>> change the value (alphanumeric).
>> The background is originally yellow and as soon  I change a value it 
>> should become no fill (or white ).
>>  
>> Sometimes the changed value might be same as previous value ..in that 
>> case what should be done so that the
>> background color changes to white ? 
>> like should I enter the cell and write the value again or any other option
>>  
>> Please help me in this regard
>>  
>> Vijay yadav
>>  
>>
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 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) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>>  
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>  
>> To unsubscribe, send a blank email to 
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> -- 
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)

[Anil Gawli]

Dear Vijay,

For this you may use conditional formatting. There is no need to make macro.


Thanks & Regards,
Gawli Anil

On Wed, Jul 4, 2012 at 11:00 AM, vijay yadav <> wrote:

> Hi Members / Experts
>
> I need a macro to change the background color of  a cell as soon as i
> change the value (alphanumeric).
> The background is originally yellow and as soon  I change a value it
> should become no fill (or white ).
>
> Sometimes the changed value might be same as previous value ..in that case
> what should be done so that the
> background color changes to white ?
> like should I enter the cell and write the value again or any other option
>
> Please help me in this regard
>
> Vijay yadav
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)

[vijay yadav]

Hi Members / Experts
 
I need a macro to change the background color of  a cell as soon as i 
change the value (alphanumeric).
The background is originally yellow and as soon  I change a value it should 
become no fill (or white ).
 
Sometimes the changed value might be same as previous value ..in that case 
what should be done so that the
background color changes to white ? 
like should I enter the cell and write the value again or any other option
 
Please help me in this regard
 
Vijay yadav
 

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ need a macro

[Maries]

*For, Compaign:
=INDEX($A$4:$A$80,CEILING(COUNTA($E$3:E3)/COUNTA($A$4:$A$80),1))

For, Location: =INDEX($B$4:$B$80,COUNTIF($E$4:E4,E4))*



  Oops. Deleted too many rows on test sheet
>>
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Amresh Maurya 
>> *Sent:* Monday, March 26, 2012 7:02 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ need a macro
>>
>> Hi Friends,
>>
>> We have 77 campaign and 77 city lists , now what i need , each campaign
>> has 77 cities.
>>
>> We have attached file for reference. kindly check
>>
>> Regards
>> Amresh
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ need a macro

[Amresh Maurya]

exactly...

thank you so much..

Regards
Amresh



On Mon, Mar 26, 2012 at 5:35 AM, BNS kumar  wrote:

> Hope this file serve your needs
>
> Regards
> Kumar
>
>
> On Mon, Mar 26, 2012 at 5:32 PM, Amresh Maurya 
> wrote:
>
>> Hi Friends,
>>
>> We have 77 campaign and 77 city lists , now what i need , each campaign
>> has 77 cities.
>>
>> We have attached file for reference. kindly check
>>
>> Regards
>> Amresh
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ need a macro

[BNS kumar]

Hope this file serve your needs

Regards
Kumar

On Mon, Mar 26, 2012 at 5:32 PM, Amresh Maurya wrote:

> Hi Friends,
>
> We have 77 campaign and 77 city lists , now what i need , each campaign
> has 77 cities.
>
> We have attached file for reference. kindly check
>
> Regards
> Amresh
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Test Macros.xlsm
Description: Binary data

$$Excel-Macros$$ need a macro

[Amresh Maurya]

Hi Friends,

We have 77 campaign and 77 city lists , now what i need , each campaign has
77 cities.

We have attached file for reference. kindly check

Regards
Amresh

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Test Macros.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Need a macro for Out look

[NRao Mynampati]

Dear Team,

I want a macro for message names export to excel with  received dates.


thanks in advance
Simha

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need A Macro To Move Rows

[John A. Smith]

Wow, thanks Sam.  When I was trying this myself, I started down this
approach and couldn't make it work.  Thanks for the lesson.

John



On Mon, Feb 6, 2012 at 3:06 PM, Sam Mathai Chacko wrote:

> If your rows go in to the thousands, using autofilter will add a bit more
> (~40%) efficiency
>
> Sub Consolidator()
>
> Application.ScreenUpdating = 0
> With Range("A2", Cells(Rows.Count, "J").End(xlUp))
> .AutoFilter 7, "Pickup"
> .Offset(1, 10).Resize(.Rows.Count - 1,
> 10).SpecialCells(12).FormulaR1C1 = "=R[1]C[-10]"
> .Rows(1).Offset(, 10).FormulaR1C1 = "=RC[-10]"
> .AutoFilter
> With .Offset(, 10).Resize(, 10)
> .Value = .Value
> .Offset(, -10).Copy
> .PasteSpecial xlPasteFormats
> .Columns(1).SpecialCells(4).EntireRow.Delete
> End With
> End With
> Application.ScreenUpdating = 1
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Mon, Feb 6, 2012 at 9:21 PM, dguillett1  wrote:
>
>>   Glad to help
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* John A. Smith 
>> *Sent:* Monday, February 06, 2012 9:11 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Need A Macro To Move Rows
>>
>>  Thanks again for your assistance Don, your help is very much
>> appreciated.
>>
>> John
>>
>> On Mon, Feb 6, 2012 at 10:03 AM, dguillett1  wrote:
>>
>>>   Place in a module and save the file as macro enabled. xls or .xlsM
>>> ‘==
>>> Option Explicit
>>> Sub lineemupSAS()
>>> Dim i As Long
>>> Application.ScreenUpdating = False
>>> For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
>>>   Cells(i, 1).Resize(, 10).Copy Cells(i - 1, "K")
>>>   Rows(i).Delete
>>> Next i
>>> Columns.AutoFit
>>> Application.ScreenUpdating = True
>>> End Sub
>>> ‘=
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* John A. Smith 
>>> *Sent:* Monday, February 06, 2012 8:21 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Need A Macro To Move Rows
>>>
>>>   Thank you for your ongoing Excel help.  I need a macro to correct a
>>> download issue.  The download places one event on two lines in 10 columns.
>>> I need the second line of every event moved up next the first part of the
>>> event, thereby doubling the number of columns but cutting the number of
>>> rows in half.
>>>
>>> I have detailed an example in the attached file.  Thank you again for
>>> all your help and teaching.
>>>
>>> John
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> sign

Re: $$Excel-Macros$$ Need A Macro To Move Rows

[dguillett1]

Nice


Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Monday, February 06, 2012 2:06 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Need A Macro To Move Rows

If your rows go in to the thousands, using autofilter will add a bit more 
(~40%) efficiency

Sub Consolidator()

Application.ScreenUpdating = 0
With Range("A2", Cells(Rows.Count, "J").End(xlUp))
.AutoFilter 7, "Pickup"
.Offset(1, 10).Resize(.Rows.Count - 1, 10).SpecialCells(12).FormulaR1C1 
= "=R[1]C[-10]"
.Rows(1).Offset(, 10).FormulaR1C1 = "=RC[-10]"
.AutoFilter
With .Offset(, 10).Resize(, 10)
.Value = .Value
.Offset(, -10).Copy
.PasteSpecial xlPasteFormats
.Columns(1).SpecialCells(4).EntireRow.Delete
End With
End With
Application.ScreenUpdating = 1

End Sub

Regards,

Sam Mathai Chacko


On Mon, Feb 6, 2012 at 9:21 PM, dguillett1  wrote:

  Glad to help

  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: John A. Smith 
  Sent: Monday, February 06, 2012 9:11 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Need A Macro To Move Rows

  Thanks again for your assistance Don, your help is very much appreciated.

  John


  On Mon, Feb 6, 2012 at 10:03 AM, dguillett1  wrote:

Place in a module and save the file as macro enabled. xls or .xlsM
‘==
Option Explicit
Sub lineemupSAS()
Dim i As Long
Application.ScreenUpdating = False
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
  Cells(i, 1).Resize(, 10).Copy Cells(i - 1, "K")
  Rows(i).Delete
Next i
Columns.AutoFit
Application.ScreenUpdating = True
End Sub
‘=
Don Guillett
SalesAid Software
dguille...@gmail.com

From: John A. Smith 
Sent: Monday, February 06, 2012 8:21 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Need A Macro To Move Rows

Thank you for your ongoing Excel help.  I need a macro to correct a 
download issue.  The download places one event on two lines in 10 columns.  I 
need the second line of every event moved up next the first part of the event, 
thereby doubling the number of columns but cutting the number of rows in half.

I have detailed an example in the attached file.  Thank you again for all 
your help and teaching.

John
-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com


  -- 
  FORUM RULES (986+ members already BANNED for violation)
   
  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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  N

Re: $$Excel-Macros$$ Need A Macro To Move Rows

[dguillett1]

Glad to help

Don Guillett
SalesAid Software
dguille...@gmail.com

From: John A. Smith 
Sent: Monday, February 06, 2012 9:11 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Need A Macro To Move Rows

Thanks again for your assistance Don, your help is very much appreciated.

John


On Mon, Feb 6, 2012 at 10:03 AM, dguillett1  wrote:

  Place in a module and save the file as macro enabled. xls or .xlsM
  ‘==
  Option Explicit
  Sub lineemupSAS()
  Dim i As Long
  Application.ScreenUpdating = False
  For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
Cells(i, 1).Resize(, 10).Copy Cells(i - 1, "K")
Rows(i).Delete
  Next i
  Columns.AutoFit
  Application.ScreenUpdating = True
  End Sub
  ‘=
  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: John A. Smith 
  Sent: Monday, February 06, 2012 8:21 AM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ Need A Macro To Move Rows

  Thank you for your ongoing Excel help.  I need a macro to correct a download 
issue.  The download places one event on two lines in 10 columns.  I need the 
second line of every event moved up next the first part of the event, thereby 
doubling the number of columns but cutting the number of rows in half.

  I have detailed an example in the attached file.  Thank you again for all 
your help and teaching.

  John
  -- 
  FORUM RULES (986+ members already BANNED for violation)
   
  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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com

  -- 
  FORUM RULES (986+ members already BANNED for violation)
   
  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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need A Macro To Move Rows

[John A. Smith]

Thanks again for your assistance Don, your help is very much appreciated.

John

On Mon, Feb 6, 2012 at 10:03 AM, dguillett1  wrote:

>   Place in a module and save the file as macro enabled. xls or .xlsM
> ‘==
> Option Explicit
> Sub lineemupSAS()
> Dim i As Long
> Application.ScreenUpdating = False
> For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
>   Cells(i, 1).Resize(, 10).Copy Cells(i - 1, "K")
>   Rows(i).Delete
> Next i
> Columns.AutoFit
> Application.ScreenUpdating = True
> End Sub
> ‘=
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* John A. Smith 
> *Sent:* Monday, February 06, 2012 8:21 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Need A Macro To Move Rows
>
>   Thank you for your ongoing Excel help.  I need a macro to correct a
> download issue.  The download places one event on two lines in 10 columns.
> I need the second line of every event moved up next the first part of the
> event, thereby doubling the number of columns but cutting the number of
> rows in half.
>
> I have detailed an example in the attached file.  Thank you again for all
> your help and teaching.
>
> John
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need A Macro To Move Rows

[dguillett1]

Place in a module and save the file as macro enabled. xls or .xlsM
‘==
Option Explicit
Sub lineemupSAS()
Dim i As Long
Application.ScreenUpdating = False
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
  Cells(i, 1).Resize(, 10).Copy Cells(i - 1, "K")
  Rows(i).Delete
Next i
Columns.AutoFit
Application.ScreenUpdating = True
End Sub
‘=
Don Guillett
SalesAid Software
dguille...@gmail.com

From: John A. Smith 
Sent: Monday, February 06, 2012 8:21 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Need A Macro To Move Rows

Thank you for your ongoing Excel help.  I need a macro to correct a download 
issue.  The download places one event on two lines in 10 columns.  I need the 
second line of every event moved up next the first part of the event, thereby 
doubling the number of columns but cutting the number of rows in half.

I have detailed an example in the attached file.  Thank you again for all your 
help and teaching.

John
-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need a macro to update charts automatically

[NOORAIN ANSARI]

Dear Atul,

Please use below code to update Chart Automatic..
*
Private Sub Workbook_Open()
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
wks.Calculate
Next
Set wks = Nothing
End Sub*

also visit on below web link..

http://spreadsheetpage.com/index.php/tip/update_charts_automatically_when_you_enter_new_data/

-
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 


On Fri, Dec 16, 2011 at 7:59 AM, Atul vishwakarma wrote:

> Hi Friends,
>
> I need a macro to update charts automatically. Attached is sample file.
>
> Thanks!
>
> --
>
> Atul Vishwakarma
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-

-- 
FORUM RULES (934+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need a macro to update charts automatically

[dguillett1]

Please explain your need


Don Guillett
SalesAid Software
dguille...@gmail.com

From: Atul vishwakarma 
Sent: Thursday, December 15, 2011 8:29 PM
To: MS EXCEL AND VBA MACROS 
Subject: $$Excel-Macros$$ Need a macro to update charts automatically

Hi Friends,

I need a macro to update charts automatically. Attached is sample file.

Thanks!

--

Atul Vishwakarma
-- 
FORUM RULES (934+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need a macro to update data from raw file to individual sheets of master

[dguillett1]

Based on seeing your file(s) I offer this macro to be run from the master 
file to add a line on each sheet in the master file

Sub getdailydata()

Workbooks.Open Filename:=InputBox("name of file")
For Each ws In Workbooks("Master.xls").Sheets
lr = ws.Cells(Rows.Count, 2).End(xlUp).Row
Set mf = Sheets("Raw").Columns("b").Find(What:=ws.Name, LookIn:=xlValues, _
  LookAt:=xlWhole, SearchOrder:=xlByRows, 
SearchDirection:=xlNext)

If Not mf Is Nothing Then
 Cells(mf.Row, 1).Resize(, 6).Copy ws.Cells(lr, 2)
 ws.Cells(lr, 1) = Date ' places todays date in col A
End If
Next ws
End Sub



Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Varun

Sent: Sunday, October 23, 2011 10:58 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Need a macro to update data from raw file to 
individual sheets of master


Sorry, but i could not find any way of attaching excel in my mails
here. Could some one please let me know how I should go abot that.

Many thanks.
Varun

On Oct 23, 6:24 pm, "dguillett1"  wrote:

Best to ATTACH your file. Code could be simplified. ie:
last = Cells(Rows.Count, "B").End(xlUp).Row
   For i = last To 1 Step -1
   If (Cells(i, "B").Value) = "ABC" Then
   Cells(i, "A").EntireRow.Delete
   End If
   If (Cells(i, "B").Value) = "XYZ" Then
   Cells(i, "A").EntireRow.Delete
   End If
   If (Cells(i, "B").Value) = "Res" Then
   Cells(i, "A").EntireRow.Delete
   End If
   Next i

could be

For i = Cells(Rows.Count, "B").End(xlUp).Row To 1 Step -1
Select Case UCase(Cells(i, "B"))
   Case Is = "ABC", "XYZ", "RES": Rows(i).Delete
End Select
Next i

Don Guillett
SalesAid Software
dguille...@gmail.com



-Original Message-
From: Varun
Sent: Sunday, October 23, 2011 3:43 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need a macro to update data from raw file to
individual sheets of master

Hi Everyone,

I need a code for the following steps to be enacted

1. Save a backup file with the name counts - date.xls (this will be a
daily file)
2. remove rows with name (column B) matching with name in to be
removed sheet
3. copy value in name field and open the corusponding sheet in the
master
4. once the sheet is active, go to the last row insert current date in
left most collumn and paste the row from raw to master (from Column B)
5. copy the formula in the remailing columns in that sheet from above
6. once updated give a msg = this work is now complete

Conditions -
1. If the sheet does not exist in the master then give an inputbox
informing that we have a new name and asking if a new sheet should be
created or should this be merged with another existing sheet - if user
says yes to new sheet then create a new one with the same headers/
formatting and formulas as the others
2. In the end in the msg box (this work is now complete) it should
contain a summary of unusual events i.e.
A. New name (sheet created)
B. New name (merged with existing sheet)
C. Count for particular name in Column C2 greater than 50 (Name-
column B and count - C2 detail)

I tried my hand on this but got stuck half way. i was not able to find
a way to put condition 3 in the code.

This is really urgentI would be really really really greatful if
someone can help me out here.

Thanks a lot

I have attached a sample file for test and master with this post along
with my code.

Raw file:
ID NAME C1 C2 C3 C4 C5 C6 total
6 ABC 799561 56 345345 234 243 234 1145673
3089 DEF 17 0 0 0 345 0 362
47 GHI 22536 123 0 0 234 2 22895
6895 XYZ 31 0 0 0 453 0 484
6749 NFF 5 65 1 15 5 0 91
74 IJK 122558 511 1 68 11 0 123149
75 KLM 6597 21 0 5 13 0 6636
42 NOP 69969 123 3 12 234 0 70341
103 MON 566278 234 2 17 23 0 566554
76 NND 58586 234 0 23 432 0 59275
31 PLQ 4283 0 0 0 54 0 4337
6325 RST 7 0 0 0 22 0 29
5926 DHE 34 0 0 0 24 0 58
6781 UUT 3 55 23 6 1 0 88
5237 NIQ 20100 41 64 6 817 0 21028
101 IJP 8063 2 0 0 65 0 8130

To be removed
ID NAME
6 ABC
6895 XYZ
345 RES
101 IJP

Master
Record Date ID NAME C1 C2 C3 C4 C5 C6 total F1 F2 F3 F4 F5 FW1 FW2 FW3
FW4
3-Jan-113089 DEF 889 0 15 0 2 0 906 906 889 2 15 1795
891 17 1810 2686

(similar sheet for all the other values in name column)

Code:
Sub Counts_upload()
'
' Counts_upload Macro
' This macro is used to load running counts from raw to master
workbook
' Keyboard Shortcut: Ctrl+Shift+A
   Workbooks("test").Sheets("raw").Select
Range("A1").Select
Dim i As Integer
last = Cells(Rows.Count, "B").End(xlUp).Row
For i = last To 1 Step -1
If (Cells(i, "B").Value) = "ABC" Then
Cells(i, "A").EntireRow.Delete
End If
If (Cells(i, "B&

Re: $$Excel-Macros$$ Need a macro to update data from raw file to individual sheets of master

[Sam Mathai Chacko]

Click on reply to this post via your gmail account. And then upload the file
as you would normally in any mail.

Sam

On Mon, Oct 24, 2011 at 9:28 AM, Varun  wrote:

> Sorry, but i could not find any way of attaching excel in my mails
> here. Could some one please let me know how I should go abot that.
>
> Many thanks.
> Varun
>
> On Oct 23, 6:24 pm, "dguillett1"  wrote:
> > Best to ATTACH your file. Code could be simplified. ie:
> > last = Cells(Rows.Count, "B").End(xlUp).Row
> >For i = last To 1 Step -1
> >If (Cells(i, "B").Value) = "ABC" Then
> >Cells(i, "A").EntireRow.Delete
> >End If
> >If (Cells(i, "B").Value) = "XYZ" Then
> >Cells(i, "A").EntireRow.Delete
> >End If
> >If (Cells(i, "B").Value) = "Res" Then
> >Cells(i, "A").EntireRow.Delete
> >End If
> >Next i
> >
> > could be
> >
> > For i = Cells(Rows.Count, "B").End(xlUp).Row To 1 Step -1
> > Select Case UCase(Cells(i, "B"))
> >Case Is = "ABC", "XYZ", "RES": Rows(i).Delete
> > End Select
> > Next i
> >
> > Don Guillett
> > SalesAid Software
> > dguille...@gmail.com
> >
> >
> >
> > -Original Message-
> > From: Varun
> > Sent: Sunday, October 23, 2011 3:43 AM
> > To: MS EXCEL AND VBA MACROS
> > Subject: $$Excel-Macros$$ Need a macro to update data from raw file to
> > individual sheets of master
> >
> > Hi Everyone,
> >
> > I need a code for the following steps to be enacted
> >
> > 1. Save a backup file with the name counts - date.xls (this will be a
> > daily file)
> > 2. remove rows with name (column B) matching with name in to be
> > removed sheet
> > 3. copy value in name field and open the corusponding sheet in the
> > master
> > 4. once the sheet is active, go to the last row insert current date in
> > left most collumn and paste the row from raw to master (from Column B)
> > 5. copy the formula in the remailing columns in that sheet from above
> > 6. once updated give a msg = this work is now complete
> >
> > Conditions -
> > 1. If the sheet does not exist in the master then give an inputbox
> > informing that we have a new name and asking if a new sheet should be
> > created or should this be merged with another existing sheet - if user
> > says yes to new sheet then create a new one with the same headers/
> > formatting and formulas as the others
> > 2. In the end in the msg box (this work is now complete) it should
> > contain a summary of unusual events i.e.
> > A. New name (sheet created)
> > B. New name (merged with existing sheet)
> > C. Count for particular name in Column C2 greater than 50 (Name-
> > column B and count - C2 detail)
> >
> > I tried my hand on this but got stuck half way. i was not able to find
> > a way to put condition 3 in the code.
> >
> > This is really urgentI would be really really really greatful if
> > someone can help me out here.
> >
> > Thanks a lot
> >
> > I have attached a sample file for test and master with this post along
> > with my code.
> >
> > Raw file:
> > ID NAME C1 C2 C3 C4 C5 C6 total
> > 6 ABC 799561 56 345345 234 243 234 1145673
> > 3089 DEF 17 0 0 0 345 0 362
> > 47 GHI 22536 123 0 0 234 2 22895
> > 6895 XYZ 31 0 0 0 453 0 484
> > 6749 NFF 5 65 1 15 5 0 91
> > 74 IJK 122558 511 1 68 11 0 123149
> > 75 KLM 6597 21 0 5 13 0 6636
> > 42 NOP 69969 123 3 12 234 0 70341
> > 103 MON 566278 234 2 17 23 0 566554
> > 76 NND 58586 234 0 23 432 0 59275
> > 31 PLQ 4283 0 0 0 54 0 4337
> > 6325 RST 7 0 0 0 22 0 29
> > 5926 DHE 34 0 0 0 24 0 58
> > 6781 UUT 3 55 23 6 1 0 88
> > 5237 NIQ 20100 41 64 6 817 0 21028
> > 101 IJP 8063 2 0 0 65 0 8130
> >
> > To be removed
> > ID NAME
> > 6 ABC
> > 6895 XYZ
> > 345 RES
> > 101 IJP
> >
> > Master
> > Record Date ID NAME C1 C2 C3 C4 C5 C6 total F1 F2 F3 F4 F5 FW1 FW2 FW3
> > FW4
> > 3-Jan-113089 DEF 889 0 15 0 2 0 906 906 889 2 15 1795
> > 891 17 1810 2686
> >
> > (similar sheet for all the other values in name column)
> >
> > Code:
> > Sub Counts_upload()
> > '
> > ' Counts_upload Macro
> > ' This macro is used to load running counts from raw to master
> > workbook

Re: $$Excel-Macros$$ Need a macro to update data from raw file to individual sheets of master

[Varun]

Sorry, but i could not find any way of attaching excel in my mails
here. Could some one please let me know how I should go abot that.

Many thanks.
Varun

On Oct 23, 6:24 pm, "dguillett1"  wrote:
> Best to ATTACH your file. Code could be simplified. ie:
> last = Cells(Rows.Count, "B").End(xlUp).Row
>    For i = last To 1 Step -1
>        If (Cells(i, "B").Value) = "ABC" Then
>            Cells(i, "A").EntireRow.Delete
>        End If
>        If (Cells(i, "B").Value) = "XYZ" Then
>            Cells(i, "A").EntireRow.Delete
>        End If
>        If (Cells(i, "B").Value) = "Res" Then
>            Cells(i, "A").EntireRow.Delete
>        End If
>        Next i
>
> could be
>
> For i = Cells(Rows.Count, "B").End(xlUp).Row To 1 Step -1
> Select Case UCase(Cells(i, "B"))
>    Case Is = "ABC", "XYZ", "RES": Rows(i).Delete
> End Select
> Next i
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
> -Original Message-
> From: Varun
> Sent: Sunday, October 23, 2011 3:43 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Need a macro to update data from raw file to
> individual sheets of master
>
> Hi Everyone,
>
> I need a code for the following steps to be enacted
>
> 1. Save a backup file with the name counts - date.xls (this will be a
> daily file)
> 2. remove rows with name (column B) matching with name in to be
> removed sheet
> 3. copy value in name field and open the corusponding sheet in the
> master
> 4. once the sheet is active, go to the last row insert current date in
> left most collumn and paste the row from raw to master (from Column B)
> 5. copy the formula in the remailing columns in that sheet from above
> 6. once updated give a msg = this work is now complete
>
> Conditions -
> 1. If the sheet does not exist in the master then give an inputbox
> informing that we have a new name and asking if a new sheet should be
> created or should this be merged with another existing sheet - if user
> says yes to new sheet then create a new one with the same headers/
> formatting and formulas as the others
> 2. In the end in the msg box (this work is now complete) it should
> contain a summary of unusual events i.e.
> A. New name (sheet created)
> B. New name (merged with existing sheet)
> C. Count for particular name in Column C2 greater than 50 (Name-
> column B and count - C2 detail)
>
> I tried my hand on this but got stuck half way. i was not able to find
> a way to put condition 3 in the code.
>
> This is really urgentI would be really really really greatful if
> someone can help me out here.
>
> Thanks a lot
>
> I have attached a sample file for test and master with this post along
> with my code.
>
> Raw file:
> ID NAME C1 C2 C3 C4 C5 C6 total
> 6 ABC 799561 56 345345 234 243 234 1145673
> 3089 DEF 17 0 0 0 345 0 362
> 47 GHI 22536 123 0 0 234 2 22895
> 6895 XYZ 31 0 0 0 453 0 484
> 6749 NFF 5 65 1 15 5 0 91
> 74 IJK 122558 511 1 68 11 0 123149
> 75 KLM 6597 21 0 5 13 0 6636
> 42 NOP 69969 123 3 12 234 0 70341
> 103 MON 566278 234 2 17 23 0 566554
> 76 NND 58586 234 0 23 432 0 59275
> 31 PLQ 4283 0 0 0 54 0 4337
> 6325 RST 7 0 0 0 22 0 29
> 5926 DHE 34 0 0 0 24 0 58
> 6781 UUT 3 55 23 6 1 0 88
> 5237 NIQ 20100 41 64 6 817 0 21028
> 101 IJP 8063 2 0 0 65 0 8130
>
> To be removed
> ID NAME
> 6 ABC
> 6895 XYZ
> 345 RES
> 101 IJP
>
> Master
> Record Date ID NAME C1 C2 C3 C4 C5 C6 total F1 F2 F3 F4 F5 FW1 FW2 FW3
> FW4
> 3-Jan-11        3089 DEF         889 0 15 0 2 0 906 906 889 2 15 1795
> 891 17 1810 2686
>
> (similar sheet for all the other values in name column)
>
> Code:
>     Sub Counts_upload()
> '
> ' Counts_upload Macro
> ' This macro is used to load running counts from raw to master
> workbook
> ' Keyboard Shortcut: Ctrl+Shift+A
>    Workbooks("test").Sheets("raw").Select
>     Range("A1").Select
>     Dim i As Integer
>     last = Cells(Rows.Count, "B").End(xlUp).Row
>     For i = last To 1 Step -1
>         If (Cells(i, "B").Value) = "ABC" Then
>             Cells(i, "A").EntireRow.Delete
>         End If
>         If (Cells(i, "B").Value) = "XYZ" Then
>             Cells(i, "A").EntireRow.Delete
>         End If
>         If (Cells(i, "B").Value) = "Res" Then
>             Cells(i, "A").EntireRow.Delete
>         End If
>         Next i
>     ChDir "

Re: $$Excel-Macros$$ Need a macro to update data from raw file to individual sheets of master

[dguillett1]

Best to ATTACH your file. Code could be simplified. ie:
last = Cells(Rows.Count, "B").End(xlUp).Row
  For i = last To 1 Step -1
  If (Cells(i, "B").Value) = "ABC" Then
  Cells(i, "A").EntireRow.Delete
  End If
  If (Cells(i, "B").Value) = "XYZ" Then
  Cells(i, "A").EntireRow.Delete
  End If
  If (Cells(i, "B").Value) = "Res" Then
  Cells(i, "A").EntireRow.Delete
  End If
  Next i

could be

For i = Cells(Rows.Count, "B").End(xlUp).Row To 1 Step -1
Select Case UCase(Cells(i, "B"))
  Case Is = "ABC", "XYZ", "RES": Rows(i).Delete
End Select
Next i

Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Varun

Sent: Sunday, October 23, 2011 3:43 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need a macro to update data from raw file to 
individual sheets of master


Hi Everyone,

I need a code for the following steps to be enacted

1. Save a backup file with the name counts - date.xls (this will be a
daily file)
2. remove rows with name (column B) matching with name in to be
removed sheet
3. copy value in name field and open the corusponding sheet in the
master
4. once the sheet is active, go to the last row insert current date in
left most collumn and paste the row from raw to master (from Column B)
5. copy the formula in the remailing columns in that sheet from above
6. once updated give a msg = this work is now complete

Conditions -
1. If the sheet does not exist in the master then give an inputbox
informing that we have a new name and asking if a new sheet should be
created or should this be merged with another existing sheet - if user
says yes to new sheet then create a new one with the same headers/
formatting and formulas as the others
2. In the end in the msg box (this work is now complete) it should
contain a summary of unusual events i.e.
A. New name (sheet created)
B. New name (merged with existing sheet)
C. Count for particular name in Column C2 greater than 50 (Name-
column B and count - C2 detail)

I tried my hand on this but got stuck half way. i was not able to find
a way to put condition 3 in the code.

This is really urgentI would be really really really greatful if
someone can help me out here.

Thanks a lot

I have attached a sample file for test and master with this post along
with my code.

Raw file:
ID NAME C1 C2 C3 C4 C5 C6 total
6 ABC 799561 56 345345 234 243 234 1145673
3089 DEF 17 0 0 0 345 0 362
47 GHI 22536 123 0 0 234 2 22895
6895 XYZ 31 0 0 0 453 0 484
6749 NFF 5 65 1 15 5 0 91
74 IJK 122558 511 1 68 11 0 123149
75 KLM 6597 21 0 5 13 0 6636
42 NOP 69969 123 3 12 234 0 70341
103 MON 566278 234 2 17 23 0 566554
76 NND 58586 234 0 23 432 0 59275
31 PLQ 4283 0 0 0 54 0 4337
6325 RST 7 0 0 0 22 0 29
5926 DHE 34 0 0 0 24 0 58
6781 UUT 3 55 23 6 1 0 88
5237 NIQ 20100 41 64 6 817 0 21028
101 IJP 8063 2 0 0 65 0 8130

To be removed
ID NAME
6 ABC
6895 XYZ
345 RES
101 IJP

Master
Record Date ID NAME C1 C2 C3 C4 C5 C6 total F1 F2 F3 F4 F5 FW1 FW2 FW3
FW4
3-Jan-113089 DEF 889 0 15 0 2 0 906 906 889 2 15 1795
891 17 1810 2686

(similar sheet for all the other values in name column)



Code:
   Sub Counts_upload()
'
' Counts_upload Macro
' This macro is used to load running counts from raw to master
workbook
' Keyboard Shortcut: Ctrl+Shift+A
  Workbooks("test").Sheets("raw").Select
   Range("A1").Select
   Dim i As Integer
   last = Cells(Rows.Count, "B").End(xlUp).Row
   For i = last To 1 Step -1
   If (Cells(i, "B").Value) = "ABC" Then
   Cells(i, "A").EntireRow.Delete
   End If
   If (Cells(i, "B").Value) = "XYZ" Then
   Cells(i, "A").EntireRow.Delete
   End If
   If (Cells(i, "B").Value) = "Res" Then
   Cells(i, "A").EntireRow.Delete
   End If
   Next i
   ChDir "C:\Desktop\counts"
   Dim flname As Long
   ActiveWorkbook.SaveCopyAs "C:\Desktop\counts\counts - " &
Format(Date, "dd-mmm-yy") & ".xls"
   Workbooks("test").Sheets("raw").Select
   Dim k As Integer
   Dim wrk As Worksheet
   Dim n As Integer
   Dim countnonblank As Integer
   Dim myRange As Range
   Set myRange = Columns("B:B")
   countnonblank = Application.WorksheetFunction.CountA(myRange)
   n = countnonblank
   For k = 2 To n Step 1
   wrk = Worksheets("raw").Range("B" & k).Value
   Worksheets("raw").Cells(k, "A").EntireRow.Copy
   If k = "" Then
   Exit Sub
   End If
   Worksheets(wrk).Range("A1").selct
   activecell.End(xlDown).Select
   activecell.Offset(1, 0).Select
   activecell.Value = Date
   activec

$$Excel-Macros$$ Need a macro to update data from raw file to individual sheets of master

[Varun]

Hi Everyone,

I need a code for the following steps to be enacted

1. Save a backup file with the name counts - date.xls (this will be a
daily file)
2. remove rows with name (column B) matching with name in to be
removed sheet
3. copy value in name field and open the corusponding sheet in the
master
4. once the sheet is active, go to the last row insert current date in
left most collumn and paste the row from raw to master (from Column B)
5. copy the formula in the remailing columns in that sheet from above
6. once updated give a msg = this work is now complete

Conditions -
1. If the sheet does not exist in the master then give an inputbox
informing that we have a new name and asking if a new sheet should be
created or should this be merged with another existing sheet - if user
says yes to new sheet then create a new one with the same headers/
formatting and formulas as the others
2. In the end in the msg box (this work is now complete) it should
contain a summary of unusual events i.e.
A. New name (sheet created)
B. New name (merged with existing sheet)
C. Count for particular name in Column C2 greater than 50 (Name-
column B and count - C2 detail)

I tried my hand on this but got stuck half way. i was not able to find
a way to put condition 3 in the code.

This is really urgentI would be really really really greatful if
someone can help me out here.

Thanks a lot

I have attached a sample file for test and master with this post along
with my code.

Raw file:
ID  NAMEC1  C2  C3  C4  C5  C6  total
6   ABC 799561  56  345345  234 243 234 1145673
3089DEF 17  0   0   0   345 0   362
47  GHI 22536   123 0   0   234 2   22895
6895XYZ 31  0   0   0   453 0   484
6749NFF 5   65  1   15  5   0   91
74  IJK 122558  511 1   68  11  0   123149
75  KLM 659721  0   5   13  0   6636
42  NOP 69969   123 3   12  234 0   70341
103 MON 566278  234 2   17  23  0   566554
76  NND 58586   234 0   23  432 0   59275
31  PLQ 42830   0   0   54  0   4337
6325RST 7   0   0   0   22  0   29
5926DHE 34  0   0   0   24  0   58
6781UUT 3   55  23  6   1   0   88
5237NIQ 20100   41  64  6   817 0   21028
101 IJP 80632   0   0   65  0   8130

To be removed
ID  NAME
6   ABC
6895XYZ
345 RES
101 IJP

Master
Record Date ID  NAMEC1  C2  C3  C4  C5  C6  
total   F1  F2  F3  F4  F5  FW1 FW2 FW3
FW4
3-Jan-11   3089 DEF 889 0   15  0   
2   0   906 906 889 2   15  1795
891 17  18102686

(similar sheet for all the other values in name column)



Code:
Sub Counts_upload()
'
' Counts_upload Macro
' This macro is used to load running counts from raw to master
workbook
' Keyboard Shortcut: Ctrl+Shift+A
   Workbooks("test").Sheets("raw").Select
Range("A1").Select
Dim i As Integer
last = Cells(Rows.Count, "B").End(xlUp).Row
For i = last To 1 Step -1
If (Cells(i, "B").Value) = "ABC" Then
Cells(i, "A").EntireRow.Delete
End If
If (Cells(i, "B").Value) = "XYZ" Then
Cells(i, "A").EntireRow.Delete
End If
If (Cells(i, "B").Value) = "Res" Then
Cells(i, "A").EntireRow.Delete
End If
Next i
ChDir "C:\Desktop\counts"
Dim flname As Long
ActiveWorkbook.SaveCopyAs "C:\Desktop\counts\counts - " &
Format(Date, "dd-mmm-yy") & ".xls"
Workbooks("test").Sheets("raw").Select
Dim k As Integer
Dim wrk As Worksheet
Dim n As Integer
Dim countnonblank As Integer
Dim myRange As Range
Set myRange = Columns("B:B")
countnonblank = Application.WorksheetFunction.CountA(myRange)
n = countnonblank
For k = 2 To n Step 1
wrk = Worksheets("raw").Range("B" & k).Value
Worksheets("raw").Cells(k, "A").EntireRow.Copy
If k = "" Then
Exit Sub
End If
Worksheets(wrk).Range("A1").selct
activecell.End(xlDown).Select
activecell.Offset(1, 0).Select
activecell.Value = Date
activecell.Offset(0, 1).Select
activecell.PasteSpecial
Next k
End Sub

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.

Re: $$Excel-Macros$$ Need a Macro

[karan 1237]

It's working...Thank you so much...

*
Kαяαη*



On Fri, Jul 15, 2011 at 12:33 PM, NOORAIN ANSARI
wrote:

>
> http://www.excelforum.com/excel-programming/353482-macro-to-create-format-painter.html
>
>
> On Fri, Jul 15, 2011 at 12:29 PM, karan 1237  wrote:
>
>> Hello Friends,
>>
>> I need your help to make macro. I need a macro which work like format
>> painter for different format not only one format.
>>  *
>> ---
>> Kαяαη*
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need a Macro

[NOORAIN ANSARI]

http://www.excelforum.com/excel-programming/353482-macro-to-create-format-painter.html

On Fri, Jul 15, 2011 at 12:29 PM, karan 1237  wrote:

> Hello Friends,
>
> I need your help to make macro. I need a macro which work like format
> painter for different format not only one format.
> *
> ---
> Kαяαη*
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Need a Macro

[karan 1237]

Hello Friends,

I need your help to make macro. I need a macro which work like format
painter for different format not only one format.
*
---
Kαяαη*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need a Macro

[Abhishek Jain]

Thanks a lot Ashish but this doesn't do what i need. I want the available
quantity and amount against negative and zero values. In other words I want
to set off those negatives and nulls with the positives.

Thanks & regards,

AJ


On Wed, Jul 6, 2011 at 12:39 PM, ashish koul  wrote:

> Option Compare Text
> Sub test()
> Dim i, j, w  As Long
> w = Sheets(1).Range("a65356").End(xlUp).Row
> For i = 2 To w
>
>
> If Range("e" & i).Value = 0 And Range("f" & i).Value < 0 Then
>
> Range("h" & i).Value = Range("d" & i).Value
> Range("d" & i).Value = ""
>
> Range("i" & i).Value = Range("e" & i).Value
> Range("e" & i).Value = ""
> Range("j" & i).Value = Range("f" & i).Value
> Range("f" & i).Value = ""
>
> Range("k" & i).Value = Range("g" & i).Value
> Range("g" & i).Value = ""
>
>
> For j = 2 To w
>
>
>
>
> If j <> i And Range("c" & j).Value = Range("c" & i).Value Then
> If Range("e" & j).Value <> 0 And Range("f" & j).Value >= 0 Then
> Range("d" & i).Value = Range("d" & j).Value
>
> Range("e" & i).Value = Range("e" & j).Value
> Range("f" & i).Value = Range("f" & j).Value
> Range("g" & i).Value = Range("g" & j).Value
> Exit For
> End If
>
> End If
>
> Next j
>
>
> End If
> Next i
>
>
>
> End Sub
>
>
> On Wed, Jul 6, 2011 at 11:06 AM, Abhishek Jain wrote:
>
>> Friends,
>>
>> Any update on this?
>>
>> Thanks,
>>
>> AJ
>>
>>
>> On Tue, Jul 5, 2011 at 11:49 AM, Abhishek Jain wrote:
>>
>>> Dear friends,
>>>
>>> Attached along a data wherein in some rows, quantity and amount for items
>>> nos are both positive which is my inventory.
>>>
>>> In other rows one of the either or both are negative or nil. What I need
>>> to do is to adjust the negative and nil values from the positive values
>>> available for that particular item no. The macro should search for the
>>> negative/zero values in quantity and amount columns and if it is found in
>>> either of the column it should shift the available quantity/amount (with
>>> rate) to the adjacent columns and in the rows from where the data is shifted
>>> the row address of destination is written.
>>>
>>> An Example -
>>>
>>> At Row 16 - The quantity is 0 and amount is negative for item no.
>>> 002001010001. Now for this item no., the positive values are available at
>>> row no. 14. The macro should cut the Location Code, Quantity, Amount and
>>> Rate (D14:G14) and paste it in H16:K16) and in D14 the destination row no.
>>> is written - H16. (probably with different color).
>>>
>>> Hope some one helps me with this. This is a bit urgent.
>>>
>>> Thanks & regards,
>>>
>>> AJ
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
>  *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
-

Re: $$Excel-Macros$$ Need a Macro

[ashish koul]

Option Compare Text
Sub test()
Dim i, j, w  As Long
w = Sheets(1).Range("a65356").End(xlUp).Row
For i = 2 To w


If Range("e" & i).Value = 0 And Range("f" & i).Value < 0 Then

Range("h" & i).Value = Range("d" & i).Value
Range("d" & i).Value = ""

Range("i" & i).Value = Range("e" & i).Value
Range("e" & i).Value = ""
Range("j" & i).Value = Range("f" & i).Value
Range("f" & i).Value = ""

Range("k" & i).Value = Range("g" & i).Value
Range("g" & i).Value = ""


For j = 2 To w




If j <> i And Range("c" & j).Value = Range("c" & i).Value Then
If Range("e" & j).Value <> 0 And Range("f" & j).Value >= 0 Then
Range("d" & i).Value = Range("d" & j).Value

Range("e" & i).Value = Range("e" & j).Value
Range("f" & i).Value = Range("f" & j).Value
Range("g" & i).Value = Range("g" & j).Value
Exit For
End If

End If

Next j


End If
Next i



End Sub


On Wed, Jul 6, 2011 at 11:06 AM, Abhishek Jain wrote:

> Friends,
>
> Any update on this?
>
> Thanks,
>
> AJ
>
>
> On Tue, Jul 5, 2011 at 11:49 AM, Abhishek Jain wrote:
>
>> Dear friends,
>>
>> Attached along a data wherein in some rows, quantity and amount for items
>> nos are both positive which is my inventory.
>>
>> In other rows one of the either or both are negative or nil. What I need
>> to do is to adjust the negative and nil values from the positive values
>> available for that particular item no. The macro should search for the
>> negative/zero values in quantity and amount columns and if it is found in
>> either of the column it should shift the available quantity/amount (with
>> rate) to the adjacent columns and in the rows from where the data is shifted
>> the row address of destination is written.
>>
>> An Example -
>>
>> At Row 16 - The quantity is 0 and amount is negative for item no.
>> 002001010001. Now for this item no., the positive values are available at
>> row no. 14. The macro should cut the Location Code, Quantity, Amount and
>> Rate (D14:G14) and paste it in H16:K16) and in D14 the destination row no.
>> is written - H16. (probably with different color).
>>
>> Hope some one helps me with this. This is a bit urgent.
>>
>> Thanks & regards,
>>
>> AJ
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need a Macro

[Abhishek Jain]

Friends,

Any update on this?

Thanks,

AJ

On Tue, Jul 5, 2011 at 11:49 AM, Abhishek Jain wrote:

> Dear friends,
>
> Attached along a data wherein in some rows, quantity and amount for items
> nos are both positive which is my inventory.
>
> In other rows one of the either or both are negative or nil. What I need to
> do is to adjust the negative and nil values from the positive values
> available for that particular item no. The macro should search for the
> negative/zero values in quantity and amount columns and if it is found in
> either of the column it should shift the available quantity/amount (with
> rate) to the adjacent columns and in the rows from where the data is shifted
> the row address of destination is written.
>
> An Example -
>
> At Row 16 - The quantity is 0 and amount is negative for item no.
> 002001010001. Now for this item no., the positive values are available at
> row no. 14. The macro should cut the Location Code, Quantity, Amount and
> Rate (D14:G14) and paste it in H16:K16) and in D14 the destination row no.
> is written - H16. (probably with different color).
>
> Hope some one helps me with this. This is a bit urgent.
>
> Thanks & regards,
>
> AJ
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Need a Macro

[Dave Bonallack]

You're welcome.
Regards - Dave.
 


CC: excel-macros@googlegroups.com
From: karlaha...@hotmail.com
Subject: Re: $$Excel-Macros$$ Need a Macro
Date: Fri, 11 Mar 2011 19:19:00 -0800
To: excel-macros@googlegroups.com


This worked perfectly! Thank you!

Sent from my iPhone

On Mar 10, 2011, at 10:12 PM, Karla Haman  wrote:





I will give this a shot. Thank you so much.

Sent from my iPhone

On Mar 10, 2011, at 9:20 PM, Dave Bonallack  wrote:




Hi,
One approach is to insert a new blank sheet, call it "END" and move it to 
become the last sheet in the workbook.
Whenever adding new sheets, make sure they sit before the "END" sheet.
If your SUM formula was, for example:
=SUM(Sheet2:Sheet8!A1)
change it to:
=SUM(Sheet2:END!A1)
All sheets between (and including) "Sheet2" and "END" will be included, no 
matter how many there are.
 
Hope this helps
Regards - Dave.

 
> Date: Thu, 10 Mar 2011 16:16:37 -0800
> Subject: $$Excel-Macros$$ Need a Macro
> From: karlaha...@hotmail.com
> To: excel-macros@googlegroups.com
> 
> I have a tab that totals all of the other tabs in the spreadsheet. I
> need to be able to add new tabs and have the formulas in the "totals"
> tab automatically update.
> 
> How do I do this?
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need a Macro

[Karla Haman]

This worked perfectly! Thank you!

Sent from my iPhone

On Mar 10, 2011, at 10:12 PM, Karla Haman  wrote:

> I will give this a shot. Thank you so much.
> 
> Sent from my iPhone
> 
> On Mar 10, 2011, at 9:20 PM, Dave Bonallack  wrote:
> 
>> Hi,
>> One approach is to insert a new blank sheet, call it "END" and move it to 
>> become the last sheet in the workbook.
>> Whenever adding new sheets, make sure they sit before the "END" sheet.
>> If your SUM formula was, for example:
>> =SUM(Sheet2:Sheet8!A1)
>> change it to:
>> =SUM(Sheet2:END!A1)
>> All sheets between (and including) "Sheet2" and "END" will be included, no 
>> matter how many there are.
>>  
>> Hope this helps
>> Regards - Dave.
>> 
>>  
>> > Date: Thu, 10 Mar 2011 16:16:37 -0800
>> > Subject: $$Excel-Macros$$ Need a Macro
>> > From: karlaha...@hotmail.com
>> > To: excel-macros@googlegroups.com
>> > 
>> > I have a tab that totals all of the other tabs in the spreadsheet. I
>> > need to be able to add new tabs and have the formulas in the "totals"
>> > tab automatically update.
>> > 
>> > How do I do this?
>> > 
>> > -- 
>> > --
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links : 
>> > http://twitter.com/exceldailytip
>> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> > 
>> > To post to this group, send email to excel-macros@googlegroups.com
>> > 
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > Like our page on facebook , Just follow below link
>> > http://www.facebook.com/discussexcel
>> -- 
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links : 
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> 
>> To post to this group, send email to excel-macros@googlegroups.com
>>  
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email to excel-macros@googlegroups.com
>  
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need a Macro

[Karla Haman]

I will give this a shot. Thank you so much.

Sent from my iPhone

On Mar 10, 2011, at 9:20 PM, Dave Bonallack  wrote:

> Hi,
> One approach is to insert a new blank sheet, call it "END" and move it to 
> become the last sheet in the workbook.
> Whenever adding new sheets, make sure they sit before the "END" sheet.
> If your SUM formula was, for example:
> =SUM(Sheet2:Sheet8!A1)
> change it to:
> =SUM(Sheet2:END!A1)
> All sheets between (and including) "Sheet2" and "END" will be included, no 
> matter how many there are.
>  
> Hope this helps
> Regards - Dave.
> 
>  
> > Date: Thu, 10 Mar 2011 16:16:37 -0800
> > Subject: $$Excel-Macros$$ Need a Macro
> > From: karlaha...@hotmail.com
> > To: excel-macros@googlegroups.com
> > 
> > I have a tab that totals all of the other tabs in the spreadsheet. I
> > need to be able to add new tabs and have the formulas in the "totals"
> > tab automatically update.
> > 
> > How do I do this?
> > 
> > -- 
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links : 
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> > 
> > To post to this group, send email to excel-macros@googlegroups.com
> > 
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email to excel-macros@googlegroups.com
>  
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Need a Macro

[Dave Bonallack]

Hi,
One approach is to insert a new blank sheet, call it "END" and move it to 
become the last sheet in the workbook.
Whenever adding new sheets, make sure they sit before the "END" sheet.
If your SUM formula was, for example:
=SUM(Sheet2:Sheet8!A1)
change it to:
=SUM(Sheet2:END!A1)
All sheets between (and including) "Sheet2" and "END" will be included, no 
matter how many there are.
 
Hope this helps
Regards - Dave.

 
> Date: Thu, 10 Mar 2011 16:16:37 -0800
> Subject: $$Excel-Macros$$ Need a Macro
> From: karlaha...@hotmail.com
> To: excel-macros@googlegroups.com
> 
> I have a tab that totals all of the other tabs in the spreadsheet. I
> need to be able to add new tabs and have the formulas in the "totals"
> tab automatically update.
> 
> How do I do this?
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Need a Macro

[karlaha...@hotmail.com]

I have a tab that totals all of the other tabs in the spreadsheet.  I
need to be able to add new tabs and have the formulas in the "totals"
tab automatically update.

How do I do this?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Need a macro to automatically merge cells in the worksheet/workbook

[Praveen Khunte]

Hi all
How's everyone doing?
I am novice to macro, I need a help from you guys. I hope it should be
simple.
Present Scenario: I have a macro which remove non-breaking space
from all the cells at once in the worksheet. (If anyone need, I can
share the code). 
Usefulness of the Macro: When you copy data from the internet
and paste in an excel worksheet, it contains lot of spaces before and
after, and when you want to perform some calculation it doesn't give
desired result. This macro removes spaces before and after so that your
calculation (life) becomes easy.
Problem: This macro stops working beyond the point where the it
finds a merged cell. To overcome this, I need to select all the cells
of the worksheet and then Go to Format > Cells and  click uncheck
merge cells (as shown in image). This is tedious repetitive job since I
have about 30 worksheets.
Requirement: A macro which automatically merges all the cells of
the worksheet (if possible-entire workbook).



Warm Regards
Praveen
Khunte