xxxxxx

  1. J

    Sum / Lookup formula -Query

    Hi, I have the below tables and I am trying to match back avalue from a separate product table & then output a calculation dependingon the value found. I have the below formula which looks fine to me but I cantfigure out why it only returns a 0 value. The formula should find Product...
  2. S

    Extract data from separate worksheet

    First, apologies for vagueness as I don't really know how to approach this. I am exporting reports that are providing customer info that I need to consolidate into single lines. Unfortunately, the export is designed in a pdf/printable report format. The objective is to copy updated data into an...
  3. S

    Help to brown to folder and load file name then check if string in filename exist

    Hi all I have folder with a lot files like: xxxxxx-yyyyyyyy-zzzzzzzz-wwwww-aa-b-cc with extension: .xlsx .xlx .rpt .doc .docx Please help me with macro VBA to do that: 1. Brown to folder and get all files full name include extension: .xlsx .xlx .rpt to sheets("data") begin from range ("A2") 2...
  4. G

    Trying Post Document

    I am researching my Great Great Grandfathers time during the Civil War. What started to be a simple Excel file has grown to a large file, 25000+ rows. Not what I planned for but the further I got in the research the more I expanded to included all members of his units. I am new to VBA and...
  5. R

    get specific ID in cells

    Hi All, need your assistance on creating formula to get specific number in cells. Currently i have many rows, please see sample below, each id has 11 characters and can be start with 10000 or 20000 <tbody> Description ID (expected result) please use this id 10000428271 to fix this issue...
  6. R

    Get the weekday

    Hi We have job requests that come in a specific format. Most of it is fine, but we would like to change the start and end dates to include the days of the week. The current format is; Ref: HH65161651 Job role 12345 | xxxxxx xxxxx site xxxxxxx Rota: 21:00-09:30 238073 From - 18/01/2019...
  7. R

    help with get just the name out

    I have this and I need to get the first and last name out so I can use them for a vlookup please help Richard XXXXXX 1993446666 Tom XXXXXXX 1993444444 I am using this =RIGHT(G7,SEARCH("",G7,10)) but I need to use the name now
  8. H

    Cant drag formula down column

    I am not much good at this and any help would be appreciated. I can’t drag formula down column. =Sum($E59:E164)/105 =Sum($E59:E165)/106 Note division is Ascending by each entry Drag gives: =Sum($E59:E164)/105 =Sum($E59:E165)/106 which is correct...
  9. Nelson78

    Vba: running a macro at a future date and time

    Hello everybody. I need to schedule a macro for 13/05/2018 at 20:00 In this workbook, I have to write something like this: Private Sub program() Application.OnTime TimeValue("20:00"), "xxxxxx" End Sub But: 1) how can I add the date? 2) could the date format be a problem? Of course, the...
  10. I

    Copy paste entire row below the cell that contain specific word

    Good day to you all. As the title implies, I would like to copy entire row and paste it at the SAME WORKSHEET below the cell that contain specific word. For example, <tbody> A B C XXXXXX ABCDEFG/123456 YYYYY </tbody> I would like to change the above table to : <tbody> A B C XXXXXX...

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