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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top