Export Data based cell value

Basically if the checkbox on a row is checked then get the macro to select it, if a column is selected as well then add the whole row to the selection, then what ever has been select will get copied when a button is clicked. Sorry if im asking a lot, i was just wondering what would be the best way to go about it was and how.

Thank you

Anyone have answer for this?

Would it be possible to do this based on a cells contents. For instance, there are columns with headings at the top, above each heading there is a box that will either say T or F (True of False).
When the macro is run, each column that says "T" will be copied to a new document with all of the values that the column holds. Is this possible or not?

UPADTE! It seems to be working very well apart from when i un-check a box, it breaks at the red code:

Please Login or Register  to view this content.

Otherwise it works brilliantly!

What error message do you get?

Try this:

Please Login or Register  to view this content.

maybe this:

Please Login or Register  to view this content.

That did work very well, but now it comes up with this error: 'The index into the specified collection is out of bounds'

It's on this line: If Sheet1.CheckBoxes(x).Value = 1 Then

**"Accidental duplicate post"**

Are you moving adapting this cod efor another workbook. The only way you could get that error is if there are no checkboxes on the worksheet

Nope, i have moved check boxes around though. there are 400+ checkboxes, should that be a problem?

Try changing this:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

And see if it works

or that ^^

haha, Ill give it a go! also do the check boxes just need to be in a row or a column or do they have to be referenced to a cell? just so i can take out the true/false if i dont need it.

Cheers! +REP

Well the reference for which rows/columns to copy is based on which cell the checkbox is in.

So really they need to be in the top row and first column

Okay, that makes sense now the code snb came up with works when copying but not when deleting them off of Sheet2. how would i go about putting that? I know the basic format of the code but not in this circumstance.

Like this:

Please Login or Register  to view this content.

Originally Posted by Kyle123

Like this:

Please Login or Register  to view this content.

No joy with that piece of code :o

That's what im looking for!!! ..lets see if it worrks....

YUP!!! works a treat, thanks very much, if i have any other queries then ill let you know thank you very much! :D

Sorry about the delay, this looks like it might just work, although atm i have an error - "Object Required", that comes up here:

Please Login or Register  to view this content.

Dont mean to be hassle but it would be nice to get this working sometime tomorrow.

Thanks,
Storm08

Originally Posted by Kyle123

Stick the code in the sheet1 code rather than a module and try it - or fully qualify the UsedRange

I tried putting in into the sheet code but i dont think it liked it :p when you say qualifying the used range dyou mean this?: http://www.homeandlearn.co.uk/excel2...l2007s7p6.html

And what would i select for the range? just one column?

No, I mean like this:

Please Login or Register  to view this content.

Becomes

Please Login or Register  to view this content.

Ah okay, i get you know Sorry, trying to learn programming properly because the only stuff i have done is at college. and that's next to nothing :/

You have to be explicit when using code in modules, you need to tell it which sheet to reference as it has no idea. When using it in the sheet object, in this example it will use the sheet that the columns are in by default.

Whilst learning it is probably a good idea to always be explicit as it makes it easier for you to understand exactly what's going on, also in general step through the code and have the locals window open when you are learning, you get a much better insight of what is going on.

You can also query particular bit of code in the immediate window for example:

Please Login or Register  to view this content.

I try to be explicit but dont always know what im doing :P i find it helps to do it all the time unless it may cause an error. Thanks very much for the info, better than all of the college tutors! :P

Hey guys, The code is work very well now, just 1 problem, when the data is copied to the second sheet, the data copies fine but underneath the data, all the cells have " #N/A " in them. there's about 16000 rows of it each time. :/

I dont know what to do, would be happy for any help

Thank you,
Storm08

Do you have any formulas in the rows below?

I would say (without having seen your workbook) that the first issue was caused by having a blank row in your data