tribalbydesign
New Member
- Joined
- Sep 15, 2008
- Messages
- 20
Hello,
I am trying to create a macro to use on a speadsheet that checks the value of a cell in Column A and if it meets a criteria (which is variable) then it will delete the entire row.
The contents of the cells is below. The "Pc. Price:" part does not change, however the price does. The price can be from a whole number with no decimal point to having thousandths of a cent (i.e. .003).
The Pc. Price, Total Value, Total Pieces, Total Cartons, and Delivery address are the only things I want to be deleted. I can not figure out how to delete a line based on part of the cell value. The information is electronically fed to me so I have no choice in how it shows up on the excel worksheet. (I tried copy and paste into excel to hopefully pull the information apart, however last time I tried that it all went into column A anyways.)
Each row of information below is in 1 cell together, the decription of the value, and the value.
Pc. Price: 0.03
Total Line Value: 300
Line I want to Keep
Line I want to Keep
Line I want to Keep
Total Pieces: 10000
Total Cartons: 100
Line I want to Keep
Line I want to Keep
Delivery to: adress with letters, numbers, and dash's possible
Line I want to Keep
I've recorded a macro, however when I go to delete the lines it deletes the same row numbers everytime. I go through about 20 of these sheets a day, and the data for each part can be from 17-19 rows long, and there can be up to 200ish groups of the 17-19 lines of data on each sheet. So that didn't work out to well for me . Any help would be appreciated. Thanks!
I am trying to create a macro to use on a speadsheet that checks the value of a cell in Column A and if it meets a criteria (which is variable) then it will delete the entire row.
The contents of the cells is below. The "Pc. Price:" part does not change, however the price does. The price can be from a whole number with no decimal point to having thousandths of a cent (i.e. .003).
The Pc. Price, Total Value, Total Pieces, Total Cartons, and Delivery address are the only things I want to be deleted. I can not figure out how to delete a line based on part of the cell value. The information is electronically fed to me so I have no choice in how it shows up on the excel worksheet. (I tried copy and paste into excel to hopefully pull the information apart, however last time I tried that it all went into column A anyways.)
Each row of information below is in 1 cell together, the decription of the value, and the value.
Pc. Price: 0.03
Total Line Value: 300
Line I want to Keep
Line I want to Keep
Line I want to Keep
Total Pieces: 10000
Total Cartons: 100
Line I want to Keep
Line I want to Keep
Delivery to: adress with letters, numbers, and dash's possible
Line I want to Keep
I've recorded a macro, however when I go to delete the lines it deletes the same row numbers everytime. I go through about 20 of these sheets a day, and the data for each part can be from 17-19 rows long, and there can be up to 200ish groups of the 17-19 lines of data on each sheet. So that didn't work out to well for me . Any help would be appreciated. Thanks!