multiple sheet data

  1. M

    Goal Seek with input from multiple values and worksheets using VBA

    Hi mrexcel forum community, I'm a newcomer what comes to VBA and would greatly appreciate your tips and help on how to solve my problem. If I've understood correctly, goal seek with input from multiple values and worksheets require VBA code. The parameters: Cell C39 in Sheet 1 (value) Cell...
  2. K

    Auto Update Formula

    So, I have a workbook containing multiple worksheets and I'm trying to clean it up a little bit. This workbook is a list of people that my company contacts and it states if they accept an invitation from us when we contact them or not (in other words there are a bunch of yes and no's next to...
  3. M

    Reference specific cell from every spreadsheet on the workbook (except Spreadsheet X,Y and Z) and list results

    Hi all! I'm looking for a way to pull data from every spreadsheet in my workbook, except for spreadhsheet X, Y and Z and list the results on cell C11 in spreadsheet X. I'm sure this is very straightforward but I'm quite new to VBA and am picking as I go, learning from each iteration. Can...
  4. M

    Need Help creating a size to weight metal conversion calculator

    Thank you for your help, I need to create a calculator from a paper reference chart. Page 51 - Myron Toback 2009 Catalog above is a link to the page in my catalog. What I have currently is a spreadsheet with 3 sheets. Sheet 1 is text that has a dropdown for thickness and next to it is a...
  5. J

    Conditional Formating from a Data Validation List

    Scenario: Sheet 1;Column C and Column D: I have user typed "Customer Names" in Column C. I have a drop down list in Column D, which allows user to designate the customers as a "Partner" or a "Non-Partner" I have a color coded conditional formatting on Sheet 1 working properly based on...
  6. M

    Simple (or complex?) excel task regarding duplicates and date comparisons

    My new position at work has me doing a lot of spreadsheet analysis. I love it, but realize I have to ramp up big time to learn how to do a bunch of excel how-to functions. I have a 15 year background of writing Visual Basic EXE applications, and told I can use a lot of that experience via VBA...
  7. H

    pull selected data from multiple worksheets into single worksheet

    I am a slightly above beginner user of Excel, so this problem is beyond my abilities. I have been given a master sheet that needs to pull selected data from several other sheets in the file. The master is a calendar. The other sheets (currently up to 16 other sheets) all have 2 main columns...
  8. L

    Need VBA Help for Dashboard!!!

    Hello Everyone, I am building a dashboard but I need help with a macro. What I need the macro to do: I need the macro to erase data from a specific range in "1", then copy the data from "2" into "1." Then erase the data from "2" and copy "3's" data into "2." Then copy the data from "4" into...

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
Back
Top