Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. For Loop with data formatted as Time (hh:mm:ss)

    Hi everyone,

    I'm trying to create a for loop that iterates through each row in Column M. The data in this column is formatted as a time (Hours:Minutes:Seconds), I would like to flag any data (by...
  2. Replies
    19
    Views
    420

    Re: How to copy and paste based on the headers

    It is visible data, consisting of text mostly, with 2 columns formatted as dates. Yes, Publisher cell is the header in Row 8 of the activity tracker.
  3. Replies
    19
    Views
    420

    Re: How to copy and paste based on the headers

    Actually, I think I found a workaround by autofiltering - so the blanks are at the bottom of the cells!

    Thank you so much for your help!!!!
  4. Replies
    19
    Views
    420

    Re: How to copy and paste based on the headers

    No merged cells!

    It varies, but the data typically doesn't surpass the 150th row (from the source page)
  5. Replies
    19
    Views
    420

    Re: How to copy and paste based on the headers

    Hmm it does include the blanks when it's copying. But now it's copying all of the data from the source worksheet (8 extra columns), but only up until row 47 when there are 83 rows for this specific...
  6. Replies
    19
    Views
    420

    Re: How to copy and paste based on the headers

    **Rather, the 3rd piece of cod worked the way I wanted it to

    Exactly! For example, if I want to collect data from the "Publisher" column in the source worksheet, but there are multiple blank cells...
  7. Replies
    19
    Views
    420

    Re: How to copy and paste based on the headers

    **Rather, the 3rd piece of cod worked the way I wanted it to

    Exactly! For example, if I want to collect data from the "Publisher" column in the source worksheet, but there are multiple blank cells...
  8. Replies
    19
    Views
    420

    Re: How to copy and paste based on the headers

    Exactly! For example, if I want to collect data from the "Publisher" column in the source worksheet, but there are multiple blank cells throughout the column, the code only copies up until the cell...
  9. Replies
    19
    Views
    420

    Re: How to copy and paste based on the headers

    The second piece of code worked exactly the way I wanted! Thank you so much.

    One small thing that I haven't been able to figure out is how to get the code to skip blanks on the source data...
  10. Replies
    19
    Views
    420

    Re: How to copy and paste based on the headers

    Got it, that makes sense! What I'm trying to do here is a little different than what I explained originally, but I am attempting to find the column header "Publisher" in the "Activity Tracker -...
  11. Replies
    19
    Views
    420

    Re: How to copy and paste based on the headers

    Thank you for your time! What would the logic behind that be, just out of curiosity?

    Below are the tables I am trying to copy and paste the data from




    ...
  12. Replies
    19
    Views
    420

    Re: How to copy and paste based on the headers

    bump
  13. Replies
    19
    Views
    420

    Re: How to copy and paste based on the headers

    bump
  14. Replies
    19
    Views
    420

    How to copy and paste based on the headers

    Hi everyone,

    The code I have does what I would like it to do, however, I would like to change how it selects the data. Right now, it copys and paste data based on the location of the cells. Now, I...
  15. Re: Using a for loop to change dates based on user criteria

    Hi everyone,

    I was able to figure more of this out, but for whatever reason, the last 2 cells of both columns are not changing even though they should be.. Does anyone have thoughts on why?


    ...
  16. Re: How to auto-fill until the last row of data based on user-specified input on a separate worksheet

    Thank you so much for your help! This worked exactly the way I wanted it to.
  17. Using a for loop to change dates based on user criteria

    Hi everyone,

    I'm trying to create a for loop that iterates through rows of a data located on "Master Publisher Content." I am trying to code it so if data in column G is less than the...
  18. How to auto-fill until the last row of data based on user-specified input on a separate worksheet

    Hi everyone,

    I'm trying to autofill column A in "Master Publisher Content" based on a user-specified value in "Enter Info" in cell H3. The catch is that I only want to fill column A based on the...
  19. Re: How to filter and delete rows of data based on user-specified date

    I've been trying to troubleshoot this myself, but now for some reason it isn't deleting the rows with blanks in Column G, but everything else is working exactly the way I would like it to!

    Small...
  20. Re: How to filter and delete rows of data based on user-specified date

    Also, I tried reversing the "<=" in their respective fields and it would delete the rows of data that fall within the date parameters
  21. Re: How to filter and delete rows of data based on user-specified date

    You're the best!!

    "what about a data that starts before the specified start and finishes after the specified end, it would have data within the period ?" <-- this is EXACTLY what I've been...
  22. Re: How to filter and delete rows of data based on user-specified date

    For the blanks cell, I've been playing around with this code in the if/elseif statement

    If Columns(1) <> "" Then
    .Offset(1).Resize(lngLastRow - 1).Delete
  23. Re: How to filter and delete rows of data based on user-specified date

    Hi, thank you so much for your help! I really appreciate your time

    This is great so far, except it's doing the opposite of what I would like. I apologize for being unclear, my goal is to keep the...
  24. How to filter/delete rows of data based on user date

    Hi everyone,

    Iím having some trouble here, would love to have some feedback on the code I have so far. I have data that Iím trying to filter based on the start date and end date. The Start and End...
  25. How to filter and delete rows of data based on user-specified date

    Hi everyone,

    Iím having some trouble here, would love to have some feedback on the code I have so far. I have data that Iím trying to filter based on the start date and end date. The Start and End...
Results 1 to 25 of 34
Page 1 of 2 1 2