expert

Hey Everyone I really hope someone can help me with this! I am doing a VLOOKUP match-up between company names in one column, and company names in another column. The company names have an inconsistent format (like HeroSwap, Inc. in one column and HeroSwap Incorporated in the other). I've...

Hi Guys, Looking to get this solved. Trying for hours to fix it, but not really sure how. Task: Trying to calculate a loan amortization schedule with multiple loans, which also include a interest only (IO) period. I also want to have the option to set multiple start dates for the different...

Hello, This is an excel problem that I really need help with for my work. Thank you very much for your help. I placed entirely what I'm trying to do in this post. I don't really know how to do any of this and don't know if this is the correct approach. Please forgive me if this wasn't...

I have been exhausting myself trying to appropriately create a macro that delete entire rows in my worksheet A2:LastRow of data based on certain criteria I have been working on creating a macro that deletes entire rows of all data if anywhere in the row there is a blank cell. Unfortunately, the...

Hi Everyone! As my username suggests, I am very new at VBA with Excel; however, I am really trying to create macros that can be utilized whenever. The one I am working on is one for my data. Its purpose is to sum Row 5 cell all the way down to the last cell row of data in the specified column...

Right now I am working on a macro that creates new columns and fills those specifically placed columns with a certain function; however, I cannot let my macro be dependent on where they are able to refer to for the function. Just like the macro is designed to not be dependent where it may place...

I have a huge spreadsheet of locations with lat and log. I need to calculate the distance between all locations from each other within a specific state, as well as finding the locations closest to each other. I have the basic formula for calculating distance between point A and point B. Is...

Hello, I am using a table that contains these three columns. I want to be able to identify them as individual records (1,2,3...). Separate line items could have the same value for two columns, but one of these three columns values will be different (bottom row of example). I am going to be...

Hello, I have a report for work to do: <tbody> 2/02 part# <tbody> AB11 </tbody> <tbody> AB12 </tbody> <tbody> AB14 </tbody> <tbody> AB17 </tbody> <tbody> Part </tbody> <tbody> Entry date </tbody> <tbody> Stock at entry date </tbody> stock 3 2 3 4 <tbody> AB11...

Hello Excel experts! I consider myself an expert user of Excel but I really got stuck on this problem :confused: . I prefer a solution with built-in formulas but if that isn't possible a VBA solution is fine. I have one table (the Rating table) where I occasionally put in data that is event...

Dear excel masters, Currently I’m struggling with a personal master thesis exercise, which I believe is for more experienced excel practitioners. Also my teacher cannot help me with this excel challenge. I can e-mail my simplified excel example sheet to keep the exercise organized and hopefully...

Hello there! I'm new to the VBA-scene and I'm learning this for work. Learned a lot the last few weeks but now my boss is asking me something I can't figure out. (Using MS Office 2010) I did +300 Charts manually last week(s) and would like (love!) to put it in some macro's. The braindead...

I have an excel sheet where column "B" has a list of style numbers . I also have a folder with pictures of each product and file name of the pictures are the product code. I would like to place the picture of each product in column "A" beside their respective codes. If possible, I would also...

I do mailing lists and I have to clean up the list so only one household get a mailing. I use this formula to merge first names if the last name and address are the same. =IF(AND(D3=D2,C3=C2),B2&" AND "&B3&"", B2) As you can see this will merge the first name, add "and" then merge the second...

This might be something simple to you experts. I'm updating a order sheet for products and most of these stores pick and purchase a package A or package B. As I try to explain visually below...I have a list of products going down and I would like to have 1 Drop down menu named "Pick order" In...