I have a spreadsheet which consolidates information from several other spreadsheets. This 'master' spreadsheet collects all the data from the source files fine as long as they are open, but doesn't when they are not.
These source files are working documents. Is there a particular format they...
I am trying to accomplish something that I would suspect is a common type of problem, but I have been all over the internet and I'm having trouble finding it:
I have a master excel workbook with lots of macros, formulas, and data from many sources which I copy each week to do my planning. I...
Hello,
I am very new to VBA and desperately need help!
I am trying to set up a master (source) Excel workbook that pulls from/pushes data in approximately 12 other workbooks. Whoever is using the source workbook needs to be able to:
1. Write a date into two specific cells (E10 and G10) in a...
On Jan. 1st my Jobs List folder will be archived due to the size and the file name changed to "Jobs List 2008-2011". For every job on the Job List, I have a separate workbook that tracks time and expenses for that particular job. Every individual Job Worksheet has a link back to the Job List...
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.