If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Print a sheet area to another...
Hi people, i have another question for you.
Is it possible to print some of a sheet area to another sheet or a form? I have 40 different sheet's in a single workbook. Column A to M is headlines and row 7 to .......... is input in every sheet. My question is; After all the input is done the result in column M appears with text and a background color. Is it possible to print the row's that has ex. red color and the sheet name into another sheet or a form. I need a vb code that can find the red color itself and copy that row with the sheet name to another location no mather if the sheet were it's found is the active one or not. After the user has done that he should have the opportunity to send the result to a printer. Is it possible? |
#2
|
|||
|
|||
Hi Mike
As far as I know, the colour part will not work. It would be better to use a helper column, with different values. The macro can then check whether this cell meets the set criteria, and if so, copy it to the other sheet. To copy the sheet name, read that into a variable, and paste it in the other sheet. The printing part is also no problem. So yes, what you want to do is possible. "Mike" wrote: Hi people, i have another question for you. Is it possible to print some of a sheet area to another sheet or a form? I have 40 different sheet's in a single workbook. Column A to M is headlines and row 7 to .......... is input in every sheet. My question is; After all the input is done the result in column M appears with text and a background color. Is it possible to print the row's that has ex. red color and the sheet name into another sheet or a form. I need a vb code that can find the red color itself and copy that row with the sheet name to another location no mather if the sheet were it's found is the active one or not. After the user has done that he should have the opportunity to send the result to a printer. Is it possible? |
#3
|
|||
|
|||
Hi Kassie.
Well, if the cell's background colour is red the cell value is VH (very high). You mean that i cant find the colour but i can find the value of the cell. That is also ok. Do you have an ex for me "Kassie" wrote: Hi Mike As far as I know, the colour part will not work. It would be better to use a helper column, with different values. The macro can then check whether this cell meets the set criteria, and if so, copy it to the other sheet. To copy the sheet name, read that into a variable, and paste it in the other sheet. The printing part is also no problem. So yes, what you want to do is possible. "Mike" wrote: Hi people, i have another question for you. Is it possible to print some of a sheet area to another sheet or a form? I have 40 different sheet's in a single workbook. Column A to M is headlines and row 7 to .......... is input in every sheet. My question is; After all the input is done the result in column M appears with text and a background color. Is it possible to print the row's that has ex. red color and the sheet name into another sheet or a form. I need a vb code that can find the red color itself and copy that row with the sheet name to another location no mather if the sheet were it's found is the active one or not. After the user has done that he should have the opportunity to send the result to a printer. Is it possible? |
#4
|
|||
|
|||
Hi Michael,
I will really need a lot more info to be able to give you any coding. Basically, what you want to do is the following. Create a variable that can hold the value you want to search for, and one to hold the name of the destination worksheet?. I think you would want to use an inputbox to get the value from the user. varCrit = Inputbox("Enter value to search for") and maybe Set varWkb = Inputbox("Enter the name of the destination workbook") You would count the rows on the sheet? Maybe something like Set myRng = .Range("a2", .Cells(.Rows.Count, "a").End(xlUp)) And then you have to insert code that will test the value of cells in a specific column against varCrit. If the same then copy and paste it to the required workbook. To get started, you can go to tools |Macro|Record new macro, and go through the motions of what you want to achieve. After stopping the macro, press CtrlF11 to view the code you have recorded. Insert your specific requirements and you should be on your way. If you need more specific assistance, as I say, I will need more information on what you want to achieve "Michael" wrote: Hi Kassie. Well, if the cell's background colour is red the cell value is VH (very high). You mean that i cant find the colour but i can find the value of the cell. That is also ok. Do you have an ex for me "Kassie" wrote: Hi Mike As far as I know, the colour part will not work. It would be better to use a helper column, with different values. The macro can then check whether this cell meets the set criteria, and if so, copy it to the other sheet. To copy the sheet name, read that into a variable, and paste it in the other sheet. The printing part is also no problem. So yes, what you want to do is possible. "Mike" wrote: Hi people, i have another question for you. Is it possible to print some of a sheet area to another sheet or a form? I have 40 different sheet's in a single workbook. Column A to M is headlines and row 7 to .......... is input in every sheet. My question is; After all the input is done the result in column M appears with text and a background color. Is it possible to print the row's that has ex. red color and the sheet name into another sheet or a form. I need a vb code that can find the red color itself and copy that row with the sheet name to another location no mather if the sheet were it's found is the active one or not. After the user has done that he should have the opportunity to send the result to a printer. Is it possible? |
#5
|
|||
|
|||
Thank's Kassie.
I think this will help me a lot, i just needed a start (i think :-)..) "Kassie" wrote: Hi Michael, I will really need a lot more info to be able to give you any coding. Basically, what you want to do is the following. Create a variable that can hold the value you want to search for, and one to hold the name of the destination worksheet?. I think you would want to use an inputbox to get the value from the user. varCrit = Inputbox("Enter value to search for") and maybe Set varWkb = Inputbox("Enter the name of the destination workbook") You would count the rows on the sheet? Maybe something like Set myRng = .Range("a2", .Cells(.Rows.Count, "a").End(xlUp)) And then you have to insert code that will test the value of cells in a specific column against varCrit. If the same then copy and paste it to the required workbook. To get started, you can go to tools |Macro|Record new macro, and go through the motions of what you want to achieve. After stopping the macro, press CtrlF11 to view the code you have recorded. Insert your specific requirements and you should be on your way. If you need more specific assistance, as I say, I will need more information on what you want to achieve "Michael" wrote: Hi Kassie. Well, if the cell's background colour is red the cell value is VH (very high). You mean that i cant find the colour but i can find the value of the cell. That is also ok. Do you have an ex for me "Kassie" wrote: Hi Mike As far as I know, the colour part will not work. It would be better to use a helper column, with different values. The macro can then check whether this cell meets the set criteria, and if so, copy it to the other sheet. To copy the sheet name, read that into a variable, and paste it in the other sheet. The printing part is also no problem. So yes, what you want to do is possible. "Mike" wrote: Hi people, i have another question for you. Is it possible to print some of a sheet area to another sheet or a form? I have 40 different sheet's in a single workbook. Column A to M is headlines and row 7 to .......... is input in every sheet. My question is; After all the input is done the result in column M appears with text and a background color. Is it possible to print the row's that has ex. red color and the sheet name into another sheet or a form. I need a vb code that can find the red color itself and copy that row with the sheet name to another location no mather if the sheet were it's found is the active one or not. After the user has done that he should have the opportunity to send the result to a printer. Is it possible? |
#6
|
|||
|
|||
My plesure Michael. If you need any more advice, just post again!
"Michael" wrote: Thank's Kassie. I think this will help me a lot, i just needed a start (i think :-)..) "Kassie" wrote: Hi Michael, I will really need a lot more info to be able to give you any coding. Basically, what you want to do is the following. Create a variable that can hold the value you want to search for, and one to hold the name of the destination worksheet?. I think you would want to use an inputbox to get the value from the user. varCrit = Inputbox("Enter value to search for") and maybe Set varWkb = Inputbox("Enter the name of the destination workbook") You would count the rows on the sheet? Maybe something like Set myRng = .Range("a2", .Cells(.Rows.Count, "a").End(xlUp)) And then you have to insert code that will test the value of cells in a specific column against varCrit. If the same then copy and paste it to the required workbook. To get started, you can go to tools |Macro|Record new macro, and go through the motions of what you want to achieve. After stopping the macro, press CtrlF11 to view the code you have recorded. Insert your specific requirements and you should be on your way. If you need more specific assistance, as I say, I will need more information on what you want to achieve "Michael" wrote: Hi Kassie. Well, if the cell's background colour is red the cell value is VH (very high). You mean that i cant find the colour but i can find the value of the cell. That is also ok. Do you have an ex for me "Kassie" wrote: Hi Mike As far as I know, the colour part will not work. It would be better to use a helper column, with different values. The macro can then check whether this cell meets the set criteria, and if so, copy it to the other sheet. To copy the sheet name, read that into a variable, and paste it in the other sheet. The printing part is also no problem. So yes, what you want to do is possible. "Mike" wrote: Hi people, i have another question for you. Is it possible to print some of a sheet area to another sheet or a form? I have 40 different sheet's in a single workbook. Column A to M is headlines and row 7 to .......... is input in every sheet. My question is; After all the input is done the result in column M appears with text and a background color. Is it possible to print the row's that has ex. red color and the sheet name into another sheet or a form. I need a vb code that can find the red color itself and copy that row with the sheet name to another location no mather if the sheet were it's found is the active one or not. After the user has done that he should have the opportunity to send the result to a printer. Is it possible? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Does excel recognise names rather than cells? | Sue | Worksheet Functions | 9 | May 22nd, 2005 04:51 AM |
How can I set different print areas in the same Excel sheet? | Island Girl | New Users | 2 | May 2nd, 2005 08:16 PM |
Set Print Area Multiple Sheet | TonyB | New Users | 1 | September 29th, 2004 06:23 AM |
Trouble adding non-adjacent cell columns to a print area | JoAnn | New Users | 6 | July 30th, 2004 12:32 AM |
Excel Printing | Annette | Worksheet Functions | 2 | October 17th, 2003 01:14 AM |