ground

Hi hope youcan help me please, I have attached the file below which I am stuck on, I havea user form ‘enter expenses’ but when I try to enter number/letter combinationin the boxes for Airfare, accommodation, ground transport and food and drink,the box goes red when I click on update and it...

Hi all, Bear with me for the incoming long post. I need to explain what I’m looking for. I work in the financial side of construction. So I work with a lot of budgets and products. Delivery Dockets and Invoices etc. I have a spread sheet that works amazingly for certain products/deliveries...

can i set a costume back ground for a cell from external file as a fill?

I don't think "Smart Tags" are my answer here. I have a column with lots of anecdotal data in it, and I would like to be able to sort it into various buckets. I can add columns for each "bucket", and either have it checked or not, but that seems like overkill. Is there a way to just add tags...

Hey all, I did a search but the 'If' function is able to encompass so much I wasn't successful in finding what I'm looking to do - forgive me if I just missed it (or I'm not looking for the right function to efficiently show what I need - a real possibility!) I have a list of projects that I...

Hi guys I have the following macro: Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range If Target.Cells.CountLarge > 1 Then Exit Sub Set rng = Intersect(Target, Union(Range("E4"), Range("A10:A19"))) If rng Is Nothing Then Exit Sub Select Case rng.Address(0, 0) Case...

Hello to you all and weekend wishes. I am devising a Gantt Chart for flying school and ground school. in one row I have the number 18 in certain cells and this represents cadets in ground school in the row beneath I have cells that have 18 in and this determines cadets in flight school and then...

Hopefully a straight forward answer to this one... How do I get the totals for items that are the same in each column totalled. Need 1-2 (4.308+4.274), 3-11, 12-13 etc. I know it's easy to do it based on the sample below, but I've got tons of pages of data like this...

Hi all, I am writing some code to fix up some survey information. The type of data I receive has a x, y and z co-ordinates for the same points, lets say a shot at the ground line, a shot at the top of a structure and shots part way up the structure. The software that will be importing this...