| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro To Sort and Seperate Data on Serpate sheets from a Master Li
I'm using excel 2003.
I have a worksheet full of maintenance data. Each row on this sheet has a machine number, date, repair information, etc. I'm trying to make a marco to search thur the list for a specific machine number copy all the data from that row and paste it on a different sheet. All of the entries for that machine number would then be copied to that new sheet. Does anyone know how to do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro To Sort and Seperate Data on Serpate sheets from a Master Li
Hi Troy
See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troy" wrote in message ... I'm using excel 2003. I have a worksheet full of maintenance data. Each row on this sheet has a machine number, date, repair information, etc. I'm trying to make a marco to search thur the list for a specific machine number copy all the data from that row and paste it on a different sheet. All of the entries for that machine number would then be copied to that new sheet. Does anyone know how to do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro To Sort and Seperate Data on Serpate sheets from a Maste
I think i worded my question wrong. I do not want to create a new sheet.
the sheets that the data is sperated on would already be created. So I woud have one source sheet with all machines on it. machine A, machine b, etc. Everytime a machine breaks, the user will fill out a row of data starting with the machine name. (example: "machine A"). These rows of data will be filled out at random. Then in the same workbook there would be several sub sheets, one for each machine. I want to hit a comand button on "Machine A's" sub sheets to run a query on the source sheet to return all of the row entries that are listed as "Machine A" I'm new to programming so that's probably why I don't understand the link you sent. "Ron de Bruin" wrote: Hi Troy See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troy" wrote in message ... I'm using excel 2003. I have a worksheet full of maintenance data. Each row on this sheet has a machine number, date, repair information, etc. I'm trying to make a marco to search thur the list for a specific machine number copy all the data from that row and paste it on a different sheet. All of the entries for that machine number would then be copied to that new sheet. Does anyone know how to do this? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro To Sort and Seperate Data on Serpate sheets from a Maste
This macro will do what you want
http://www.rondebruin.nl/copy5.htm#below Be sure you filter on the machine number column and the sheet names have the same name as the values in this column Test it in a new workbook Copy a part of your table in a new workbook and run the code -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troy" wrote in message ... I think i worded my question wrong. I do not want to create a new sheet. the sheets that the data is sperated on would already be created. So I woud have one source sheet with all machines on it. machine A, machine b, etc. Everytime a machine breaks, the user will fill out a row of data starting with the machine name. (example: "machine A"). These rows of data will be filled out at random. Then in the same workbook there would be several sub sheets, one for each machine. I want to hit a comand button on "Machine A's" sub sheets to run a query on the source sheet to return all of the row entries that are listed as "Machine A" I'm new to programming so that's probably why I don't understand the link you sent. "Ron de Bruin" wrote: Hi Troy See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troy" wrote in message ... I'm using excel 2003. I have a worksheet full of maintenance data. Each row on this sheet has a machine number, date, repair information, etc. I'm trying to make a marco to search thur the list for a specific machine number copy all the data from that row and paste it on a different sheet. All of the entries for that machine number would then be copied to that new sheet. Does anyone know how to do this? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro To Sort and Seperate Data on Serpate sheets from a Maste
Thanks for the help. It's working!
However, it copies the previous data everytime the macro runs. Is there anyway to make it were it only updates new data from the source sheet? "Ron de Bruin" wrote: This macro will do what you want http://www.rondebruin.nl/copy5.htm#below Be sure you filter on the machine number column and the sheet names have the same name as the values in this column Test it in a new workbook Copy a part of your table in a new workbook and run the code -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troy" wrote in message ... I think i worded my question wrong. I do not want to create a new sheet. the sheets that the data is sperated on would already be created. So I woud have one source sheet with all machines on it. machine A, machine b, etc. Everytime a machine breaks, the user will fill out a row of data starting with the machine name. (example: "machine A"). These rows of data will be filled out at random. Then in the same workbook there would be several sub sheets, one for each machine. I want to hit a comand button on "Machine A's" sub sheets to run a query on the source sheet to return all of the row entries that are listed as "Machine A" I'm new to programming so that's probably why I don't understand the link you sent. "Ron de Bruin" wrote: Hi Troy See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troy" wrote in message ... I'm using excel 2003. I have a worksheet full of maintenance data. Each row on this sheet has a machine number, date, repair information, etc. I'm trying to make a marco to search thur the list for a specific machine number copy all the data from that row and paste it on a different sheet. All of the entries for that machine number would then be copied to that new sheet. Does anyone know how to do this? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro To Sort and Seperate Data on Serpate sheets from a Maste
You can delete the lines you have copy in the same macro
Do you want that ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troy" wrote in message ... Thanks for the help. It's working! However, it copies the previous data everytime the macro runs. Is there anyway to make it were it only updates new data from the source sheet? "Ron de Bruin" wrote: This macro will do what you want http://www.rondebruin.nl/copy5.htm#below Be sure you filter on the machine number column and the sheet names have the same name as the values in this column Test it in a new workbook Copy a part of your table in a new workbook and run the code -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troy" wrote in message ... I think i worded my question wrong. I do not want to create a new sheet. the sheets that the data is sperated on would already be created. So I woud have one source sheet with all machines on it. machine A, machine b, etc. Everytime a machine breaks, the user will fill out a row of data starting with the machine name. (example: "machine A"). These rows of data will be filled out at random. Then in the same workbook there would be several sub sheets, one for each machine. I want to hit a comand button on "Machine A's" sub sheets to run a query on the source sheet to return all of the row entries that are listed as "Machine A" I'm new to programming so that's probably why I don't understand the link you sent. "Ron de Bruin" wrote: Hi Troy See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troy" wrote in message ... I'm using excel 2003. I have a worksheet full of maintenance data. Each row on this sheet has a machine number, date, repair information, etc. I'm trying to make a marco to search thur the list for a specific machine number copy all the data from that row and paste it on a different sheet. All of the entries for that machine number would then be copied to that new sheet. Does anyone know how to do this? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro To Sort and Seperate Data on Serpate sheets from a Maste
Hi Ron,
I used the code which copies the data in a different sheet, it worked great, thank you, however one little change that i cant make, i want the macro to name the sheets based on data on Col F2, how can i modify the code? thanks david "Ron de Bruin" wrote: Hi Troy See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troy" wrote in message ... I'm using excel 2003. I have a worksheet full of maintenance data. Each row on this sheet has a machine number, date, repair information, etc. I'm trying to make a marco to search thur the list for a specific machine number copy all the data from that row and paste it on a different sheet. All of the entries for that machine number would then be copied to that new sheet. Does anyone know how to do this? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro To Sort and Seperate Data on Serpate sheets from a Maste
Do I understand you correct that after it copy the data to a sheet you want to name
the sheet as the value in F2 ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "David" wrote in message ... Hi Ron, I used the code which copies the data in a different sheet, it worked great, thank you, however one little change that i cant make, i want the macro to name the sheets based on data on Col F2, how can i modify the code? thanks david "Ron de Bruin" wrote: Hi Troy See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troy" wrote in message ... I'm using excel 2003. I have a worksheet full of maintenance data. Each row on this sheet has a machine number, date, repair information, etc. I'm trying to make a marco to search thur the list for a specific machine number copy all the data from that row and paste it on a different sheet. All of the entries for that machine number would then be copied to that new sheet. Does anyone know how to do this? |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro To Sort and Seperate Data on Serpate sheets from a Maste
Hi Ron,
Yes, however i realized that that i may have multiple data in col q with the same value in f2, so it wont work. "Ron de Bruin" wrote: Do I understand you correct that after it copy the data to a sheet you want to name the sheet as the value in F2 ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "David" wrote in message ... Hi Ron, I used the code which copies the data in a different sheet, it worked great, thank you, however one little change that i cant make, i want the macro to name the sheets based on data on Col F2, how can i modify the code? thanks david "Ron de Bruin" wrote: Hi Troy See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Troy" wrote in message ... I'm using excel 2003. I have a worksheet full of maintenance data. Each row on this sheet has a machine number, date, repair information, etc. I'm trying to make a marco to search thur the list for a specific machine number copy all the data from that row and paste it on a different sheet. All of the entries for that machine number would then be copied to that new sheet. Does anyone know how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data sort seperate by blank row | Excel Discussion (Misc queries) | |||
| Macro to create seperate sheets | Excel Programming | |||
| Sort out data on seperate sheet | Excel Programming | |||
| SORT/SEPERATE DATA | Excel Discussion (Misc queries) | |||
| Macro to query data from a succession of websites and display in seperate sheets | Excel Programming | |||
![Troy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
