• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Mark an X to next available cell in the column for visible rows

Grant A

Grant A

New Member
I have file that lists wash program for last performed to next due date. The overdue are listed in column F. I am able to filter these down to as list that would put as priority to arrange as well as email out for this item.

What I would request assistance with is each time the list is filtered any row that has been nominated as overdue will put an "X" in the row's next empty cell starting from column H. Thus if next time macro would run if the same row item was listed then another X would be marked to column I and so on. The marked items would only be X noted in the column if the visible cells after filtering say with a value greater than minus 20 in column F

Attached is the data table to further assist with my problem. I had previously functioned the filtering and select to the offset row column but were unable to mark "X" in those visible rows to next empty cells in the columns from H on.

I have been searching forums but unable to find other items that would assist in this problem. Much appreciate guidance
 

Attachments

Hi Grant ,

I have not understood where filtering comes into the picture.

What is the definition of overdue ? Is it any entry where the value in column F is negative ?

If so , is an X to be put in where ever this is true ?

I have understood that each time you run the macro , a fresh X is to be put in , adding to the X which was put in the last time the macro was run.

Narayan
 
Narayan,

Column F or the overdue is calculation of column D the last completed against the time limited due or column E.

I have code to auto-filter column F to calculate the rows out to those set. Yes these are days calculation and will be negative in value.

If the filter provides the list of true values in the rows according to the value from column F then place an X in the next empty cell from column H. This marking is that if any row has been noted previously we can count how many times this has been filtered and listed in this negative state.

I have run the file with column F filtered to those values less than or equal to minus 20 then i placed X to these in column H. If run again and the value in column F continues to have true value then put X in next blank cell from column H.

Grant
 

Attachments

Hi Grant ,

You have given an example , but it is still not clear what logic has to be applied to put in an X. I can only assume that all visible cells will have an X inserted in column H or the next available column.

Narayan
 
Narayan,
Yes your assumption is correct, my thoughts to logically plan the functions would be to filter through column F to the rows of true values in this example if the value <=-20
Then place a mark in the visible rows in column H or the next empty cell against the row.
Then remove the filter and thus the example would be produced.

Grant
 
Narayan,

Tested the file and this is what am after.
Have viewed the code and can follow most of it. There is some code that is new to me and given me some further homework to develop my own skills.

Appreciate your work

Grant
 
You must log in or register to reply here.
Back
Top