Deleting rows of cells from one sheet and moving specific cells to a different sheet

M

m0aje

New Member
Joined
Mar 1, 2012
Messages
11
Hello All,

I have a workbook with two sheets. The "Server" sheet (example below) and "Servers Pulled" Column "B" is "Shipping status" with a drop down list. When I choose "SHIPPED" from the drop-down list, I would like to be able to have that row delete from the "Server" sheet and move to the next available line on the "Servers Pulled". However, I only need columns A, and I through AE displayed on the "Servers Pulled" sheet. Not sure if that is possible or not.
I have had some experience with formulas (I get lucky), but none with macros or VBA code. I have looked at some examples and tried copying some into my sheet, but I must not be doing it right. I get no indications that the code is even being applied. Any help would be appreciated along with some guidence on how to actually copy the code into the sheet. I am using Excel 2007.

Many thanks!

m0jae


[TABLE="width: 2855"]
<TBODY>[TR]
[TD="class: xl108, width: 84, bgcolor: yellow"]Barcode No.
[/TD]
[TD="class: xl108, width: 87, bgcolor: yellow"]Shipping
[/TD]
[TD="class: xl89, width: 95, bgcolor: yellow"]DATE FOR
[/TD]
[TD="class: xl89, width: 161, bgcolor: yellow"]TEST DATE
[/TD]
[TD="class: xl76, width: 95, bgcolor: #00b0f0"]TEST DATE
[/TD]
[TD="class: xl111, width: 51, bgcolor: #00b0f0"]SAT
[/TD]
[TD="class: xl76, width: 34, bgcolor: #00b0f0"]TECH
[/TD]
[TD="class: xl88, width: 30, bgcolor: yellow"]TEST
[/TD]
[TD="class: xl78, width: 80, bgcolor: yellow"]Part No.
[/TD]
[TD="class: xl110, width: 98, bgcolor: yellow"]Server Serial No.
[/TD]
[TD="class: xl79, width: 74, bgcolor: yellow"]Folder No.
[/TD]
[TD="class: xl80, width: 342, bgcolor: yellow"]Description
[/TD]
[TD="class: xl77, width: 144, bgcolor: yellow"]Location
[/TD]
[TD="class: xl76, width: 110, bgcolor: #00b0f0"]Ethernet
[/TD]
[TD="class: xl76, width: 116, bgcolor: #00b0f0"]Ethernet
[/TD]
[TD="class: xl76, width: 109, bgcolor: #00b0f0"]Ethernet
[/TD]
[TD="class: xl76, width: 108, bgcolor: #00b0f0"]Ethernet
[/TD]
[TD="class: xl76, width: 108, bgcolor: #00b0f0"]Ethernet
[/TD]
[TD="class: xl76, width: 108, bgcolor: #00b0f0"]Ethernet
[/TD]
[TD="class: xl76, width: 108, bgcolor: #00b0f0"]Ethernet
[/TD]
[TD="class: xl76, width: 108, bgcolor: #00b0f0"]Ethernet
[/TD]
[TD="class: xl76, width: 108, bgcolor: #00b0f0"]Ethernet
[/TD]
[TD="class: xl76, width: 108, bgcolor: #00b0f0"]Ethernet
[/TD]
[TD="class: xl76, width: 108, bgcolor: #00b0f0"]Ethernet
[/TD]
[TD="class: xl76, width: 108, bgcolor: #00b0f0"]Ethernet
[/TD]
[TD="class: xl76, width: 108, bgcolor: #00b0f0"]FIBER NIC
[/TD]
[TD="class: xl76, width: 108, bgcolor: #00b0f0"]FIBER NIC
[/TD]
[TD="class: xl79, width: 277, bgcolor: yellow"]Assigned by / Warehouse Tech.
[/TD]
[TD="class: xl79, width: 224, bgcolor: yellow"]LABEL CLEARLY MARKING SERVER
[/TD]
[TD="class: xl79, width: 253, bgcolor: yellow"]VISUAL INSPECTION OF MATERIAL BY
[/TD]
[TD="class: xl79, width: 150, bgcolor: yellow"]SHIPPED DATE
[/TD]
[/TR]
[TR]
[TD="class: xl122, bgcolor: yellow"][/TD]
[TD="class: xl106, bgcolor: yellow"][/TD]
[TD="class: xl99, bgcolor: yellow"][/TD]
[TD="class: xl100, bgcolor: yellow"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl112, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl102, bgcolor: yellow"]IN
[/TD]
[TD="class: xl94, bgcolor: yellow"][/TD]
[TD="class: xl95, bgcolor: yellow"][/TD]
[TD="class: xl96, bgcolor: yellow"][/TD]
[TD="class: xl97, bgcolor: yellow"][/TD]
[TD="class: xl93, bgcolor: yellow"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl101, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl98, bgcolor: #00b0f0"][/TD]
[TD="class: xl96, bgcolor: yellow"][/TD]
[TD="class: xl96, bgcolor: yellow"][/TD]
[TD="class: xl96, bgcolor: yellow"][/TD]
[TD="class: xl96, bgcolor: yellow"][/TD]
[/TR]
[TR]
[TD="class: xl123, bgcolor: yellow"][/TD]
[TD="class: xl107, bgcolor: yellow"]Status
[/TD]
[TD="class: xl91, bgcolor: yellow"]RE-TEST
[/TD]
[TD="class: xl92, bgcolor: yellow"]STATUS
[/TD]
[TD="class: xl113, bgcolor: #00b0f0"](DD-MM-YYYY)
[/TD]
[TD="class: xl113, bgcolor: #00b0f0"]UNSAT
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"][/TD]
[TD="class: xl90, bgcolor: yellow"]MO.
[/TD]
[TD="class: xl82, bgcolor: yellow"][/TD]
[TD="class: xl83, bgcolor: yellow"][/TD]
[TD="class: xl84, bgcolor: yellow"][/TD]
[TD="class: xl85, bgcolor: yellow"][/TD]
[TD="class: xl81, bgcolor: yellow"][/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 1
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 2
[/TD]
[TD="class: xl87, bgcolor: #00b0f0"]MAC Address 3
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 4
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 5
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 6
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 7
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 8
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 9
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 10
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 11
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 12
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 1
[/TD]
[TD="class: xl86, bgcolor: #00b0f0"]MAC Address 2
[/TD]
[TD="class: xl84, bgcolor: yellow"][/TD]
[TD="class: xl84, bgcolor: yellow"][/TD]
[TD="class: xl84, bgcolor: yellow"][/TD]
[TD="class: xl84, bgcolor: yellow"][/TD]
[/TR]
[TR]
[TD="class: xl104, bgcolor: yellow"]640024
[/TD]
[TD="class: xl109"]SHIPPED
[/TD]
[TD="class: xl114"]NRFI
[/TD]
[TD="class: xl72, bgcolor: transparent"]Enter Test Date
[/TD]
[TD="class: xl115, bgcolor: transparent"][/TD]
[TD="class: xl73"]SAT
[/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"]3
[/TD]
[TD="class: xl75, bgcolor: yellow"]ABC-00103
[/TD]
[TD="class: xl69, bgcolor: yellow"]11051062
[/TD]
[TD="class: xl68, bgcolor: yellow"]151-11-049
[/TD]
[TD="class: xl69, bgcolor: yellow"]EQUIPMENT (First order)
[/TD]
[TD="class: xl71, bgcolor: yellow"]SHIPPED
[/TD]
[TD="class: xl103, bgcolor: yellow"][/TD]
[TD="class: xl104, bgcolor: yellow"][/TD]
[TD="class: xl116, bgcolor: yellow"][/TD]
[TD="class: xl117, bgcolor: yellow"][/TD]
[TD="class: xl117, bgcolor: yellow"][/TD]
[TD="class: xl117, bgcolor: yellow"][/TD]
[TD="class: xl117, bgcolor: yellow"][/TD]
[TD="class: xl117, bgcolor: yellow"][/TD]
[TD="class: xl117, bgcolor: yellow"][/TD]
[TD="class: xl117, bgcolor: yellow"][/TD]
[TD="class: xl117, bgcolor: yellow"][/TD]
[TD="class: xl118, bgcolor: yellow"][/TD]
[TD="class: xl104, bgcolor: yellow"][/TD]
[TD="class: xl104, bgcolor: yellow"][/TD]
[TD="class: xl70, bgcolor: yellow"][/TD]
[TD="class: xl71, bgcolor: yellow"]Awaiting disposition
[/TD]
[TD="class: xl67, bgcolor: yellow"]ON Assembly
[/TD]
[TD="class: xl68, bgcolor: yellow"][/TD]
[/TR]
[TR]
[TD="class: xl104, bgcolor: yellow"]640032
[/TD]
[TD="class: xl109"]SHIPPED
[/TD]
[TD="class: xl114"]NRFI
[/TD]
[TD="class: xl72, bgcolor: transparent"]Enter Test Date
[/TD]
[TD="class: xl115, bgcolor: transparent"][/TD]
[TD="class: xl73"]SAT
[/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"]3
[/TD]
[TD="class: xl75, bgcolor: yellow"]ABC-00103
[/TD]
[TD="class: xl69, bgcolor: yellow"]11051070
[/TD]
[TD="class: xl68, bgcolor: yellow"]151-11-049
[/TD]
[TD="class: xl69, bgcolor: yellow"]EQUIPMENT (First order)
[/TD]
[TD="class: xl71, bgcolor: yellow"]SHIPPED
[/TD]
[TD="class: xl103, bgcolor: yellow"][/TD]
[TD="class: xl104, bgcolor: yellow"][/TD]
[TD="class: xl119, bgcolor: yellow"][/TD]
[TD="class: xl120, bgcolor: yellow"][/TD]
[TD="class: xl120, bgcolor: yellow"][/TD]
[TD="class: xl120, bgcolor: yellow"][/TD]
[TD="class: xl120, bgcolor: yellow"][/TD]
[TD="class: xl120, bgcolor: yellow"][/TD]
[TD="class: xl120, bgcolor: yellow"][/TD]
[TD="class: xl120, bgcolor: yellow"][/TD]
[TD="class: xl120, bgcolor: yellow"][/TD]
[TD="class: xl121, bgcolor: yellow"][/TD]
[TD="class: xl104, bgcolor: yellow"][/TD]
[TD="class: xl104, bgcolor: yellow"][/TD]
[TD="class: xl70, bgcolor: yellow"][/TD]
[TD="class: xl71, bgcolor: yellow"]Awaiting disposition
[/TD]
[TD="class: xl67, bgcolor: yellow"]ON Assembly
[/TD]
[TD="class: xl68, bgcolor: yellow"][/TD]
[/TR]
</TBODY>[/TABLE]
 
Sort by date Sort by votes
Hello again Warship,

When I was testing the newest code, I had the file at home and was using Excel 2010 and it worked fine. I have copied the same code to the computer using Excel 2007 and cannot get it to work at all. It acts as if the code isn't in there. I think Macros are enabled, but is there something I am missing such as a box being checked or something turned off that should be on?

Thanks,

m0aje
 
Upvote 0

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Hello again Warship.
Disregard my last. I found that there was an extra space in the title on the spreadsheet tab. It works great. Thanks again for your help.

r/ m0aje
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Create New Sheet with Specific Name Based on Variable Cell
Replies
0
Views
238
SBExcel123
S
larinda4
  • Question Question
VBA: Work Around for moving from one sheet to another based on cell value?
Replies
0
Views
590
larinda4
larinda4
K
  • Solved
Check & Update existing rows of data to fill in the blanks
Replies
1
Views
621
Kemidan2014
K
D
  • Question Question
Moving Data (entire rows) from one Sheet to Another Based on Criteria
Replies
4
Views
1K
DOC1021
D
H
  • Question Question
VBA Code required - copy data from one sheet to another
2
Replies
10
Views
1K
hrayani
H

Forum statistics

Threads
1,224,590
Messages
6,179,753
Members
452,940
Latest member
rootytrip

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top