Search results

Awesome, Thanks Nebu for all your hard work -it is appreciated

Dear Faseeh, It works like a dream. I still however have a problem with #N/A in the same worksheet. The cells in H17:H43 and P17:43 revert to #N/A for some unknown reason. I can correct it by placing my cursor at the end of the formula in each cell and then pressing enter. However I cant do...

Hi Nebu, I have made the adjustments as requested by copying the macro over and adjusting the range. The problem still exists. (See attached file) I have circled the errors in the report sheet.

Hi Nebu, The subroutine is for the table below on the same tab, correct

Hi Nebu, Thanks - I have made the adjustment and the error is averted however the change does not happen as planned. Sub test() Application.ScreenUpdating = False Dim arr Dim i As Integer, j As Integer cnt% = 71 For i = 17 To 42 arr = Split(Range("H" & i), " / ") For j =...

Hi Nebu, I have made the change and an error occurs , stating that the named argument could not be found. The debugger opens and highlights "DataOptions:=" which seems like th latest adjustment we have made.

Thanks Nebu. I will try it as requested. Is it necessary to clear the range or does it occur automatically?

Dear Faseeh, Thank you for the reply. The "LOG" is the name of the worksheet and I have selected a range called "DATA" The VLOOKUP is based on the report page and its intention is to first read the value in C71 which should be equal to 017_B. IT will then look for the range called "DATA" and...

Hi Nebu, Thank you for the feedback. I have made a change to the macro so as to work for two tables. The macro works except that the sorting is not acurate on both tables. For example the number 017_B is not coming before the number 006_D I think it would be good to build in a clear range...

Dear Faseeh, Thanks for reconnection. The cell in question is in the REPORT worksheet D71

I feel brain dead in trying to resolve this problem. The following formula returns the value of #N/A =IF(C114="","",VLOOKUP(C114,DATA,3,FALSE))

Hi Nebu, Thanks for helping me resolve this matter -the macro works perfectly. In terms of the #N/A i think it would be best to continue that discussion under another post. http://chandoo.org/forum/threads/values-keep-changing-to-n-a.26584/#post-158860 When I search for the value 017-B in...

Hi Nebu, This looks awesome. I like what you have done in terms changing the value into an integer. When I use the search function it allows me to find the value and can perhaps reduce the error I am getting with the Vlookup function, returning a #N/A. Can the macro include for a sort...

Hi Faseeh, I have had a look and in using the Find option, I changed the option to look for values as opposed to looking for formulas or comments. The number 017-B is then found. What do you advise I do to the valuein order for the file to read correctly?

I will do - thanks for the reply

Hi Faseeh, Thanks for the prompt reply. The data comes from the "LOG" worksheet. CIF you scroll down the "REPORT" page you will see a similar situation and I thinkn it is as a result of the errors or N/A problem we are discussing.

please find file attached

Hi Folks, I am working in a work sheet which uses the formulae CONCATENATE. The formulae works and presents the correct value required however as I continue to work with the worksheet, the value changes to #N/A and this impacts others cells in the work sheet. What could be the reason for...

Hi Nebo, The idea is correct. However the numbers are separated by "/" so the grouping should not occur in this desired list. It should be that there be one number per line. These numbers are brought form the two columns in the "Log" sheet, B11 & AH11. using the concatenate function provide...

Hi Nebo, Thanks for you response. The values in the table as indicated by yourself can be replaced. They were my attempts to get the process to work. In providing explanation: The numbers that are listed in the column "Submittal Numbers to be returned by 77 Construction Company" (i.e 017-B...

HI Nebo, Please find the xlsb file attached

HI Nebo, The file i have is 1.4 Mb big and thus difficult to post here

Thanks Nebu -is that however my only choice ?

Hi Folks, I hope you can assist. I have two spreadsheets (MSR07112015 & Report). My data rest in the first and I wish to create a "dynamic" table in the Report, that is when the data changes in the first spreadsheet, the reported data will change. I have tried using the INDEX function and get...

Hi Hui, The correction has worked well for the upper table, however the lower table now has duplications. Can you assist?