simplifying

Hello, I'm trying to streamline a work process with an excel spreadsheet. I want to be able to make a price calculation via a spreadsheet. The problem is – I have too many columns to pull data from. I’m looking if there is an easier and cleaner way to make the document work. At the moment the...

Hi just wondering if anyone would have any ideas on simplifying this formula...

Hi guys, I've just started working on VBA this week and I was writing a small piece of code. I am just wondering if there is a way to simplify the following: If ActiveCell.Value < 0 Then ActiveCell.Interior.ColorIndex = 3 ActiveCell.Font.Bold = True ActiveCell.Offset(0,1).Value =...

Hello Everyone, This is my first post on Mr. Excel, so I hope I'm not doing anything incorrectly regarding this post. So I work for a financial institution and I'm working on an asset reconciliation. The problem with this reconciliation is that we are comparing our holdings against multiple...

I'm have an excel sheet (sheet1) in which a user can enter characteristics about a "group of people". When all the necessary characteristics are filled in about a specific group of people the user has to push a button, so that all the characteristics will be copied to another sheet (sheet2). In...