Re: moving specific data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

?

"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