Search:

Type: Posts; User: Magoosball; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Finding the Min and assigning to that category

    I have a spreadsheet with 2 separate sheets set up as follows

    List


    Department

    Shift
    State
  2. VB add new row with unique date by candidate id

    Hi

    I'm trying to write a VB script that states from row 2 to last row; if the sales number (Column C) is greater than 10 then create a new row at the bottom of the data set with the same candidate...
  3. Re: VBA: Sorting data with dynamic heading location.

    Worked like a charm. Thank you so much! Sorry I should have clarified that in my original post.
  4. Replies
    8
    Views
    2,054

    Re: Sort sheets according to list

    Hi Peter -- Is it possible to modify this to move the worksheet if only part of the worksheet name is found in column A?

    I have about 20 worksheets and they have the same base name followed by...
  5. Re: VBA: Sorting data with dynamic heading location.

    Maybe it would be easier to select the entire column and apply a filter?
  6. Re: VBA: Sorting data with dynamic heading location.

    This is close!
    1) The cells should be sorted starting on row 14. This macro is sorting them and the lowest value is starting on row 9 and the cell that contained "Revenue" on row 13 is now erased...
  7. VBA: Sorting data with dynamic heading location.

    I have a list of headers in row 13. I am trying to find the header titled "Revenue" and sort in descending order.



    lCol = WorksheetFunction.Match("Revenue", Rows("13:13"), 0)
    Rows("13").Sort...
  8. Re: VBA - Loop through all dates between 2 dates creating new sheets

    Thank you for the prompt response. I was pretty dang close to getting it on my own ! I was able to get this working. I had to delete the "-1" from the end of "For x = Range("C7").Value To...
  9. VBA - Loop through all dates between 2 dates creating new sheets

    Hello

    I have a start date in cell C7 and an end date in cell C9. I'm trying to write a macro that will create a new sheet for each day between the 2 date values and name the sheet the weekday of...
  10. Replies
    2
    Views
    201

    Array based formula help

    Below is a sample of my data

    Table 1:

    <tbody>

    From Date
    To Date
    Yes or blank
  11. Formula: If condition is false don't change current cell value

    I am trying to create an excel sheet that keeps track of my teams progress throughout the week. I put an example of what I currently have below as well as the formulas.


    <tbody>
    Name

    Complete...
  12. Re: VBA copy row to new sheet if cell value isn't found in rance

    Thank you Fluff! Like always it works perfect!
  13. VBA copy row to new sheet if cell value isn't found in range

    Hello I'm trying to write a macro that will copy an entire row from sheet2 and paste it to the bottom of sheet1 if the cell value in column f sheet 2 doesn't exist at all in column f on sheet 1.
    ...
  14. Combining cells from different rows under multiple conditions

    I'm trying to write a VBA script that will turn table A into Table B


    Table A:


    <tbody>


    Name
  15. Re: VBA: Making specific text on a worksheet bold

    This worked!! Thank you!
  16. Re: VBA: Making specific text on a worksheet bold

    Hi Mick,

    Thank you for the response. This isn't making anything bold on my spreadsheet and I'm not sure why. To stop the confusion, I created a table here that shows what should happen. Anything...
  17. VBA: Making specific text on a worksheet bold

    Hello

    I am trying to write a script that will look through column b (To the last row) for the specific text "Text to Format" and make this text bold. I don't want to make the entire cell bold,...
  18. Re: Macro that selects read only any time excel opens

    I am still getting this message box when excel opens. Not sure what I could be doing wrong
  19. Re: Macro that selects read only any time excel opens

    How would I make sure that this script fires anytime excel is opened? The read only message box appears the moment excel is opened.
  20. Macro that selects read only any time excel opens

    I have moved my excel personal macro workbook to a shared drive and have created a shortcut into the XLSTART folder for everyone on my team. This way whenever I update one of my macros it updates...
  21. Re: VBA Loop to combining cells in a column into a single cell

    Hi Mick,

    The above is still working great! I use it every day and it has been a great help!
    What if instead of separating by comma I wanted to put each as a separate bullet point? Is this...
  22. Re: VBA: Updating a master sheet based off 2 conditions

    Hi Fluff,

    I am running into an issue with this code and am working on trying to fix it.

    2) On the same workbook as before, lets say there is a row on sheet where the contents of cells D and O...
  23. Replies
    5
    Views
    2,225

    Re: VBA find value in column

    Overall I was looking for VBA because this is part of a much larger script.
    This worked really nicely as well. Thank you both!
  24. Replies
    5
    Views
    2,225

    Re: VBA find value in column

    Just tested this. It worked! Thank you!!
  25. Replies
    5
    Views
    2,225

    VBA find value in column

    I am trying to write a for loop that will try to find each value in sheet 1 column A in sheet 2 column A. If the value in sheet 1 column A exists anywhere in sheet 2 column A then do nothing. If the...
Results 1 to 25 of 54
Page 1 of 3 1 2 3