delete rows with user id in cells

Gabtablet

New Member
Joined
Sep 30, 2014
Messages
3
Hi
I have a report in work that generates with auto entries and manual ones. I am looking to delete all manual entries from the report and I have recorded a macro where I filter the user Ids and delete them. The problem is there can be any number of id's in the format a123456 or e123456 so if I run the recorded macro and there are new entries I miss them. Could you please show me a way to delete these rows in VBA as I am new to it.

Thanks
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Momentman

Well-known Member
Joined
Jan 11, 2012
Messages
4,066
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Welcome to the forum

COuld you give some sample data and which of the entries would be deleted/retained
 

Gabtablet

New Member
Joined
Sep 30, 2014
Messages
3
Thanks Momentman, sorry about the delay coming back, below is the data I am looking at. In the final column there are user Ids that will start with a letter and have 6 numbers after them, I need to delete the rows with these User IDs. The other formats can be any combination of letters so I cannot filter them as a new report could have more or less

Transation NumberTransaction TypeDeposit CodeTrade DateNAVUnitsNet AmountFund CurrencyNet Amount USDRate AppliedOrder User ID
000246PurchaseD28/11/20140.39702132.3997712.86339473GBP0a123456
000245RedemptionD14/08/20140.25023983.5745320.91360997GBP0Blop34444
000244PurchaseD03/05/20140.37975271.9016427.30481612GBP0a123458
000243RedemptionD13/07/20140.5984190.1128790.067548794GBP0a123459
000242PurchaseD27/08/20140.23294461.7794414.39117551GBP0Tryyu234
000241RedemptionD12/04/20140.12971950.459996.545623005GBP0a123461
000240PurchaseD23/10/20140.88821852.8366446.93045438GBP0Gabtab1
000239RedemptionD17/09/20140.73401813.326599.78196178GBP0Traflth23
000238PurchaseD16/09/20140.9599861.8426859.36776228GBP0Bkifjij24
00237RedemptionD02/11/20140.11397117.826842.031736677GBP0Jamiuedeg
000236PurchaseD22/05/20140.56841686.2021948.99869722GBP0Erfii123
000235RedemptionD27/08/20140.67912492.8950163.08725155GBP0Fgtg234
000234PurchaseD23/09/20140.04945937.153551.837578332GBP0e123456
000233RedemptionD20/03/20140.50026867.1536633.59479711GBP0e456123
000232PurchaseD04/11/20140.07302180.892045.906801585GBP0Trgyt789
000231RedemptionD29/10/20140.72487255.4038440.16069358GBP0e458793
000230PurchaseD27/09/20140.31767230.009129.533047299GBP0a123460
000229RedemptionD24/02/20140.42123169.044429.08367119GBP0a123457
000228PurchaseD10/07/20140.63999921.2376113.59205444GBP0a123457
000227RedemptionD25/09/20140.77983577.3742960.33918997GBP0e458793
000226PurchaseD24/02/20140.17038995.6933516.30513252GBP0e458793
000225RedemptionD29/06/20140.6056589.6596354.30232253GBP0Tryyu234

<tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,122,567
Messages
5,596,908
Members
414,110
Latest member
docops

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
Top