moving specific data

[caricc]

How can I move specific data from one worksheet to another?
ie- I have data in a misc column that when it get changed it will move the
entire row to another worksheet (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

 

[Bob I]

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

 

[caricc]

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]

Use an Autoexec MACRO?

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.

:

 

[caricc]

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

 

[Bob I]

Have you tried using the F1 key yet?

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

:

 

[caricc]

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]

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

 

[caricc]

Heere what I have: in my wb I have the following ws: post closing, completion
cert, pc except rpt work, final docs report.
What I need is when I place a key word ie "ws name" in a misc field (col G)
in ws pc except report work I need the row to copy to the Corresponding ws. I
can get it for one row but I can't get others to follow when the changes are
made in col G. Col G is the same for all ws. any help thanks.

 

[caricc]

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

 

[Bob I]

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

Worksheet setup:
The First Sheet is named THIS1 and the "lookup" Sheet name should be in
G1 on the THIS1 sheet. 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
ActiveSheet.Paste

End Sub


Edit or alter the Macro as you see fit.

 

[caricc]

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

 

[Bob I]

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

 

[caricc]

?

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

 

[Bob I]

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

 

[caricc]

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]

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

 

[caricc]

You lost me with "DOWN ONE".

 

[Bob I]

"Goto Last cell", puts you on the last data cell on the spreadsheet. You
obviously do not want to select that row, so you will down arrow one row
to get to a clear row. ("down one")

 

[caricc]

this is ok for this portin gbut the following still hasn't been asnwered:

I am trying to get information from one worksheet to several others in
the same workbook. But I can't seem to get only new data to move.
I have one worksheet where all the data is placed. Then when one column
is changed I need it to move to the corresponding worksheet. I have a
misc. column that when it is changed from a blank to one of the 3
following choices: post closing, completion cert, or final. I need to
get only the new rows from the main sheet to copy to these 3. Then when
the post closing and completion cert have the same misc column changed
to final its to cut and paste to the final ws. any help would be
appreciated.

Thanks in advance.