rev

  1. D

    How to extract dates from cell, and return in date format (Jun-19)

    Hello - I have several cell that contain dates in text format. I'm trying to extract the dates from those cells & return values as a date format, preferably (Jun-19) format. Below is an example: I'm using =MID(A1,FIND("/",A1)-2,5) to extract -6/18, and then =SUBSTITUTE(B1,"-","") to get rid of...
  2. D

    Difficult Excel Formula - Populating Data from Drop Down Menu

    Hi All, I am trying to create a formula to have data populated from a drop down menu but I am unable to get it to work correctly. <colgroup><col><col><col><col span="2"></colgroup><tbody> Depending on which department you select, the data should automatically populate, but I am not sure...
  3. J

    How to filter multiple files for latest version of each file

    I am using Power Query in Excel for the first time. Got query to work fine but have too much unneeded data. Query combines 1000+ files. Each file has ~150 rows of data. Files are named using serial number (SN) and Revision letter for each file. There are multiple files of different revision...
  4. B

    Formula Help Needed

    I have the formula below I was needing a little help with. I have another cell C2 that I would like for it to look at also. If there is something in it then have formula look at it before F3. The formula below is copied down about 30 rows. C2 is by itself. =IF(ISBLANK(E3),"",F3&" Rev "&E3)
  5. U

    How to Increment a Alphanumeric String on Number of occurrences in Column

    Hello All, I have this code very close to what I need it to do but I think I need to add a counter of some sort. I'll try to explain this AS BEST AS POSSIBLE. I need this code to count how many times there is an occurrence of an Alphanumeric value in Column C and then simply increment the...
  6. U

    Copying, Renaming, and Incrementing Duplicate Alphanumeric Cells

    Hello all, I have a code below that copies the contents in columns A, B and C to the next blank row. I also need this code to Duplicate/Rename the contents in Cell C with, preferably REV 1 after it. Basically here is the format the users will be putting in Column C: LEVEL 1/ AREA A/ RM 125 I...
  7. U

    Copying to Next Empty Row and Renaming the Data

    Hello All; I have a log that users will be adjusting data based off statuses of Drawings. Starting at A11, B11 & C11: Column A is DRW NO., Column B is DRW Description and Column C is Location/Rm. Over in Column L is the status column where the user will select from drop down list. I have this...
  8. M

    sum 2D data in one sheet from another sheet

    <tbody> Account CC Acc-CC Descr Jan Feb Mar Apr 301000 000 301000 000 Alt Rev 0 0 0 0 301000 100 301000 100 Alt Rev 500 500 200 400 301001 000 301001 000 Revenue 5000 8000 10000 6000 301001 100 301001 100 Revenue 0 2000 5000 8000 301001 200...
  9. K

    How to troubleshoot run-time error 9: subscript out of range

    Hello, I have a code where I'm getting an error on my array ... the code works perfect when array is like this For Each Ws In Sheets(Array("RLN-Net Realization", "RLN-Red Rev", "RLN-COGS")) But when I add and extra sheet For Each Ws In Sheets(Array("RLN-Net Realization", "RLN-Red...
  10. M

    SUM problem

    I have a simple =SUM(A1:G1) formula here but it's not working. It's like it's missing column data and giving incorrect totals. Each result (A:G) is populated by an IF formula. Any thoughts why Sum would not be working properly? Auto Calculation is on, which is the only thing i can think of...
  11. N

    Hide/ Unhide - xlSheetVeryHidden

    Hi, I am looking to hide an array of worksheets as shown below; Worksheets(Array("Data Log", "Rev. History", "Visual Set Point")).Visible = False This works great to hide the worksheets, however what I am really looking to do is, very hide the worksheets, something like this...
  12. M

    Compiled Latest Revisions

    As shown in below screen shot I have three revisions. Some sheets has all three revisions but has either one or two only. In the last column (TERMED AS FINAL in BELOW ) i need to show the latest revision. <tbody> SHEET REV. 01 REV. 02 REV. 03 FINAL P029-DDD-STR-0001 A B P029-DDD-STR-0002...
  13. srizki

    Date with text formula.

    Hi all, I have the following formula in column “U”, '=IF(I37="","",IF(I37="BIL",LEFT($U$8,4)&" JIB",IF(I37="NON",LEFT($U$8,4)&" REV"))) I want to update it so that instead of, LEFT($U$8,4)&" REV"))) it should read the date from column, “M”, and take the previous month, so if the date is...
  14. G

    Convert Data in Columns to data in rows - Transcribe doesn't do what I need

    Hello, I have a workbook with data formatted as follows: <tbody> A B C D E... BZ 1 Location Item DType Week1 Week2... 2 100 ABC qty 3 5 3 100 ABC rev 30 50 4 100 DEF qty 0 3 5 100 DEF rev 0 90 6 101 ABC qty -1 5 7...1MM+ 101 ABC rev -8.5 42.5 </tbody> Where the weekly...
  15. L

    Create worksheet tabs from a range of cells but do NOT create duplicates

    I have a spreadsheet with multiple part numbers and in many cases, duplicate part numbers. There are 10,000 rows! <tbody> F G AO 1 000746-A-1 REV H <tbody> 000746-A-1 REV H OP-10 </tbody> <tbody> SHEAR 1st PC FOR INSPECTION Use 14 Gage (.075") 304SS, Shear strip to 3.25"Wide Move to...
  16. M

    Colouring in between lines

    Hi all, I have a chart showing revenue and costs by month. There are some months that rev is greater than cost and other months when the opposite is true. I wish to shade in between the lines e.g. when cost is greater than rev red, whilst when revenue is greater than cost say green. I have...
  17. A

    Convert table into list format (live)

    Hi, some of the team are updating data that is in the format below (Table A): Table A Country Region Metric 01/02/2018 02/02/2018 03/02/2018 04/02/2018 05/02/2018 06/02/2018 07/02/2018 UK Region1 Sales 1 2 3 4 5 6 7 UK Region2 Sales 6 6 6 6 6 6 6 US Region1 Sales 11 12 13 14 15 16 17...
  18. C

    VBA - Custom Format "00" if cell contains number

    I have a list of Revisions and I basically want to make sure that any revision that is a number (NOT a letter) is custom formatted "00" so it shows as a Rev. 01, 02, 03, etc and NOT just Rev. 1, 2, 3. I want this to be via VBA as I have an Excel Add In I am creating for other users. There are...
  19. D

    MAX(INDEX(MATCH(LARGE(IF(PERCENTILE array formula... OH MY!!!

    Hey Everyone! I could use some assistance in getting past a wall I've come upon. I'm needing to calculate the MAX value of a column after scrubbing the top 10% & bottom 10% from a separate staffed column using a Percentile formula. These two Formulas are pulling the Top & Bottom Staffed...
  20. D

    Cell contains a value then copy and freeze other cell

    Not sure if this can be done but it would be very useful to me if it would work. What I’m wanting to do when I click a button: 1. On sheet “Job Notes” Cell F24 - Contains a text value “INTERNAL DESIGN PRESSURE 1500 PSIG @ -20 °F AND 250 °F “ 2. On sheet “DO NOT CHANGE” Cell C5...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top