multiple sheet data

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

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

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

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

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

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

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

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