formulas across workbooks

  1. G

    VBA Loop through worksheets and update formula

    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...
  2. D

    Alphabetically order a list with respect to column B

    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
  3. L

    Number Formatting Excel 2016

    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
  4. Z

    Complex problem involving payout calculation based on multiple inputs from several different inputs

    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...
  5. W

    Show Links to Current Active Sheet

    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...
  6. E

    COUNTIFS Referencing another workbook

    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...
  7. T

    Vacation Time Error VBA Code

    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...
  8. H

    In need of a formula wizard for calculations.....

    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...
  9. C

    Calculating Formulas from multiple instances of Excel

    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...
  10. S

    Percentages saved open as decimals?

    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.
  11. M

    Trying to retain data in one part of my worksheet which comes from formula in another part

    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...
  12. A

    Auto Populate Columns, two worksheets

    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...
  13. J

    Reference filename based on Cell contents

    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...
  14. S

    Convert formulas to values in a test box

    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
  15. S

    Automatically Updating Formulas

    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...
  16. S

    Creating 'Advanced' averages

    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...
  17. M

    Vlookup with multiple sheets and multiple returns

    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...
  18. M

    Help with Template Creation: Basic Question

    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...
  19. G

    Using Drop-Down Selections To Replace Worksheet Names in Formulas

    Using EXCEL 2007, Windows Vista (32). I want to be able to place a reference in a formula to a cell containing a drop- down list so that the name in the drop-down list will replace the name (on another worksheet tab) to enable me to call up the data in the cell in the formula. Say I have...
  20. E

    Help importing, updating, and automating excel sheets

    Hi everyone! I am having some trouble setting up a master excel sheet that can automatically pull data from a folder when it is opened. I currently work with an inefficient data management system in which I save a file as a text (which I can't change), I then re-save it as an excel sheet...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

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