--------------------------------------------
On Fri, 1/6/17, Paul Schreiner <schreiner_p...@att.net> wrote:
Subject: Re: $$Excel-Macros$$ move sheets to a workbook
To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com>
Date: Friday, January 6, 2017, 8:06 PM
How do
you envision this working?Say:You
have folders:January
2016February
2016March
2016April
2016May
2016June
2016 in
each folder you have 30 files (presumably Excel
files)In
your sample file, you said you "want to move all thirty
sheets".Does
that mean that there is only one sheet in each of the 30
workbooks,or
that you only want to move one of the sheets in each
workbook?Also:
If
you move the sheets, that means that the original workbook
no longer has the sheetbut
your new workbook now has 30 sheets.Is
that what you want? or do you want to COPY the data from
each of the 30 sheetsinto
a single sheet of the new workbook?
Do
you want a macro to do all the folders in the
"parent" folder or do you want to select which
folder to process?
Attached
are two files.Detach
them and place them in the folder containing the monthly
sub-folders.
The
"Template.xlsx" file is used as the basic template
for the report for a given month.The
macro copies this file to a file called "PETTY CASH FOR
" and the name of the folder.
I
created two buttons in the Composite_Macro.xlsb
file.The
first button creates a list of the sub-folders
"beneath" the folder where this file
resides.
once
you have the list of folders, put an "X" in
column B for those you wish to process.
then
hit the "Gen Selected" button.
The
report files will be in the same folder as the
"Composite Macro" file.
To
test, I created (6) folders, named "January 2016"
through "June 2016".In
each folder, I copied your sample file 30 times (so I had
180 copies)
I
then made reports for all 6 folders.
It
took about 90 seconds.
hope
this gives you enough to work with.
Paul-----------------------------------------
“Do
all the good you can,
By all the means you
can,
In all the ways you can,
In all the places you can,
At
all the times you can,
To all the people you
can,
As long as ever you can.” - John
Wesley
-----------------------------------------
On Friday, January 6,
2017 11:45 AM, Izhar <izharra...@gmail.com> wrote:
Hi everyone
I need help in the attach file, the
question has defined in the attach workbook and I hope there
will be someone look into the matter.
Thanks in advance.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
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.
--
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.
1878-1880 1i -infiintarea de noi agentii diplomatice ale Romaniei in
strainatate 27-28 febr 11-12 mart - Camerele voteaza motiuni cu
privire la oportunitatea revizuirii articolului 7 din Constitutie 30 mart
- Legea privind infiintarea Academiei Romane
--
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.
