Re: moving specific data

This works to a degree. The problem here is now it will start placing the
data after the "LAST CELL" and not in the next available row. This is carried
out to the end of the structure of where I need it.

"Bob I" wrote:

> 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
> >>>>>>>>>>>>
> >>>>>>>>>>>>
> >>
>
>
.