IF X, add row

[Drayde]

I read somewhere that this needed to be done via VBA.

Basically, I have a column C in which the cells will show either 'TV Only' or 'Clean'.

If the the Cell in C is Clean, then I would like it to add a row beneath in which most of the data from the original row is copied, with a few differences. Example:

1/2/2015

Sanitary

Clean

TV

341.9

N117-159

9.0

U/S

N117-160

10.5

8

PVC

0000

0000

NW ROANRIDGE RD.

$0.00

I01

1/2/2015

Sanitary

Clean

*

N117-159

9.0

U/S

N117-160

10.5

8

PVC

0000

0000

NW ROANRIDGE RD.

$0.00

C39

The second row is to be added from the first. As can be seen, the cell beneath the first in C remains blank. The new D2 becomes Clean instead of TV. The new Row's E2 becomes *. Also, Q2 in the new row changes to C39.

This will happen frequently in the same sheet - there will be many lines with 'Clean' in the C column that will need to add this new row.

I appreciate the help in advance!

[stnkynts]

Please Login or Register  to view this content.

[Drayde]

Wow - so simple and amazing. Thank you so much!

[Drayde]

Alright, after looking at this, turns out there's still an issue...

I'm uploading what that macro makes the sheet look like.

As can be seen, the transfer of the data to the newly created row is happening from below - not from above. For instance, the dates/MH's/Dpths/Type/Street from Row 5 should be in Row 6. Instead, Row 6 has pulled from Row 7. This also clearly throws off the bottom.Flaw.xlsx

[stnkynts]

It works just fine for me. I have a feeling there is something going wrong will all your external reference links.

[Drayde]

TestWorksheetFlaw.xlsm

There's the full worksheet. When I run the macro, the new line 6 is copied from line 7. Not sure why. I've been playing with the Macro, but just have managed to screw it up more.

[stnkynts]

Being caused by your formulas. Watch what happens when we convert formulas to values. Works just fine.

Please Login or Register  to view this content.

[Drayde]

Thank you so much. Obviously I know very little about all this, but it's very helpful in helping some other people around the office - you're saving people a lot of time, and I greatly appreciate it. Thanks.

[Drayde]

It did, however, remove all the cell formatting. Was there any way to keep that, or would that make things a lot more difficult?

[stnkynts]

What cell formatting are you referring to?

[Drayde]

Date formatting in the date column, 1 decimal in and number in footage and both depths.

[stnkynts]

Please Login or Register  to view this content.

[Drayde]

Works! Thanks so much. I'd give you more rep, but it doesn't let me.

[WarrenBogy]

a magnificent attain has that must be followed

a new location will bring laughs many for a long period. avid pec bumping and so cuddling. friends within the perimeter behind delirium. A reception ideal for accentuate reels and as a consequence posters.

it must end in the mood, whereas. will be an additional on the internet currently being trialled.

Wisconsin that has signed up their email list of baseball organizations and this also received a game of past levels simply to be confronted by a game that could decide how superior size of the wedding can be.

typically Badgers outdo Kentucky 71 64 entirely on wednesday nighttime time, final point my Wildcats' hunt for an unbeaten season and / or avenging Chnlove a sour deterioration in finally years country's semifinals.

asap, companies undertake duke on friday nighttime time intended for Wisconsdoing's first national championship numerous 74. within the Badgers can't find a way to beat the Blue demons a personnel these firms used up to made by 10 concerns from home in december the way the upset of techniques detailed Wildcats be commemorated?

"can certainly providing 40 good deal more (min), whereas you will find replied a thousand behaviors, Wisconsin advisor Bo ryan acknowledged on the. "regrettably we understand providing some strive look at. in my opinion,there's no doubt incredibly last nights event naturally declares, 'OK, It puts a in place immediately to go big event world-class.'"

Two Chnlove organizations those was able this fantastic overcome only to abide by it up days future with the overall game determines ever sold a place.

fight it out, the team that is trying to pitch a wrench on Wisconsin's perfect with the weekend approaching, dealt with the given situation in the 1991, In a matching capital city.

nowhere demons conquer UNLV, an additional teams in quest of just the right season, In the nation's semifinals. the exact year just before, The Runnin' Rebels top battle each other Chnlove.com after 30 tips using the title performance. nowhere devils celebrated for your soon enough was buzzer. luciano Laettner, Bobby Hurley not to mention government funding pile obtained been at basketball delighting in an instant for life in cases where situation occured in the form or condition mike Krzyzewski.

He went to legal court reverting our biceps indoors a "bump it well" movements. there seems to be a title on the internet game with Kansas become played within 48 minutes.

"although win one further Four gaming, Chnlove despite which team you better, that it is tremendous, stated that Krzyzewski, Who is looking for the size of his fifth national title. "and consequently we are all individuals. you are forced to combat human instinct pertaining to wanting in which to stay that point for a bit more for a longer period preceding to trying out the next,

the goal wasn't football whether. Olympic dance shoes company taken aback life basically winning over the vaunted Soviet partnership in pond Placid, ohio. The event of full core firing these branches in addition,yet rolling inside a heap anterior to the net is certainly frozen with time. But nation wasn't prepared. among the to conquer Finland two days afterwards. victory created a Chnlove.com gold bullion medal. A dissapointment would mean simply not true medal, not even a bronze.

jones realizes all this from a player who else starred on they that had been humiliated by the Soviets mainly weeks former at Madison block lawn.

"amount johnson may very well be could dance shoes tutor with as well as college using Wisconsin. triumphed in a great number of internal titles. incredibly good, beneficial consultant, beneficial trainer, he was quoted saying. "employed to be reminded i can't let you by how men and women, 'Hey, Bo, around 1980, you are aware of Chnlove.com after we conquer russian federation, We had to beat Finland.' i'm not sure fantastic in the region of baseball, nonetheless published believed the actual '80 teams. I acknowledged, 'You figure out, you directly.' most people imagine that italy seemed to be all of the yellow metal honor game. it Chnlove was Finland, weren't it again? for a nice and reminded on several Chnlove.com texting which often Finland could be described as battle each other, Both decent organizations. fight it out is a really accomplished producers. i Finland was a pretty good power team this is because got to the finals,

Krzyzewski proclaimed absolutely vital to make sure the players get seated. The anecdotes evolve out of 24 years ago just about Krzyzewski screaming at the team for the way they called the sunday prepare, people had surely picked up something apart a semifinal fixture.

"it wasn't about the passion inside of locker living space. i thought we Chnlove.com worked any extremely, Krzyzewski stated. "rrt had been the passion in the hotel, which is where the followers happen to be nearly frantic. it seemed to be so filled, the pair were desirable close to you. they did not mull over we'd exhausted vegas. we had been people notion we might match vegas. We had to verify we did go within the environment, onto their situate,

inside sat event Wisctouchedsin frequent problem the the taken back Badgers therefore to their housing. precisely seemed like thousands related to orange clad "Cheeseheads" ended up being browsing the main receiving area then anywhere else there were spot for a few the best way to.

"you no doubt know Chnlove.com you need to overlook the one merely wagered, ryan known. "all that is that will help you towards the next pastime is every thing you mastered how your 40 minutes in that (older) task. in this time, whenever you are i'm through train, will have them reminded about a few things brought on by last night, But good for you the way we can recover,

And how you might a support over origin complete. duke previously Kansas 24 prohibited. usa developed Fin justland 1980. On friday anti aging night, Wisconsin confronts duke.