Search results

Ah ha - thank you.

Hi Hui, It should be showing the value 017 and 020

Thank you for your reply - new file is uploaded

Hi Folks, I am having a problem with the concatenateif function. I have highlighted the problem in red fill in the DTS worksheet. The idea is that upon obtaining a value in a column the number reflected in column b of the LOG worksheet must be listed. The problem is that the number of time...

Hi Folks, In the attached worksheet I have been assisted in getting the data in the upper table (worksheet ) to perform correctly. I my own effort to get a similar result in the lower table on worksheet 1, but this time following the criteria "IN REVIEW" (column T of the work sheet called LOG...

Hi Ramesh, Please could you assist with the formula for the part added at the bottom of worksheet 1. I am trying to do the same as for what we worked on yesterday but just using data from different columns. I think the concatenate option does not seem to work in this instance.

Thank you

Thanks, the idea is great. Can I change the range from AC7:AC148 to AC3:AC502 without affecting th e overall result. The range you have selected works, however with regular inputs I need to be sure taht the full range of information will be considered, under the various filtering conditions...

Hi Ramesh, If I can explain differently. The numbers listed in the column C8 to C32 in Sheet 1 are the occurrence between certain values. What I am trying to do is automate the process of writing the numbers seen in column H of Sheet 1. So if there is an occurrence of a number between say...

Thanks for the prompt reply. Please see my work in Sheet 1

Hi folks, I have a spread sheet that entries numbered 1-500, in column A, I have numbers in another column that relate to list the days outstanding. I have used a formula to count the number of times the days are outstanding between 1 & 10, between 11 & 20 and between 21 & 30, continuing until...

Thanks Deepak

Hi Folks, My plan is to take data from various cells in a worksheet and transfer it to a different workbook and present this data in rows. I have tried to do this in the following macro Sub Macro2() ' ' Macro2 Macro ' ' Dim itemProjectName As String Dim itemScopeofWork As String Dim...

Dear SirJB7, Absolutely amazing how you have put this all together in so little time - WELL DONE. If I may make some comment: The TABS are not the prescribing determinants for the information found in column A "Report Month". The report month information is provided by the inputs provided in...

Dear SirJB7, Thank you for your prompt reply. Your advice is appreciated. In reply I have: Removed the column E that was in previous sheets and changed the formula "=IFERROR(INDIRECT(UPPER(TEXT($A5;"mmmyy")&"!D"&COLUMN()+4));"")" Removed the sheet "START" & "END" Changing the TAB numbers to...

Dear SirJB7, Thank you for your response and the work done so far in adding value to the proposed final product. I have uploaded a revised version of your file and made some comments within that may help us in going forward. I look forward to your replies. Regards Rob

Thanks for the reply. The Macro button works well. It however does not perform the function I had intended and that is when I receive monthly data in a form as seen in the JAN14 tab, the data that is entered for the "this month" column as well as the "workplace detail" be captured in rows...

Hi Folks, I have a standard excel sheet which allows team members to enter data from several sites. My challenge is the consoildation of this data to a single worksheet in sequential rows. Is there perhaps someone out there that can provide advice / example? Regards Rob

Hi guys, I am working between two version of excel (2007 at the office) and 2010 at home. I have a worksheet which works with active boxes but when I change the print page or hide a column the active boxes do not stay where they are surposed to. How do I control that ? Regards Rob

Hi SP, Thanks for you help - the code works well. I have found that there is one challeneg in this regard and that is if there is a cell that is merged say F10 with F11 then the macro doesnt hide the row in F10 but carries on with the remainder. The process also seems to be rather slow and...

Hi SP, Thanks for you efforts and help it is appreciated. Please find my file at this link https://www.dropbox.com/s/si1e2o2i0on1p6y/Quality%20Dashboard%20-%20Master%20File.xlsm The work sheet I am working with is QMS IMP The idea is to hide the row which has the value 1 in Column F...

Hi sgmpatnaik, Thanks for your help. I am using excel 2010 Regards

Hi sgmpatnaik, Thanks for your help. I am using excel 2010 Regards

Hi sgmpatnaik, Thanks for your help. The file you loaded unfortunalty does not work and has no macro attached to the button -or perhaps none that I can find. Perhaps you can advise if the macro above is a functionalmacro - as I do not know how to write the macro at all. Regards Regards