Gathering Info from multiple workbooks

AllyCat

New Member
Joined
Sep 10, 2002
Messages
10
I need to export certain data from cells within workbooks created from a template into another excel spreadsheet. Is there anyone who knows how I could automatically generate these values each time I create a new workbook from my template? It would save me hours and hours of manually inputting values!
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

gnaga

Well-known Member
Joined
Jul 9, 2002
Messages
700
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
Give an example of your requirement.

GNaga
 

AllyCat

New Member
Joined
Sep 10, 2002
Messages
10
Ok, for instance. My template is a workbook consisting of many timesheets. On each timesheet is a cell with a formula giving total number of hours worked for an employee for that week. Each sheet within the book is set up identically with the same rows and cells, but for different contracts and employees. I need to be able to extract the total number hours worked each week for each employee from each timesheet into a separate excel worksheet where each employee would have a sheet with running totals of hours worked since the start of their employment or for that year. I could just create a formula to give a total for each week and then manually input it into a sheet but i'd really like it to transfer the data for me each time i create a new weeks timesheets from the template.
I really appreciate any suggestions as I know practically nothing about VBA :confused:

Thanks,
Ally
 

Forum statistics

Threads
1,144,260
Messages
5,723,304
Members
422,492
Latest member
RobF2112

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top