1. A

    Trouble with a Double Line Chart Using Two Date / Value Series

    Hi Folks. Is there a way to chart (see data below) the "Original SA #" as one line attached to the "Original SHSD Ready Date" and the "Current SA #" as a second line attached to the separate date series "Current SHSD Ready Date" all in one chart so it aligns as a single time series on the...
  2. A

    Can't make it work?

    If H8 is less then D2 say "Not Ready", If H8 is between D2 and F2 say "All Most", If H8 is more than F2 say "Done"
  3. N

    VBA - Quick question

    Hey all! I'm sure this is an easy one, but I'm not very familiar with VBA. Essentially I'm trying to hide a submit button until one of the two selections are made from a drop down in I8. The below works for one phrase, but I can't figure out how to add another phrase to it. I want it so if...
  4. D

    Copy and paste from hidden sheet

    I am running the following code to copy and paste from a hidden sheet. I used macro recorder. Sub test12()' ' test12 Macro ' ' Application.ScreenUpdating = False Sheets("Make Ready Board (2)").Visible = True Sheets("Make Ready Board (2)").Select Range("A2:R2").Select...
  5. S

    Adapting Code to Reference other Cell

    Hi, I would appreciate some help adapting the code below. What I want to be able to do is - When the text "Ready" appears in cell K3 on sheet 1. I dont want the data from Sheet1F3 to be displayed. I want this cell to be blank. The text Ready is sent from 3rd party software which I connect excel...
  6. S

    macro to open find dialog box ready to search in values in workbook

    Hi there I would like a macro that results in the find and replace dialog box being open with the following settings/characteristics: -ready to search in “workbook” -ready to search in “values” -the text string “unfinished:*” in the “Find” field -the cursor placed immediately after the...
  7. M

    Formatting help to make large dataset pivot table ready

    Hello, I am working with a fairly large dataset with ~120 Columns and 10,600 rows that I need to make pivot table ready. However, I am not sure how to approach this given the layout of the data output as is (Please see image Your help would be much appreciated! Thanks!
  8. M

    formula needed to extract time from text please :)

    Hi All, I'm needing a formula or assistance please in pulling out the time from the below fields: In this example I want to copy the 12:36:29 from A1 to B1 Similar for A2, copy the 12:38:54 to B2 Thanks for any assistance :) <tbody> A B 1 12:36:29 user not ready OPD after call work...
  9. J

    macro to navigate & close several excel files

    Hello Everyone, I don't really know how to approach this problem, but I'm hoping for some guidance. Semi-related previous post: I have a code that will make an excel file "client...
  10. H

    VBA to Click Link

    I have been searching for a way to click a link with VBA. I can navigate to the page and do all the steps but, for the life of me can not find the answer to how to click this button. I can't use the href as it changes each month and I would like to make this as simple as possible. Maybe I am...
  11. O

    Multy function Button VBA

    The attached code is not working as I would like The wish I have is 1 button with multi functions each allowing different texts to populate the Button so I can easily see whats happening with the workbook. By default the first Text in the Button would be "Ready" In Yellow Then if I press on...
  12. S

    pivot table count based on criteria

    Hi Everyone, I have a table where it shows logs of different users working on a claim. I want to be able to create a pivot table but the count on the "Status" field should satisfy two conditions. For this scenario, I want to count the "Pending" status for User1. For User1 to have a count, User1...
  13. J

    Append rows from 1 wb to bottom of another wb based on column values

    I've used this site many times for tips so thank you, but never posted a direct question. I'm an excel hack and I can do this task with a few 'hacky' clicks but I now have to put it into a macro for an 'end user'. 2 open workbooks: Daily Despatch Report & Ready to Invoice I need to copy all the...
  14. B

    Creating a dynamic range using Index

    I'm using the index match formula as my lookup formula: INDEX('All SCC Ready to Import'!$A$2:$A$800,MATCH('LocalStateSCC Falcon Positions'!H30,'All SCC Ready to Import'!$E$2:$E$800,0)) I would like to make this lookup dynamic without having to change the range from A2 :A1000 for example. I...
  15. B

    Nested formula

    I'm looking for a formula that will provide the following result: If b9= selection "a","b",or "c" and b11 is populated then result would be "ok to save" If b9= selection "D", then look for B20 and if it is populated the result would be "ok to save" otherwise result would be "not ready to...
  16. S

    Send email based on Cell value

    Hi I have one excel file which is shared with many departments ( like sales, purchase , distribution and finance) In this file we capture all sales orders and the status ( using drop down) of it. ( status are like, PO waiting, Approved drawing submitted, Ready to go, Material received...

Some videos you may like

This Week's Hot Topics