Delete Range of cells and move left based on Cell value

  • Thread starter Thread starter Thomp
  • Start date Start date
T

Thomp

Hi..I am trying to delete a range of cells in a column and move them
left based on whether or not a certain cell = 0. Any help would be
great,

thanks,
Bill
 
Wow this might be a little hard. I have a copied set of data for some
filtered data that puts the data in the columns D thru P. As the data
refresh and changes alot I can't just say delete these cells at this
location as the data in the row changes every time I make a new
selection. Once the selection is made and new data is copy to the
sheet they are often times a column with blank data that really isn't
blank because the column contains a header and formulas so I can't
look for and delete the blank cells. I need to be able to say if Cell
B13 = 0 then delete the chosen range of cells in the column above only
up 12 cells then delete and move data left to put in all together in
side by side columns. Can't write a macro to delete said cells as the
empty rows can change due to them being a new set of data. In this
example below what would happen is the "AE,AGOL.Ocean and INS columns
would deleted and only the CHB and NAT/DIST columns would remain net
to each other

AE AGOL CHB OCEAN INS NAT/DIST
May $18,627.00
Feb $25,938.00 $244.62
Apr $20,739.00
Jan $28,112.19
Mar $27,717.00 $300.00
Nov $30,645.00 $550.89
Jun $33,276.00 $739.95
Aug $30,157.50 $686.64
Sept $30,279.00 $1,965.06
Oct $34,194.00 $1,763.82
Dec $38,268.00 $195.00
Jul $36,861.00 $744.00
$0.00 $0.00 $354,813.69 $0.00 $0.00 $7,189.98
 
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Wow this might be a little hard. I have a copied set of data for some
filtered data that puts the data in the columns D thru P. As the data
refresh and changes alot I can't just say delete these cells at this
location as the data in the row changes every time I make a new
selection. Once the selection is made and new data is copy to the
sheet they are often times a column with blank data that really isn't
blank because the column contains a header and formulas so I can't
look for and delete the blank cells. I need to be able to say if Cell
B13 = 0 then delete the chosen range of cells in the column above only
up 12 cells then delete and move data left to put in all together in
side by side columns. Can't write a macro to delete said cells as the
empty rows can change due to them being a new set of data. In this
example below what would happen is the "AE,AGOL.Ocean and INS columns
would deleted and only the CHB and NAT/DIST columns would remain net
to each other

AE AGOL CHB OCEAN INS NAT/DIST
May $18,627.00
Feb $25,938.00 $244.62
Apr $20,739.00
Jan $28,112.19
Mar $27,717.00 $300.00
Nov $30,645.00 $550.89
Jun $33,276.00 $739.95
Aug $30,157.50 $686.64
Sept $30,279.00 $1,965.06
Oct $34,194.00 $1,763.82
Dec $38,268.00 $195.00
Jul $36,861.00 $744.00
$0.00 $0.00 $354,813.69 $0.00 $0.00 $7,189.98
 
Back
Top