Data Tansfer Between Worksheets

  • Thread starter Thread starter eeboater
  • Start date Start date
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
 
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
 
Hi
yes this is correct. It will run against the whole spreadsheet
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Excel 2013 Merge Data 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Find a string within a string 2
Normal Use of a Worksheet With a UserForm Showing? 1
Suming a column to another worksheet 2
Transfer data between two worksheets 10
Copy data from 1 sheet to multiple worksheets 2

Back
Top