Data Tansfer Between Worksheets

E

eeboater

I'm kind of new to VB and how it works with Excel. I'm wondering if yo
guys could enlighten me a little bit on how to resolve my problem.

I have a workbook with two worksheets. On the first worksheet, I hav
a column where the user will check a box when they want the contents o
the row, from column B to column F, to be transferred to workshee
two.

Can anyone point me in the right direction to get this working? I hav
a feeling it is a rather simple thing to do, but since I am new t
this, I am having trouble getting started.

I apprecieate any help you can provide.

Thanks,
Sea
 
E

eeboater

Thanks for the link. I have a question related to that.

After examining the contents of the link, it looks like it adds th
contents all the rows that have a particular string in the column. Th
only problem I can think, is that everytime they run the script, i
will add the information to the second worksheet again. Then id begi
to get duplicate information on the second worksheet. Am I readin tha
right?

Thanks,
Sea
 
R

Ron de Bruin

You are right

You can delete the records that you copy in the new sheet in the
same macro and use the second macro on the page to add
records again.

Or simple delete the sheet first
Add this code to the macro

On Error Resume Next
Application.DisplayAlerts = False
Sheets("Netherlands").Delete
Application.DisplayAlerts = True
On Error GoTo 0
 
R

Ron de Bruin

I add this to the webpage also
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


Ron de Bruin said:
You are right

You can delete the records that you copy in the new sheet in the
same macro and use the second macro on the page to add
records again.

Or simple delete the sheet first
Add this code to the macro

On Error Resume Next
Application.DisplayAlerts = False
Sheets("Netherlands").Delete
Application.DisplayAlerts = True
On Error GoTo 0
Click to expand...
 
Top