formulas across workbooks

Hi, I have a number of files in Google Drive which many other people have access to for a number of reasons. One is a summary file which is the driver for formulas/value in 15 of the other files. However I have found when I change the driver cells nothing changes in the 15 linked docs until I...

I am working on two sheets and I need help finishing a formula to text to formula function. Sheet 1: Cell H48 formula: =CONCAT(TEXTJOIN(",",TRUE,H2:H47),",""""",J46,) Cell H48 output (Text)...

Hi All, I have a list of worksheet names in "Sheet1" range B2:B100. I would like to paste the formula : ActiveCell.FormulaR1C1 = "=CONCATENATE(Sheet1!R[1]C[1],""C25"")" into cell A1 of each worksheet mentioned in column B of Sheet1. However, the concatenate formula should keep updating...

Hello everybody, I have the following list of information: Is there any way in which I can alphabetically order this list with respect to column B? Would greatly appreciate any assistance I can obtain! :) Thank you very much everybody. Best regards, David

Greetings, Please could you let me know how I can change the following in the Properties of Excel without having to do each column manually. I always need to show as follows: R 0.00 and NOT R - Grateful for your assistance

Hey guys, I have a major project that is giving me a run for my money. I need to build a report that will allow us to copy a report from another excel workbook into this one, then have it automatically put out the expected payout based on the breakout of codes used in a visit type and the...

Hello, fellow excel nerds. I am trying to get a macro to work (again) that is designed to find all sheets in a workbook that have formulas that are linking to the current active sheet. I found this solution online and it actually worked when I first got it. I created an XLAM to have it on...

I have 2 spreadsheets, one is a master file and the other is a calendar where I want to look up and count the number of rows that match 2 criteria. First criteria is a specific date and the second criteria is text beginning with "Email". Below is the formula I have so far. It works as long as...

Hello Everyone, I currently have a worksheet that will populate days with the initials of the Staff that has been assigned a task that begins and ends in a certain time frame. I've used an IF function for this. I now have another task I must do. My boss wants there to be an Error Message...

I really need some help with a formula for a cell to calculate a figure based on another cell. Below is an illustration of the formulas that are needed. I am trying to take a backdoor approach the cell formula due to I am unable to use the indirect process like with multiple sheets in excel on...

Is it possible to calculate formulas in a workbook from data in another workbook opened in a separate instance? Purpose: I have multiple workbooks which contain weekly data that is compiled in a separate workbook with a tab for each week. My boss wants to have the data books open on one...

On occasion, my percentages in my graphs(saved perfectly as percentages) will open as decimals for someone else? I have unlinked all sources attached and cannot figure out why this happens? Any input is appreciated.

I have a worksheet setup to record household expenses and income (on a daily basis) and provide reporting at the same time. In part of the worksheet I record the daily expenses and income with totals at the bottom. I have very basic formula which adds up the daily amounts and gives a total for...

Hi all, I am trying to do this: On Workbook 1, when Column AH has the value W, then on Workbook 2, on the next blank row, assign the next job number(Q1234...) and auto populate the remaining details from the Row which had the value W, in Workbook 1. Is this possible? I tried everything I...

Hello all, I have found a number of threads on this subject, but all point towards using '=indirect()' or a macro. The problem with the indirect function is that I cannot consistently have the referenced file open, hence a #REF error. I also do not want to use a macro due to the volatility of...

I am copying the value in a cell to another sheet's cell. I want to convert the formulas on the second cheet to reflect their value. I do this all the time within cells by using Past Special and Values however it doesn't give me that option within the Text Box Thanks

I am trying to insert a string of formulas on a separate sheet from my data, ie standard deviation, median, mode, etc. I am trying to get the sheet of formulas (sheet 2) to update automatically given the data that is selected on sheet 1. Sheet 1 is filtered by categories allowing the user to...

I don't know exactly how to explain what I am trying to do, so please bear with me. I have a workbook with 365 pages (one page for each day of the year). On each page (day) I have columns that track the number of people present each hour in various areas of our business. I have been...

Hi there! So I am in a bit of a bind and need help figuring out the following: I have 23 Worksheets. All of the worksheets have the same headers in the same column locations All of the worksheets have different criteria (names, dates, blank fields, etc.) Worksheet 1 Col A - Building...

Hi Board - You've all been extremely helpful in the past so I have high hopes for this one. At work, I do a lot of spreadsheet analysis. Currently, we have a workbook that has a ton of formulas/arrays/etc. and when we need to create a new one we just resave and old one and over-write the...