ground

  1. P

    textbox cannot enter letters and numbers

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

    Delivery Dockets & Invoices for Budgets

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

    can i set a custom background for a cell from external file as a fill?

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

    Tagging Data in Excel

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

    Date Comparisons With Time Limits

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

    Macro not working 100%

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

    Conditional Formatting

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

    Summarising totals

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

    VBA Coding Query/ideas

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top