Copy rows to second worksheet by checkbox

Hi,
I'm working on a quote sheet where the products, sizes and prices are input on sheet1 and if a checkbox for that item is selected it populates a quote template on sheet2.

I've linked checkboxs to the data but am stuck with the code to get the data accurately onto the second sheet.

I'm currently using:

Please Login or Register  to view this content.

The problem I'm having with this code is I need the data on sheet 2 to start at row 11 (A11)and for every subsequent item checked to populate the next free cell below it. The code doesn't seem to do that, it's overwriting previous data and starting at row 10.

Any help would be mucho appreciated!

Sagsie.

Hi sagsie

Welcome to the Forum. You'll find this place totally amazing.

You really need to use code tags around your code. The Forum is adamant about this. To do so:

Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

Please Login or Register  to view this content.

An Administrator may do so for you since this is your first post. I can't (Not an Admin). Please do so at your earliest convenience.

Can't test this but you might try

Please Login or Register  to view this content.

John

Hi sagsie

Thanks for adding Code Tags. Makes life for all of us much easier.

Yeah, I don't really like to post untested code so I'm not surprised it doesn't work. Sorry about that.

If you'd like me to work through the issue with you it would be helpful if you would post a mock up file of your actual data, including code so I can "see" what's happening.

John

Hi sagsie

The problem with this (I think) is that I can't "see" what you are trying to do

I've removed the macro from the checkboxes

The reason I asked to see your current code is to "see" what you're trying to do so i can "see" what's happening. With your example file, nothing happens except "Clear Quote" but since there's nothing in Quote it doesn't tell me anything.

Please attach a file that precipitated this question

I'm working on a quote sheet where the products, sizes and prices are input on sheet1 and if a checkbox for that item is selected it populates a quote template on sheet2.

I've linked checkboxs to the data but am stuck with the code to get the data accurately onto the second sheet

I'm still trying to figure out WHAT you're trying to do. Once I understand that, you can go in any direction you choose.

John

Hi sagsie

This appears to solve your immediate issue

I need it to start at Row11 and then seubsequent free rows after that.

Please Login or Register  to view this content.

However it raises others. Now you can

go in any direction you choose.

John

Hi sagsie


Yes, I was aware of this issue. How to handle it depends on your needs. The checkbox can simply be unchecked and thus be available for future processing, the entire row can be locked so it's not available for future processing or the checkbox can be deleted and not be available for future processing.

These three approaches come immediately to mind, there may be others. What would you like to happen?

John

Hi sagsie

To select a cell the sheet must be active so, it would look like this

Please Login or Register  to view this content.

Glad you got it working.

John