Re: moving specific data

Tech-Archive recommends: Fix windows errors by optimizing your registry

Start the recorder, click Edit, click Goto, click special, click Last Cell.

caricc wrote:

?

"Bob I" wrote:


record "Goto" last cell and then "down one" before selecting row on the destination ***.

caricc wrote:


This is a good start but I will need to add to existing rows without recopying the data
to the next ***. So is there a way to add updated rows from the selected sheets based on the changed criteria. 

"Bob I" wrote:



Use the following as an Example and is only one method of doing the "lookup and copy"

Work*** setup:
The First *** is named THIS1 and the "lookup" *** name should be in G1 on the THIS1 ***. Data to be copied is in row one in "THIS1"

Paste or replicate the macro below:

Sub Macro1()
'
' Macro1Macro

   Sheets("THIS1").Select
   Range("G1").Select
   MyPick$ = ActiveCell.Value
   Rows("1:1").Select
   Selection.Copy
   Sheets(MyPick$).Select
   Rows("2:2").Select
   Active***.Paste

End Sub


Edit or alter the Macro as you see fit.

caricc wrote:


I am looking to append the changed row into the corresponding ws. based on the name entered in col G(misc).

"Bob I" wrote:




When recording the Macro, be sure to select the ***, and then Select the info.

caricc wrote:




Yes, I have used the F1 key. I have also recorded a macro to do what I want, but I can't get the macro to take the updated rows and copy/move them to the ws where I need to have the info placed. I have selected the field made my changes then made it so it will copy and paste the row to the next ws. The macro is only picking the selected rows original to the macro and not properly adding rows to the next ws. Any suggestions?

"Bob I" wrote:





Have you tried using the F1 key yet?

caricc wrote:




So how is this done. I am a novice at using these features.

"Bob I" wrote:






Use an Autoexec MACRO?

caricc wrote:





What I am trying to do is make this an automated feature using vb in the background of the workbook. It's a shared workbook and others have to use this without cut/copy/paste. 

"Bob I" wrote:







You may copy the data of interest from one spread*** to another.

caricc wrote:







How can I move specific data from one work*** to another?
ie- I have data in a misc column that when it get changed it will move the entire row to another work*** (within the same workbook). Then when it's changed again it will move to another...etc...as teh work on it progresses?

Thanks in advance, caricc 




.

Quantcast