Copying row to a different sheet based on condition

[narvaezm001]

Hello,

I wanted to know if it was possible for me to be able to copy a whole row into a different sheet based on a column value. For example, if B6 = CLOSE, the whole row would be coppied to the sheet name CLOSE. If B6 = OCCUPIED it would be copied to sheet name OCCUPIED. I also need if W7 = to a date thats passed today it would be added to the sheet name EXP PRD. An off topic question, i have this code for collumn "W":

=COUNTIF(W6:AD155,">"&TODAY()+15)

It works just fine, but I also have "N/A" / "INDEF" in the blocks as well so it's not giving me the correct results. Is there anything I could do to fix it? If you would like to see the file please PM me your email so i can email it. I don't know how to upload a file so i can show what I need help on. I'm using Excel 2003. Thank you very much for your assistance.

 

[hiker95]

narvaezm001,

Welcome to the MrExcel forum.

I don't know how to upload a file so i can show what I need help on.

You can upload your workbook to Box Net,
sensitive data scrubbed/removed/changed
mark the workbook for sharing
and provide us with a link to your workbook.

 

[narvaezm001]

narvaezm001,

Welcome to the MrExcel forum.



You can upload your workbook to Box Net,
sensitive data scrubbed/removed/changed
mark the workbook for sharing
and provide us with a link to your workbook.

Thank you very much for your reply and greeting, since its already night time where I'm at my office is close. But I will do it tomorrow and provide a copy. Thank you again for your consideration on helping.

 

[hiker95]

narvaezm001,

See you later.

Please do not quote entire replies from your helper. When quoting follow these guidelines:
1. Quote ONLY if it is needed to add clarity or context for your reply. If so, then
2. Quote ONLY the specific part of the post that is relevant - - not the entire post.
This will keep thread clutter to a minimum and make the discussion easier to follow.

 

[narvaezm001]

Hello again, here's the link to the sample file:

https://www.box.com/s/q4c5gdtipfples1j22ip

The actual file has a total of 3360 box, but i still have to enter them manually.
Thank you again for your assistance.

 

[hiker95]

narvaezm001,

Thanks for the workbook (82 columns, with only 9 columns displaying the raw data) - WOW!!!!!

I am having a problem trying to understand what I am looking at, and how to resolve your request.

Click on the Reply to Thread button, and just put the word BUMP in the post. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[narvaezm001]

Sorry I didn't know how much you needed to see. I will upload the file I currently have tomorrow when I go to work and post it. It currently only has a total of 1900 rows due to me needing to check two different system we have and their hard copy file. Hence why im trying to consolidate all the information in excel. I work at the post office where I'm at and trying to keep all the current po box holder up to date. I'm trying to figure out how to automatically copy everything in a row if in column B that is either marked close or occupied on their respective sheet that is marked close box or occupied box. And on the sheet that is marked EXP PRD have any row that has their PRD (perspective rotation date)passing the current date so it would be easier for me to send notices to the box holders to update their file so if I get no response I can be able to provide a box to someone else that needs it. The first five rows is just a quick break down of the averages so its easier to see if we're effectively managing the boxes we have.

 

[narvaezm001]

I appologize for the delay, here is the link to the full file:

https://www.box.com/s/0ch794zgjgnyq6x9h2fr

Thank you again.

 

[hiker95]

narvaezm001,

There is nothing different in your latest workbook vs the prior workbook. I am still having a problem trying to understand what I am looking at, and how to resolve your request.

Click on the Reply to Thread button, and just put the word BUMP in the post. Then, click on the Post Quick Reply button, and someone else will assist you.