I need assistance,

I need to create a macro that changes the positions of certain cells within a selected area.

A 3 row times 7 cells area will be selected and a macro run, the macro should change the positions of certain cells. Is this possible? I have managed to create one macro that will change the positions but it won’t work for selected areas, all the cells needs to be specified.

So the question is, more simplified, can you create the macro so it will change all the cells within the selected area to a position relative to the first selected cell (or similar solution)?

The total will be approximately 10-15 movements to rearrange the cells.

For each month we receive long list in a pdf format at work and currently we have to enter all the information manually, I know how to transfer the files to the excel spreadsheet but the cells needs to be rearranged for it to be workable..

Any help would be much appreciated!

Kind Regards,

Mattias