Hello, I am looking for some formulas, I been pulling my hair out the last 3 weeks looking through posts and online help without a solution, So I hope some one can help. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
The first formula I am looking for is: Easy one but I may not be doing a correct search.<o></o>
<o></o>
Get data from a cell from one worksheet and have it displayed on another worksheet on and other cell<o></o>
<o></o>
Example:<o></o>
<o></o>
I have a worksheet named Master and another worksheet named March<o></o>
<o></o>
I need the data from G4 of March to display on the worksheet Master on C-16<o></o>
<o></o>
<o></o>
The Second formula I am looking for is:<o></o>
<o></o>
Get the workbook name that is located in a subfolder to be displayed in column A of a workbook/worksheet.<o></o>
<o></o>
Example:<o></o>
<o></o>
The workbook is named Master Payroll Workbook 2012.xls it is in a folder and there are other folders in this as well named 2008, 2009, 2010, 2011 and 2012 these are the years.<o></o>
<o></o>
In each year folder is 12 more folders named January to December. These are the Monthly folders.<o></o>
<o></o>
In the monthly folders there maybe 20 to 25 .XLS files named with the dates we did payroll. <o></o>
<o></o>
Example 3-6-12.xls 3-7-12.xls 3-9 -12.xls so on!<o></o>
<o></o>
Lets Say I have Master Payroll Workbook 2012. xls.
Now in this workbook, I open the worksheet March in cell A-4 there will be the name 3-6-12.xls
This name came from /2012/March/3-6-2012.xls.
A-5 may have 3-7-12.xls
A-6 may have 3-9-12.xls in it and so on until this month is done.<o></o>
<o></o>
I was hoping to save time by having a formula’s in there to get the names without going though hours of typing each date on every month.<o></o>
<o></o>
Basically: <o></o>
<o></o>
I am trying to create a Master Payroll Workbook 2012 that will pull the total checks for the week from each payroll workbooks we created so we can see if the check amounts are increasing or decreasing.<o></o>
<o></o>
In this Master Payroll Workbook 2012 I named the first sheet Master Totals It will have monthly and year totals on it pulled from other work sheets.<o></o>
<o></o>
I also made 12 additional worksheets and named them January to December in this Master Payroll Workbook 2012<o></o>
<o></o>
Now each monthly sheets in the Master Payroll Workbook 2012 will have<o></o>
<o></o>
Example: <o></o>
<o></o>
January <o></o>
<o></o>
Column A Column B<o></o>
<o></o>
Work Sheet Date Check Total<o></o>
1-1-12 36<o></o>
<o></o>
1-3-12 56<o></o>
<o></o>
1-5-12 12<o></o>
<o></o>
<o></o>
Check Totals 104 this total will be displayed on Master Totals named monthly.<o></o>
<o></o>
<o></o>
I will explain our process briefly so it will aid in helping out in my formulas.<o></o>
<o></o>
When we do our check printing we go into what we call BLANK CHECK WORKBOOK. <o></o>
<o></o>
This workbook has all the information on it and the cells locked except the cells you need to enter the check range and amount.<o></o>
<o></o>
The BLANK CHECK WORKBOOK adds the check amounts below in C-43 of the workbook. We could have 20 check cycles per day <o></o>
<o></o>
Example: <o></o>
<o></o>
Column A Column B Column C<o></o>
<o></o>
Check Cycle <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1lace w:st="on"><st1:PlaceName w:st="on">Check</st1:PlaceName> <st1:PlaceType w:st="on">Range</st1:PlaceType></st1lace> Amount<o></o>
<o></o>
Checks Cycle 1 202 to 213 12<o></o>
Checks Cycle 2 214 to 215 2<o></o>
Checks Cycle 3 216 to 220 5<o></o>
<o></o>
Total Checks Printed 19 <<<<<< This is C-43<o></o>
<o></o>
<o></o>
Once this is done we save the work book as Example 1-1-2012, It shows in the saved folder as 1-1-2012.xls<o></o>
<o></o>
We do this for each day we get checks in so, we can have 5 workbooks a week all named with the date.<o></o>
<o></o>
Note. I some cases that they want special runs and to be separate we will have 2 workbooks day and one will have be named <o></o>
<o></o>
Example: 1-1-2012a.xls and the other 1-1-2012b.xls <o></o>
<o></o>
<o></o>
We have a lot of workbooks since 2008 we like to get a reference to see how may checks were are decreasing a month and a year.<o></o>
<o></o>
We are just trying to find a easier solution.<o></o>
<o></o>
Thanks <o></o>
<o></o>
The first formula I am looking for is: Easy one but I may not be doing a correct search.<o></o>
<o></o>
Get data from a cell from one worksheet and have it displayed on another worksheet on and other cell<o></o>
<o></o>
Example:<o></o>
<o></o>
I have a worksheet named Master and another worksheet named March<o></o>
<o></o>
I need the data from G4 of March to display on the worksheet Master on C-16<o></o>
<o></o>
<o></o>
The Second formula I am looking for is:<o></o>
<o></o>
Get the workbook name that is located in a subfolder to be displayed in column A of a workbook/worksheet.<o></o>
<o></o>
Example:<o></o>
<o></o>
The workbook is named Master Payroll Workbook 2012.xls it is in a folder and there are other folders in this as well named 2008, 2009, 2010, 2011 and 2012 these are the years.<o></o>
<o></o>
In each year folder is 12 more folders named January to December. These are the Monthly folders.<o></o>
<o></o>
In the monthly folders there maybe 20 to 25 .XLS files named with the dates we did payroll. <o></o>
<o></o>
Example 3-6-12.xls 3-7-12.xls 3-9 -12.xls so on!<o></o>
<o></o>
Lets Say I have Master Payroll Workbook 2012. xls.
Now in this workbook, I open the worksheet March in cell A-4 there will be the name 3-6-12.xls
This name came from /2012/March/3-6-2012.xls.
A-5 may have 3-7-12.xls
A-6 may have 3-9-12.xls in it and so on until this month is done.<o></o>
<o></o>
I was hoping to save time by having a formula’s in there to get the names without going though hours of typing each date on every month.<o></o>
<o></o>
Basically: <o></o>
<o></o>
I am trying to create a Master Payroll Workbook 2012 that will pull the total checks for the week from each payroll workbooks we created so we can see if the check amounts are increasing or decreasing.<o></o>
<o></o>
In this Master Payroll Workbook 2012 I named the first sheet Master Totals It will have monthly and year totals on it pulled from other work sheets.<o></o>
<o></o>
I also made 12 additional worksheets and named them January to December in this Master Payroll Workbook 2012<o></o>
<o></o>
Now each monthly sheets in the Master Payroll Workbook 2012 will have<o></o>
<o></o>
Example: <o></o>
<o></o>
January <o></o>
<o></o>
Column A Column B<o></o>
<o></o>
Work Sheet Date Check Total<o></o>
1-1-12 36<o></o>
<o></o>
1-3-12 56<o></o>
<o></o>
1-5-12 12<o></o>
<o></o>
<o></o>
Check Totals 104 this total will be displayed on Master Totals named monthly.<o></o>
<o></o>
<o></o>
I will explain our process briefly so it will aid in helping out in my formulas.<o></o>
<o></o>
When we do our check printing we go into what we call BLANK CHECK WORKBOOK. <o></o>
<o></o>
This workbook has all the information on it and the cells locked except the cells you need to enter the check range and amount.<o></o>
<o></o>
The BLANK CHECK WORKBOOK adds the check amounts below in C-43 of the workbook. We could have 20 check cycles per day <o></o>
<o></o>
Example: <o></o>
<o></o>
Column A Column B Column C<o></o>
<o></o>
Check Cycle <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1lace w:st="on"><st1:PlaceName w:st="on">Check</st1:PlaceName> <st1:PlaceType w:st="on">Range</st1:PlaceType></st1lace> Amount<o></o>
<o></o>
Checks Cycle 1 202 to 213 12<o></o>
Checks Cycle 2 214 to 215 2<o></o>
Checks Cycle 3 216 to 220 5<o></o>
<o></o>
Total Checks Printed 19 <<<<<< This is C-43<o></o>
<o></o>
<o></o>
Once this is done we save the work book as Example 1-1-2012, It shows in the saved folder as 1-1-2012.xls<o></o>
<o></o>
We do this for each day we get checks in so, we can have 5 workbooks a week all named with the date.<o></o>
<o></o>
Note. I some cases that they want special runs and to be separate we will have 2 workbooks day and one will have be named <o></o>
<o></o>
Example: 1-1-2012a.xls and the other 1-1-2012b.xls <o></o>
<o></o>
<o></o>
We have a lot of workbooks since 2008 we like to get a reference to see how may checks were are decreasing a month and a year.<o></o>
<o></o>
We are just trying to find a easier solution.<o></o>
<o></o>
Thanks <o></o>