Macro - New row ++

Cann0n

New Member
Joined
Mar 7, 2011
Messages
1
Hi, first post.

Searched for, but did not find a solution to my problem.

I am making a Action List in sheet "ActionList", the list has 6 col:

No | Start date | Description | Link | Resposible | Finished

I am trying to make a macro that:
1 adds a new row below the last row
2 adds +1 to the number in the "No" col, starting at "001"
3 adds current date in "Start Date" col
4 and finally adds a button or check box in "Finished" col.

When clicking the box in "Finished" col, that row will be cut and pasted to a different sheet, "Finished", in the same workbook. All the finished items would also have to inserted below eachother in the order they were finished.

Is this doable?

Thanks in advance.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

arsalan701

New Member
Joined
Jun 12, 2010
Messages
12
To find last non empty cell in the sheet use the below
Range("a65536").end(xlup).offset(1,0).select
then
activecell.value=activecell.offset(-1,0)+1
if the value on the top is 100 then the value in new cell will be 101
for date use the below line
activecell.offset(0,1).value=vba.date
For the checbox add a button from developer tab and sets its value to a cell.

Then you can have a macro button sothat when clicked will copy this data to desired sheet.
 

Forum statistics

Threads
1,141,017
Messages
5,703,752
Members
421,313
Latest member
Mooncake1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top