Copy Data From One Sheet To Another With VBA

[wavery]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Gaming Month
[/TD]
[TD]Gaming Month Name
[/TD]
[TD]Gaming Year
[/TD]
[TD]Denom
[/TD]
[TD]Game Type
[/TD]
[TD]Jackpot
[/TD]
[TD]Coin In
[/TD]
[TD]CIPUPD
[/TD]
[TD]Coin Out
[/TD]
[TD]Actual Win
[/TD]
[TD]Theo Win
[/TD]
[TD]Handle Pulls
[/TD]
[TD]Days on Floor
[/TD]
[TD]Fee Amt
[/TD]
[TD]Asset Number
[/TD]
[TD]Area
[/TD]
[TD]Section
[/TD]
[TD]Location
[/TD]
[TD]MFG
[/TD]
[TD]THEME
[/TD]
[TD]EPROM
[/TD]
[TD]WPUPD
[/TD]
[TD]LEASE or NOT
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]1/1/2018
[/TD]
[TD]2018
[/TD]
[TD]1
[/TD]
[TD]VR
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8.00
[/TD]
[TD]1234
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Lease
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]2/1/2018
[/TD]
[TD]2018
[/TD]
[TD]5
[/TD]
[TD]VP
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8.00
[/TD]
[TD]4321
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Not Lease
[/TD]
[/TR]
</tbody>[/TABLE]
Hello,
I am new to this message board, so I hope I am posting this in the correct area. Here is what I need to accomplish. I have a workbook that I track our machines asset numbers. We have 800 machines some are leased most are not leased. I keep a running table "DATADump", data is dumped into this table monthly. I want to copy the current "Asset Numbers", "Machine Type" & "Lease Cost" for Lease Machines only, from "DATADump" to another worksheet named "Leased Machines". I hope I explained this ok.

Thank you,
Wade

 

[wavery]

THAT WAS IT!!!!!!! It works great, Thank you for all of your help.

 

[mumps]

You are very welcome.