Hi
The basic on what i want to be able to do if possible is:
If 2 or more cells are selected (below one another) and i press run, then Copy the info in the top cell to 1 sheet, and copy the info in the 2nd cell, into a 2nd sheet.
I also need to make sure that if only 1 cell is selected, that it only copies the info from that single cell.
Is this possible? Any advise would be great
Cheers
Maybe:
Please Login or Register to view this content.
If 1 cell is selected then the cell will just be copied to Sheet2, if 2 then they will be copied to Sheet2 and Sheet3.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thanks for that Dom, but its not quite what i was after.
Its still better than anything i've come up with so far....
At the minute, If 2 cells selected it copies the same the same value to sheet 2 and sheet 3.
Ideally i need it to copy the 1st cell value into sheet 2 and the 2nd cell value into sheet 3
Aye, it wasn't quite right. Try:
DomPlease Login or Register to view this content.
Thats spot on!
Cheers for your help Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks