Posts by 3dplanb@earthli

Re: Filter Data and Copy

Gentlemen,

Thank you for your help I will try this out and let you know how it works

Jim

It actually works Great ! Thanks again. I am going to try an take it from here

Sincerely Jim

Re: Filter Data and Copy

My typing is even slower than your ESP thanks again is the above explianation ok ?

Re: Filter Data and Copy

at the risk of boring you guys wit too much info

each sheet represents a housing development

The purpose is to track the progression of each house in order to schedule
when to begin production of the stairs then when to deliver and then when to install

the key stages of completion are stage 7 8 9
at 7 production
at 8 Deliver
at 9 Install

so the report would look in the stages column of each work sheet
and return all rows containing a 7 8 or 9 in the stages column
placing that info in a printable sheet with the column headings and the project name (which is also the name of the work sheet)
this would give a daily picture of what is ready or upcoming for scheduing

does that make any sense

Thanks for your indulgence
Jim

Re: Filter Data and Copy

I have tried to shrink this to 48k but can't get it that snall so i am posting a link to the file hope that's ok

I sure appreciate all your help http://www.mydogfriday.com/stair%20schedule%20web.xls

Re: Steve Irwin 1962 - 2006 RIP

I agree this was truly sad. Growing up around the same time as Steve many of us dreaned about being the next tarzan. Steve came as close to realizing that dream as anyone could. He was truly a class act and will be missed.

Jim

Re: Filter Data and Copy

Ok it's making sense now

With many worksheets is there a way to automate the process sort of like a report that will do the filter copy and paste on the entire workbook and pastethe results to another sheet with the headers etc ?

Re: if value then goto the next cell and check it out

That works wonderfully for each page individually Thanks

Is there a way to do it with all applicable sheets in the wkbook
?

Re: if value then goto the next cell and check it out

Thanks Jim

I looked through those examples and it appears that they ar looking to copy all the data.

What i am trying to do here is basically create a report that will sort out all the rows that arent at a particular stage of completion each stage has a number from 1-16 depending how far along the house is

Is this something that excel is capable of ?

I appologize for my lack of understanding here.

=+IF('Bella Vida_DRH'!$E72=9,'Bella Vida_DRH'!A72,"")

I am trying to create a sheet that will search for all the rows that contain a 9 in a particular cell

then it will copy that row into a new sheet

if not =9 then it should go and check the next row etc. etc.

this formula works for one cell but doesn't goto the next cell if the value is false

I would really appreciate if some one could point me in the right direction

Thanks alot
Jim

Re: Choose Date From Popup Calendar

That was it! Thanks for all your help

Jim

Re: Choose Date From Popup Calendar

Sub ShowIt()
   Calander1.Show
End Sub

is that the way to use the tags?

Re: Choose Date From Popup Calendar

Thanks Guys this is very helpful

I followed the instructions all the way to the last step where it uses the showit command and i cant get it to work in excel 11 i can go to macros and run it but the hot key option wont bring it up.

A question maybe off topic

Do you ever freelance for smALL jobs like this ?

Is there a way to choose the date to be entered into a cell by having a basic calander pop up and clicking the desired date ?