Selection box to copy cells to another Sheet in next available row

**RoyLittle0** · 10-31-2016, 07:40 AM

Hi All,

I am trying to create a document that takes the effort out of writing Risk Assessments at work, I am writing a database (Sheet 2) of Risks that by means of a Tick Box would like to add the relevant Risk (Line) to the top sheet (Sheet 1).

So on (Sheet 2) I have Columns A through to L of information, I would like to COPY a line from B to H to (Sheet 1) with a starting point of C17 but each Tick Box on (Sheet 2) I Select it will add it to the next available line and hopefully if I Deselect it it will not leave a blank line, then from the (Sheet 1) I can modify the contents if required.

(Sheet 2) will be a Master Database and (Sheet 1) will be the Risk Assessment, I have started the WorkBook with some data so that you can see what I am trying to achieve.

**Mumps1** · 10-31-2016, 08:23 AM

Try the attached file. I've deleted the check boxes to make programming easier. Instead of using a check box, just type in the letter 'x' in column A and exit the cell. The range for that row will be copied to Sheet1. Hopefully, this approach works for you. If you must use the check boxes, please let me know and we'll go from there.

**RoyLittle0** · 10-31-2016, 09:19 AM

Thanks Mumps1

It does exactly what I want in principal but without the Tick Box, so all is good, My preference is a Tick Box as it is clearer and easier for anyone to use without explanation but I'll give it a go and see how people get on with it.

Thanks for helping

**Mumps1** · 10-31-2016, 09:23 AM

I'm glad it is working for you.

Again, if you really need the check boxes, please let me know.

**RoyLittle0** · 10-31-2016, 04:21 PM

We have given the form a try but the office want it all singing and dancing so they want the Tick Boxes

I have done some research and come up with a solution that fits my needs and I have modified it to do almost what i need, the bit I am struggling with is adding the data to a specific location on the main form (Sheet 1), how can i modify the below code to start in a set location, A14 for example, at the moment it starts at A2, I just cant see how its done from the code I have.

I have found a work around by adding data to column a up to where i want to start, but this isn't the answer

Please Login or Register  to view this content.

**Mumps1** · 11-01-2016, 08:40 AM

I deleted the data you entered in the range A1:A13 and tried your macro and it seemed to work properly. The data started copying at row 14.

**RoyLittle0** · 11-02-2016, 03:06 PM

That's because I have data in column A, if you insert another column it will add the data to A2 because that is the first available A column and row.

What I want is to add to a specific line irrespective of what may be in the cells above or below the area, because this will all change when I add content to the top and bottom of the form.

Also if I add information at the bottom of the page below where I want the data to be inserted, this also effect the location that I insert to, because it looks for the last clear cell in Column A which will be below the last data in column A.

Have a look at the spreadsheet, I have added some more information in different sections above and below where I want the data to be inserted (sorry I didn't make my problem very clear)

Selection box to copy cells to another Sheet in next available row

LinkBack

Thread Tools

Rate This Thread

Display

Selection box to copy cells to another Sheet in next available row

Re: Selection box to copy cells to another Sheet in next available row

Re: Selection box to copy cells to another Sheet in next available row

Re: Selection box to copy cells to another Sheet in next available row

Re: Selection box to copy cells to another Sheet in next available row

Re: Selection box to copy cells to another Sheet in next available row

Re: Selection box to copy cells to another Sheet in next available row

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copy the sheet based on ComboBox Value Selection

[SOLVED] How to change the code in dropdown multiple selection lsit to copy to other cells in sheet

[SOLVED] Copy cells from one sheet to another based on selection by user

[SOLVED] Linking cells from one sheet to another and update cells accordingly based on selection

Excel 2007 : Copy a cell value from a filtered selection to another sheet

Macro to copy & paste from sheet 2 to 3 based on a checkbox selection in sheet 1

Command button copy selection to another sheet

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions