workbook auto populate

Hi, I have a spreadsheet in Google Sheets which has multiple sheets. All the different sheets represent different categories - the first rows of all the sheets is the same. Is there a way to auto-populate and consolidate all the sheets so that they are all in one master sheet? The first two...

Hi! We have multiple workbooks that we work in: 1) Master Expenses. This is where every transaction from the bank account is put into. Each transaction is then labeled with he corresponding "project" or "property". 2) Property Specific Expenses. Each project/property has its own spreadsheet...

So there are bunch of ways to find where excel file data is pulled from, but I found none to find where data is fed to. I want to rename an excel file, but I want to also make sure other files that are linked to that file will change the file name.

Hi All I have a VBA project that on button activation opens 2workbooks (Data sheet and PPM tracker). The main workbook (report) has formulaethe links to the Data sheet. When I open the workbooks backwards manually (datasheet then Reports) the formulae updates. The Formulae I am using are...

PLEASE HELP! I will describe this as detailed as possible. GOAL: To auto-transfer data (criteria based/no blanks) from an online-based Sharepoint file to a separate workbook for analysis From (Source) File = “LabData.xlsx” located online at http://sharepoint.com/Labs/LabData (made up) To...

I have 3 different workbooks that I'm working with. 2 of the workbooks are reports that are automatically saved to a random temporary internet file folder. I was wondering if I can somehow activate the 2 workbooks without knowing the file path since they will saved to a random folder every time...

Hi hope someone can help me with my query I have template that has several sheets in it, in order to populate those sheets I enter an 8 digit number in Sheet 1, cell B3. I then SaveAs the sheet and save it with the employees name. I have to do 150 of these so I was hoping to automate the...

Hi! I am clueless about macros and would deeply appreciate your help. Is it possible to have a macro copy a row from one worksheet and paste it in a new row in another worksheet based on what value is in a cell of that row in a specific column? Let me give you an example of what I'm trying to...

Hey everybody, I'm trying to keep a master list of product data that will automatically populate based on user input. The way things are currently set up, a user fills out a worksheet with product data (serial number, calibration information, customer, etc.) and a VBA coded button formats the...