help in need!!

hello,new to VBA so I was hoping someone could help me out. I've looked through this website and online and can't find a solution. The below Macro will run on different tabs so it will go through columns of different row numbers. Therefore, I need to make my SUMIF and ranges Dynamic so they...

Hello, Please could you help me? I am a complete novice at Excel and am trying to save myself lots of time! I need to search for 1502 staff details in Excel 2007. I need to search 9 different tabs to input consolidated info into tab number 10. Each of the 9 tabs contains the following...

Hi there, I've found a number of threads that deal with a similar question but none exactly the same so bear with me! Also new to this forum so I may not explain myself 100% but really appreciate all the help!! I have a large table of data on Sheet "Quote Register" The data input fields are...

I'm building a tracker that's looking at recurring expenses from four different locations. Because I added a table to excel, it won't let me share the book, so I want this one table or range to populate/pull the information as its updated on the other four products. This table needs to expand as...

Hello I used this formula to help me find a full match by writing down a partial string in an empty cell next to a contact list of the company I'm working for. =IF(ISERROR(...

Hi, I have an issue trying to lookup a text cell when certain criteria are matched. On sheet one I have the Order Date (Column C) and Fleet Number (H) columns On sheet two I have contract start date (P), end date(V), fleet number(I) and maintenance status(Z). I need a formula that will match...

I am trying to sort exposure, largest to smallest by column K, but using the sort function isnt working. The company name is in column A, and doesnt change accordingly with the sort in K- I think this is because the data is locked via SUMIFs from other sheets. e.g...

I have to upgrade a pricing sheet, increasing all numbers by 4%. I want to know how to add the percentage to each number and have that same cell equal the TOTAL. Already know how to copy, paste special, the value, then multiply but that only gives me the 4% increase number in that cell, I need...

Hey you guys! - I need your bright excel minds for some help/inspiration with some data structuring in excel! The specific task at hand is: Create a tool where the team is able to filter by city and select multiple dealers. All the relevant listings should appear in a way that is easy to...

Hello, I have been tasked with a project of taking files (csv or excel) from customers containing a large amount of data, none of these files are the same between customers. I have to take the data, extracting some columns and arranging them into a certain format, exporting the formatted...

Hello, I'm asking for some help with a formula. I'm making a booking system for a theatre and i'm trying to make it show how many seats are available in a certain category. I've set it out like this, http://i.imgur.com/R6fag7I.png So this is what i need help with, I want it so i looks for...

Hi Guys, Long time user but first time poster. I have always been able to find solutions and model them to my usage from this gem of a website. Kudos to the content here. I have a deadline on Monday and need to somehow gather a lot of info from a thousands of rows of product...

Hi All,</SPAN> I have searched high and low, so apologies if this has been asked before.</SPAN> I am not sure if I am pushing Excel further then what it is cable of</SPAN> I have a work book with a table that goes from A12 to Z468 that is used for reporting purposes. </SPAN> My header row...

Hello, I have been working on this project, and thanks to the amazing help on this forum so far have been making some great progress. I am at a roadblock again, and hoping the great minds here can help. As mentioned, I want to grab the Scheduled From/To & Actual From/To for each agent, and...

Hello all professors out there. I have searched the forums but at a loss on this one. If it can be done via formulas rather than VBA great but willing to try anything at this point! I have two sheets. The first sheet contains a long list of Postcodes of our customers and I am trying to do the...

Can someone help me understand why? Problem This code does not work Sub Cover() ' ActiveWindow.ScrollWorkbookTabs Sheets:=12 Sheets("(3) Cover Sheet").Select Range("F41").Select End Sub This Code does work Sub GoTo_Tab_11() ActiveWindow.ScrollWorkbookTabs Sheets:=12...

If anyone can do this lab that is due Wednesday for me I will honestly paypal you $10. I know this is a breeze for most of you and I would typically try and knock it out myself but I have a Prob&Stats exam tomorrow and a Deterministic Exam Wednesday that I really need to focus on and have no...

Hi, I have a drop down list of 15 options each saying 'Weekend Period 1', 'Weekend Period 2' etc. Further to the left on the same sheet i have information under each of them titles. I want to be able to select any of the 15 options on the drop down list and the text under the title which is...

I need help please i´m trying to use .find with two criteria true the code below but only Works for the first result, i mean need to find the row where the code (criteria1-column a) "código" and the center(criteria2-column b) "centro" matches then to bring me the offset value from colum e, but...

Im only looking for help on a bunch of questions and I am going to be posting them one at a time upon explanation of why that is the answer. I actually want to understand the reason behind so if you can help, thank you very much? Question 1 Given that A=12, B=13, Z=3 at the start of the...