copy column headers into rows if it meets a specific criteria

hello

this forum have been a great help to me in my past projects and im hoping experts here would extend the same help on my current project.

this macro copies the entire row from "deadlines" X number of times in "que" sheet.

i was wondering if it is possible to copy the headings in column Q-Z and transposed it into rows if the formula result is N/A

i have attached a sample worksheet with a very detailed explanation to express what i want to happen.

this would really be a big help to me...

thanks in advance

Any help please?

Just wanted to add that number of rows in deadline sheet varies... but the number of column and headers stays the same...

Melody10,
Need more clarification!
What do you want to copy and where?

Its you again... thank you for your time.

The purpose of this file is i wanted to be able to sort all undone tasks according to deadline. That is why i wanted the tasks to be in rows rather than columns.

So for example aaaa, task 4,5,6 are not yet done (they are marked as n/a). What i want is that when i run your macro, the task name will be listed in que sheet. So if 3 tasks are not yet done, entire row will be copied 3 times in the que sheet and eac row will be marked for each task under the "task" column.

I hope this clarifies my question.

You have a count if formula in A9 which calculates the N/A and code copies the rows based on A9.

"each row will be marked for each task under the "task" column"
Sorry, not clear yet to me.
What do you want to add to the code and countif formula?

"i was wondering if it is possible to copy the headings in column Q-Z and transposed it into rows if the formula result is N/A"
You have headings Q-Z as tasks. So, where do you want to copy if the heading has a N/A? Which row?

i wanted it to be copied in the "que sheet" column H.... so for each task undone there will be 1 row in the "que sheet"

thank you soooo much for your patience in me.

Try the attached

it works exactly as i wanted... just 1 tiny thing... if i added another row in the deadlines sheet, the task names are not being copied in que sheet.

the deadline sheet would have multiple rows, and your macro should work exactly as you did for row 9.

Do you mean you want to expand column Z, or add a row below 9?
At the moment you have the task row and N/A row.

add multiple rows below 9... the number of rows will vary from day to day but the number of columns will always be the same.

any luck sir ab33?

Melody,
Yes, it can be done but requires to change the code completely as it now requires a two dimension loop. Please expand the rows and attach a sample and will write you the code.

hi

please see attached file... the number of rows may increase or decrease depending on our volume

Try the attached

perfect!!! thank yoi!!!