Hi all. My first post so thanks in advance.
I have a excel doc that contains a list of names, say 10 columns. I need to move these into a new sheet under different headings.
The column data always starts at row 10 due to headers and other data that is required.
The rows sizes are always different depending on how many people attend an event.
I will be running each row independently so if I could get an example using the following I may well be able to do the rest.
Lets get their names;
Sheet2 Column B At Row 10
Move to Sheet1 Column L Row 4
I am quite happy using VBA
Thanks
Scott