Macro that adds or removes row based ont first cell selection.

[MaritimeRob]

Hello all,

I would need quite a bit of help in figuring out how to make this kind of macro.
The basic idea is that the macro has to copy values from "sheet1" to "sheet 2" and depending on how many cells are selected to format "sheet 2".

The long explenation is that I want to select just the first cells in specific rows (A2,A8,A9-other are filtered out) then it should copy from colum A to colum P of the selceted row and paste it to the target sheet. In the target sheet it should add or remove rows depending on my selection and paste colum values from A to M colum O and P go to diferent areas since they are fixed values for all of the selected rows.

I'm attaching an excel file that shows my problem better.

[vichopalacios]

MaritimeRob

From your post and your workbook sample, it's not clear a couple of things:

.- when you say

I want to select just the first cells in specific rows (A2,A8,A9

are these cells selected all together at once, or just one by one?

In the target sheet it should add or remove rows depending on my selection

where to add: at the bottom?, between such and such? , other?
what to remove?

[MaritimeRob]

Oh sorry for the missunderstanding.
What i meant is that the cells are selected all at once.

To add or remove should be on the target sheet between row 10 and row 30(or more depending on how many row's are selected in the first sheet.)
The reason for this that on the Loading order the head of the doc takes the first 10 rows (loading place, truck number) and the foot of the document also takes 10 rows(signature, stamp, destination).

Remove whas meant in the sense that the document should not contain uneccesary empty rows.

[vichopalacios]

Here you have a workbook with a macro
I hope it Does what you need

Take care to select only one cell each time, using Control Click
following your example column M in "start" is not copied.

[MaritimeRob]

Omg thank you
This is perfect!