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?