Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    90

    Re: Split each row into individual files

    Awesome, thank you!!
  2. Replies
    4
    Views
    90

    Split each row into individual files

    I have a very large table that includes thousands of rows. Row 1 is the header and I'd like to extrapolate each subsequent row to its own file, keeping the original header, and save each using the...
  3. Re: Formula to populate either "Up" or "Down" based on location of entry in Column A

    Thank you!!
  4. Re: Formula to populate either "Up" or "Down" based on location of entry in Column A

    Thank you, this is exactly what I was looking for!!!
  5. Formula to populate either "Up" or "Down" based on location of entry in Column A

    I have three columns. Only one cell in column A will have a value, which will be "Active". Column B is locations. In column C I'm trying to get anything that at or below the "Active" indicator to...
  6. Re: Copy from active sheet to on-going list in another sheet

    PERFECT!!! Thank you so MUCH!
  7. Re: Copy from active sheet to on-going list in another sheet

    Works great, one thing though. The first two cells contain a formula, so I get a #REF ! error. Is there a way to get it to paste value?
  8. Copy from active sheet to on-going list in another sheet

    Could anyone help me with VBA for copying data from active sheet and pasting in the first available row in sheet titled Archive. I'm trying to copy Range A2:G2, paste in the first available row in...
  9. Replies
    5
    Views
    373

    Re: Assign people to groups of 9

    Thank you
  10. Replies
    5
    Views
    373

    Re: Assign people to groups of 9

    Perfect, thank you!!
  11. Replies
    5
    Views
    373

    Assign people to groups of 9

    Is there a way in a new column to group people in groups of 9? The first 9 people would be in group 1, next 9 people would be in group 2, etc?
    <tbody>
    Person 1
    1



    Person 2
    1
  12. Replies
    3
    Views
    178

    Re: lookup for multiple returns

    Perfect, thank you!
  13. Replies
    3
    Views
    178

    lookup for multiple returns

    I have a workbook that has employee info in sheet1. Sheet2 lists the employees dependents with corresponding employees social security number in column A. Some employees have multiple dependents...
  14. Re: VBA to copy values down and removed excess rows

    Awesome, worked great!!
  15. VBA to copy values down and removed excess rows

    When I export my payroll to include employee's pay for the entire year, the software includes each pay period but only lists the employees name once. What I would like to accomplish is to copy their...
  16. Re: Referencing above/below based on two column values

    Thank you admiral100!!
  17. Referencing above/below based on two column values

    I'm trying to reference Above/Below by looking at column range AF48:AF61 and looking for the word "Red". The second reference is "Base" in column range AH48:AH61. If Red is in a Row above Base, I...
  18. Replies
    0
    Views
    120

    Over time/splitting hours Time sheet

    Our company time sheet database is created each week, with each job performed entered each day. Everyone's time is entered as regular(REG) by default. Currently we have to go in and look and see if...
  19. Re: Find first non #N/A value in either direction

    Could Offset counta be used to create a dynamic range instead of defining it B1:B14? Both columns A and B will have the same amount of values displayed, even in the instance when there are less than...
  20. Re: Find first non #N/A value in either direction

    That worked, but unfortunately the workbook has VBA that not only deletes the previous set of data but also the table when a new sheet is created. The workbook has a password and I don't have access...
  21. Re: Find first non #N/A value in either direction

    I found the issue, in one area there were only 12 zones, so Zone13 and Zone14 values were blank. In that instance, Zone2 was selected instead of Zone1. Typically there will always be 14 zones, but...
  22. Re: Find first non #N/A value in either direction

    Very close, the only issue is being at the top in Zone1. The lower limit will always have duplicate values. So, if in Zone1, both Zone1 and Zone2 will have the same values. Same for Zone14, Zone14...
  23. Re: Find first non #N/A value in either direction

    <tbody>
    Zone1
    1
    150


    Zone2
    1
    140
  24. Re: Find first non #N/A value in either direction

    Ron Coderre, would it be possible to expand the formula, for an instance that there are no #N/A errors? Moving down in elevation from Zone1 would be in ascending order and moving up from Zone14...
  25. Re: Find first non #N/A value in either direction

    That works PERFECTLY!! Thank you so much!!
Results 1 to 25 of 140
Page 1 of 6 1 2 3 4