PC Review


Reply
Thread Tools Rate Thread

complicated copy/paste/delete

 
 
Chris
Guest
Posts: n/a
 
      21st Oct 2006
any guidance on how to;

cut an paste indivdual cells from one worksheet into individual cells
on a new worksheet. The data that I want to copy is currently loaded
into a combobox on a userform from worksheet 1. Additionally, on the
userform I have 12 or so text boxes loaded (the row being based on the
selection of the combobox) I have an additional button on the userform
meant to move the data to the other worksheet.

I also need to invoke an additional userform after the selected cells
are copied from worksheet 1 to worksheet 2. The additional userform
will be used to fill in some other unique values in cells on the same
row that the other cells were just copied to in worksheet 2

After that process is complete, I need the entire row on worksheet 1 to
be deleted.

The third catch is that when all is said and done, I need the data on
worksheet 2 put in adding a new row and copying the formulas from the
previous row on.

I am working with ranges on both worksheet 1 and worksheet 2.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with VBA - complicated copy and paste Vegas Lady Microsoft Excel Programming 2 20th Jan 2010 09:47 PM
Offset,Match,Copy, Paste Special - A Complicated Task - Help Pleas =?Utf-8?B?TWFyayBEdWxsaW5naGFt?= Microsoft Excel Programming 2 8th Mar 2007 11:33 PM
Copy and paste has got complicated. Help please =?Utf-8?B?UmF5?= Microsoft Excel Misc 1 9th Sep 2006 04:26 PM
Copy, Paste then delete =?Utf-8?B?TG91aXNl?= Microsoft Excel Programming 2 22nd Mar 2005 03:41 AM
Delete Key and copy & Paste Problems Lindah Microsoft Windows 2000 1 4th Sep 2003 04:21 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:19 PM.