If value is SPECIFIC cell is X then delete row, no loop, a 1 off

**DMHCampbell** · 01-07-2013, 01:16 PM

Hi all,

I have a script that loops through selected workbooks to do different processes ; it works fine. I now have some mis-matches of row/data locations in a specific worksheet that needs fixing. For example I have info in cell B6 in one workbook, then, in another workbook, the same information is in B9. I need to make the data in a consistent location in each spreadsheet throughout all my workbooks; something that I can just put in between my working macro to open workbooks.

Everything I am finding on the forums is loop based for multiple ranges and such and I can't decipher which may work for my specific example. Any help out there VBA world?

Thanks

**arlu1201** · 01-08-2013, 03:51 AM

Do you have a clear list of what needs to be changed? Do you need to do these changes on a regular basis and thus need the macro?

**DMHCampbell** · 01-08-2013, 10:51 AM

Hi,

Thanks for your response. I figured it out a few hours ago. It was really simple; I find the simple stuff is harder to do some times then the hard! I had a clear list, probably 3 or 4 variations from the desired layout. So, in a very simplistic way, I just insert some rows and deleted some rows to get to that layout. Here is the code I used. If you think that there is an even easier way to do this, please let me know as I am trying to improve my script writing skills.

Thanks again

Please Login or Register  to view this content.

**arlu1201** · 01-08-2013, 11:10 AM

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

Also, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.