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?

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?

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?

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
<Ctrl><F11> 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?

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
> <Ctrl><F11> 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?

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
> > <Ctrl><F11> 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?