Search results

Hi SirJB7, Thanks for the advice. The autofilter does work but it filters already hidden rows and the unhide option opens up the unhidden rows which I do not want. the idea is to get all the rows that are not to be hidden to appear on a seperate sheet for reporting and printing purposes...

Hi SirJB7, I have thanks - that is the autofilter option. The other option is difficult to do as I have many rows and to do the record option for the rather long worksheet will also not work. Thanks for the prompt response

Hi Suresh, Thanks for the help but I want to use a formula that looks like this and try move away form the autofilter option. Private Sub Worksheet_Change(ByVal Target As Range) Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = False With ActiveSheet For...

Hi Suresh, Thanks for the help - the idea is perfect. How do I incorporate it to my spreadsheet ? Regards Rob

Hi folks, I have a spreadsheet that has a column with values 1 or 0 and I would like to create a command button that if selected, all the rows in the column F - having a vaule of one (1) would then be hidden. Similarly if the show button is selected all the rows would then be visible again...

Hi Folks, I would like to write a report by using data already captured. As the rows vary I would like only the rows that have a certain value in a cell in the row to print - i hope that makes sense. If I have a value of 1 in Cell F6 then the row from A6 to F6 will be printed and on the...

Thanks I will give it a try. Regards RobSA

Hi Narayan, Thanks for your help. I have tried both files but they do not seem to work on either 2007 or 2010 versions of excel. Regards

Hi Narayan, Thanks for the reply and your time. I can wait - no problem and wil also see if other wish to contribute. Regards RobSA

Hi Narayan, Thank you very much aagain for your help. I have included a dummy worksheet for 2012 as requested. https://www.dropbox.com/sh/fxha3cu3y2llvm9/xkE8eRGxz1?m The first revision is giving up a few challenhes in that it is not showing dynamically on my side. I use Excel 2007 at...

Hi Narayank, Thanks so much for your inputs and help. I am not a specialist in pivot tables or dynamic chart and would appreciate a little more of you time. Please would you explain the following code and how it works ? =OFFSET(Project_Names,MATCH('PROJECT...

Hi Luke, Unfortunatly niether of yourlinks do what I am looking for. Regards RobSA

Hi Luke, Please find my link attached https://www.dropbox.com/sh/fxha3cu3y2llvm9/xkE8eRGxz1 If you open the Quality 6 file the dash has a worksheet called Project Report with Audit results reflecting in the top left corner. I would like to get activity shown in the second file to work in...

Hi Guys, I am working on a rather complex dashboard and require some assitance. I the dynamic charts posted on the Chandoo.org site there is a fille offered for downloading called ChartDate Range2007.xlsx. This is the closest I can get to the desired effects I require. My objective is to...

Hi NeverSayDie, Hui's post is spot on for calcultaing the the total seconds in day and caters for hours, minutes and seconds. 24 hours in a day x 60 minutes in a day x 60 seconds in a minute = the total seconds in a day. The convert minutes to seconds you would only need to multiple the...

Hi Tonya, I am also not sure if it is possible but perhaps the option of submitting the completed data in th eform to a data base is an option. Then retracting the data can be by a process of you accessing the database. You then dont get to see all the emails but the dat is captured...

Hi folks, I think an adaptation of a Gantt chart may work but then again I would stil require your help. Regards RobSA

https://www.dropbox.com/sh/fxha3cu3y2llvm9/xkE8eRGxz1?m

Hi folks, I have two sets of data PLANNED and ACTUAL. I would like to plot the data on the same bar chart where the actual shows in red over the plaaned shown in blue. The periods relate to time and thus the actual could over lap the planned or in fact start ealrier than planned and thus a...

Hi Folks, I would like to know if it possible to have conditional formating on a bar chart ? I have developed a bar chart that has a pass requirement of 95%. If the implementation of the process achieves the pass requirement of 95% and greater the bar remains the colour it is. If however...

Hi Faseeh, I will have a look at the link. I appreciate your help. Regards Rob

Hi Hui, Here is a link for what I am looking at https://www.dropbox.com/sh/fxha3cu3y2llvm9/xkE8eRGxz1?m Regards Rob

Hi Hui, Yes- a "simple" progress completion chart. The chart is sometimes used by project managers to plot the progress of a project and at a glance you can see if youre ahead / behind and compare it to other tings like the resources you have or have not. A draw down chart does a similar...

Hi Mike, Basically it is the spread of costs over time. As the projects starts the slope will be low (starting at 0) and gradually progress upward. The curve changes direction once the work tapers of and moves to its end.

Hi guys, I am trying to find an excel spreadsheet that when I enter data it will produce an S curve ? Any help here would be most appreciated ? Regards Rob