Copy multiple rows only if column is filled in

**soldevi53** · 02-08-2012, 02:15 PM

Hello all,

New here but like the topic explained I would like to use a button on Sheet2"Meter Run", to populate the entire row from sheet 1"Index", only if a certain column filled in, while ignoring other rows until reaching another row with said column populated.

Thanks everyone

I'm pretty bad with excel but I have the button and

Please Login or Register  to view this content.

Basically if any column pupulated outside the print area(U13-AD13)

it will take that entire row onto the next sheet(meter Run) using the button at the top

**arlu1201** · 02-08-2012, 02:33 PM

Please attach a sample workbook and specify what needs to be copied.

**soldevi53** · 02-08-2012, 02:39 PM

Here it is

Basically if any column pupulated outside the print area(U13-AD13)

it will take that entire row onto the next sheet(meter Run) using the button at the top

Thanks

**soldevi53** · 02-08-2012, 04:01 PM

Anyone? PLease

**soldevi53** · 02-08-2012, 05:20 PM

Trying this now but no luck as well

Please Login or Register  to view this content.

**soldevi53** · 02-08-2012, 06:56 PM

somebody must have a code I can use or manipulate for this

**soldevi53** · 02-08-2012, 11:29 PM

????????????????????????

**arlu1201** · 02-09-2012, 03:11 AM

Can you try explaining again? What do you mean outside the print area? Which is the print area u have set? Can you type in some examples into your file so we can understand better?