VBA Code to Move Row Based Upon Condition - Same Worksheet

[savv37]

Hello,
I need some help developing a VBA code to move a row of cells based upon a cell which contains a dropdown list. I'm ok with the basic formulas however when it comes to VBA I'm clueless since I haven't used VBA in a very long time, so any help would be appreciated.

Basically my list is similar to Task List which lists projects, due dates & completion status, fairly basic stuff.

Currently I have my status' setup in a dropdown list as, without the double hyphen
--Completed
--Awarded
--Not Started
--In Progress
--Lost
--Not Bidding

I currently have VBA Code to move the "Lost", "Not Bidding" & "Awarded" to three similarly named Worksheets. What I am attempting to do now is break down my Project List into "Completed", "Not Started" & "In Progress" on the same worksheet versus breaking them out into different worksheets.

I've searched the web & various forums and all I can seem to locate is moving a row to another workbook or worksheet.

Thanks in advance for the help....

Scott

 

[Joe4]

Welcome to the Board!

Why not just use Filters, and then you can display any status (or groups of statuses) at any time dynamically simply by changing your filter selection?

 

[savv37]

It's important that I can get an immediate overview of what's happening at a glance with my estimating department, using filters means I lose the overview of whats happening.

 

[Joe4]

It's important that I can get an immediate overview of what's happening at a glance with my estimating department, using filters means I lose the overview of whats happening.

How so? You are going to need to explain that.
If we don't have a clear understanding of what you are trying to do, and exactly why some methods will not work, it is going to be difficult to help you.

What would probably be most helpful is if you post a sample of your data, and then what you want your expected output to look like.
You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[savv37]

How so? You are going to need to explain that.
If we don't have a clear understanding of what you are trying to do, and exactly why some methods will not work, it is going to be difficult to help you.

What would probably be most helpful is if you post a sample of your data, and then what you want your expected output to look like.
You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Not Started																Bid Information
2	EST. No.	PRIORITY	DUE DATE	TIME	STATUS	PROJECT NAME	CITY	DL	PROJECT SECTOR	NOTES	GC BIDDERS	ESTIMATE ($)	BUDGET ($)	CONTRACT ($)	AWARDED ($)	TO WHOM	Estimate vs. Budget ($)	Contract vs. Budget ($)	MarkUp BUG vs. EST	Estimate vs. Contract (%)
3						PROJECT NAME #1	VARIOUS DATA FILLED IN
4						PROJECT NAME #2	VARIOUS DATA FILLED IN
5						PROJECT NAME #3	VARIOUS DATA FILLED IN
6
7	In Progress																Bid Information
8	EST. No.	PRIORITY	DUE DATE	TIME	STATUS	PROJECT NAME	CITY	DL	PROJECT SECTOR	NOTES	GC BIDDERS	ESTIMATE ($)	BUDGET ($)	CONTRACT ($)	AWARDED ($)	TO WHOM	Estimate vs. Budget ($)	Contract vs. Budget ($)	MarkUp BUG vs. EST	Estimate vs. Contract (%)
9						PROJECT NAME #11	VARIOUS DATA FILLED IN
10						PROJECT NAME #21	VARIOUS DATA FILLED IN
11						PROJECT NAME #31	VARIOUS DATA FILLED IN
12
13
14	Completed																Bid Information
15	EST. No.	PRIORITY	DUE DATE	TIME	STATUS	PROJECT NAME	CITY	DL	PROJECT SECTOR	NOTES	GC BIDDERS	ESTIMATE ($)	BUDGET ($)	CONTRACT ($)	AWARDED ($)	TO WHOM	Estimate vs. Budget ($)	Contract vs. Budget ($)	MarkUp BUG vs. EST	Estimate vs. Contract (%)
16						PROJECT NAME #111	VARIOUS DATA FILLED IN
17						PROJECT NAME #211	VARIOUS DATA FILLED IN
18						PROJECT NAME #311	VARIOUS DATA FILLED IN
BIDDING

I hope this answers the question.

 

[savv37]

I hit reply too quickly...

The purpose of this is show a quick overview of what's coming up, what is in the works, what has been & where our potential work is coming from. Essentially this is a lead generation application.

 

[My Aswer Is This]

If I understand you correctly.
You want a script to look down column A of a sheet named "Bidding"

And if the value:
"Completed", "Not Started" or "In Progress"

are found to copy this row of data to another sheet.

What is the name of this other sheet?

 

[savv37]

I already have that capability. What I am looking for is the ability to move the completed, not started or in progress items down 20 or so rows under the correct heading. For instance if i create a heading Not Started in row/col A1, In Progress in row/col A25 & Completed in row/col in A50, the items marked Not Started would remain in rows 1,2,3, etc while the In Progress would move to row 26, 27, 28, etc & Completed would move to row 51, 52, 53, etc. The Not Started, In Progress & Completed items would perform an insert versus a paste so they never wrote over one another.

Hope that's a bit clearer...

 

[My Aswer Is This]

This is beyond my knowledgebase.
Are you not able to do a sort?

I will continue to monitor this thread to see what I can learn.

 

[Joe4]

I already have that capability. What I am looking for is the ability to move the completed, not started or in progress items down 20 or so rows under the correct heading. For instance if i create a heading Not Started in row/col A1, In Progress in row/col A25 & Completed in row/col in A50, the items marked Not Started would remain in rows 1,2,3, etc while the In Progress would move to row 26, 27, 28, etc & Completed would move to row 51, 52, 53, etc. The Not Started, In Progress & Completed items would perform an insert versus a paste so they never wrote over one another.

I think the easier thing to do would be to sort all the records by status, then insert a bunch of rows at each change in status and add in whatever headers/totals rows that you want.
That is probably how I would approach it.