Hi I am a newbie to Excel VBA Coding so take it easy on me i this is a stupid question.
So, I will try to explain what I need as best I can:
So, I have a spreadsheet (we'll call it S1) that has over 3000 rows of data. Each row corresponds to a customer that has various customer related columns...
I have been using a macro to pull together worksheets from all open workbooks into a single sheet discussed here:
Combining All Open Workbooks into Single Worksheet
I then have another macro I have been using that removes a row if there is no value within a specified column shown here:
First and foremost happy holidays and thank you</SPAN></SPAN> for any help provided. I have copied a code from internet and I would like to modify it but dont know how ?
In the code below: it deletes the entire row rows based on the criteria different "RVWD" .
I would to modify it so...
Just learning vba and trying to put it together.
If I want to delete a row if a value in its column is blank. So if it was column F and starting from F1.
F1 & F2 are blank and F8 & F9 are blank etc i would want to delete rows 1,2 & 8,9.
This is how I am setting it up but cannot get it to...
IN great need of a code to delete ENTIRE ROW if a cell in COLUMN M has number 0.
my range is from row 2 to row 3745, and there is blank row every after 34 rows. for example there is data from ROW 2 TO ROW 35 then there is blank row and so on.