Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Tansfer Between Worksheets
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Tansfer Between Worksheets
Hi
have a look at http://www.rondebruin.nl/copy5.htm -- Regards Frank Kabel Frankfurt, Germany I'm kind of new to VB and how it works with Excel. I'm wondering if you 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 have a column where the user will check a box when they want the contents of the row, from column B to column F, to be transferred to worksheet two. Can anyone point me in the right direction to get this working? I have a feeling it is a rather simple thing to do, but since I am new to this, I am having trouble getting started. I apprecieate any help you can provide. Thanks, Sean --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Tansfer Between Worksheets
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 -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Tansfer Between Worksheets
Hi
yes this is correct. It will run against the whole spreadsheet -- Regards Frank Kabel Frankfurt, Germany Thanks for the link. I have a question related to that. After examining the contents of the link, it looks like it adds the contents all the rows that have a particular string in the column. The only problem I can think, is that everytime they run the script, it will add the information to the second worksheet again. Then id begin to get duplicate information on the second worksheet. Am I readin that right? Thanks, Sean --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Tansfer Between Worksheets
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 -- Regards Ron de Bruin http://www.rondebruin.nl "eeboater " wrote in message ... Thanks for the link. I have a question related to that. After examining the contents of the link, it looks like it adds the contents all the rows that have a particular string in the column. The only problem I can think, is that everytime they run the script, it will add the information to the second worksheet again. Then id begin to get duplicate information on the second worksheet. Am I readin that right? Thanks, Sean --- Message posted from http://www.ExcelForum.com/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Tansfer Between Worksheets
I add this to the webpage also
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... 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 -- Regards Ron de Bruin http://www.rondebruin.nl "eeboater " wrote in message ... Thanks for the link. I have a question related to that. After examining the contents of the link, it looks like it adds the contents all the rows that have a particular string in the column. The only problem I can think, is that everytime they run the script, it will add the information to the second worksheet again. Then id begin to get duplicate information on the second worksheet. Am I readin that right? Thanks, Sean --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I link data between worksheets when data is transposed? | Excel Discussion (Misc queries) | |||
How to consolidate all worksheets data into 1 worksheets? | Excel Discussion (Misc queries) | |||
Merge data in two worksheets based on key data value (like databas | Excel Worksheet Functions | |||
Update data linked between worksheets when resorting data | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |