Search results

Hi, I have recreated entire worksheet ...and now i am able to insert the formulas and get the count ....but only problem is Today()-1 is not working Like : =COUNTIFS('Calls Breached'!H:H,"Sev-1",'Calls Closed'!I:I,TODAY()-1) =COUNTIFS(Sheet2!H:H,"Sev-1",'Calls Closed'!I:I,TODAY()-1) its...

Hi,, Can you suggest me any pivot table approach where i can get at least Severity count for all the sheets so that i can copy the same to summary sheet??

Thanks it clarifies everything...

Hi Marc, need your inputs.. can i add two more sheets in this ...and in future i may need to add some more sheets in it ...how do i change the code...as you mentioned in your previous post "No as I wrote code works with the first 8 worksheets " ..just want to know if can i add more sheets...

same i checked with other data its working...seems some problem with my previous excel file...thanks

is this because i have sheets name something like below??

Hi Mark, its working perfectly for TEST1 file, but its only a dummy file. the original file contains some thing like the below and its 10MB file so i don't want to upload it i made changes as below W = Array(0, [{"RequestID", "Customer Name", "Product","Severity","Assignee", "Status"...

Hi, I am getting below error Run-time error '40036': Application-defined or object-defined error i made changes according to my original data.

sorry....its my mistake ....yes its sheet1, sheet2 ........sheet7 :-(

ohh!! what i mean to say is in other sheets also it will be same like sheet4 ("M", "Module", "Severity") sheet5 ("RequestID", "Product", "Severity", "Assignee") sheet6 ("RequestID", "Username", "Severity", "Assignee") sheet7 ("RequestID", "Username", "Module", "Assignee") hope its fine now.. :)

here is the http://chandoo.org/forum/threads/looking-for-a-vlookup-vba-code-for-my-report.33650/#post-200328 link for TEST1 file

you can take TEST1 file as an example which is attached previously in same page. in that i have 7 sheets, in live environment i have around 25 to 30 columns in each sheets that's why i don't want look what are other column names , just i am looking at what i want that is with column names . in...

i have different columns with different name in 7 sheets ...i have to work with particular columns only remaining all columns not required ..so i am concentrating on those columns mentioned in above code.. remaining all should be deleted.

Thanks all for the suggestions provided...its now working properly.. this forum seems to be more active compare to other keep it up..

when i tried with original data i got that message ....i will try once again and update you..can i insert some more sheets and do vlookup as in array there is no integer is mentioned?

it worked but showing type mismatch at msg = msg & "User """ & ws.Cells(i, 2) & """ from: " & ws.Name & vbCrLf

Hi, i am not getting correct data with this code can you see above there are still some names with #N/A , after running the code for cross verification i did the vlookup manually and found some names which are not matching still present in report

Hi, I am trying to correct this code . Option Explicit Sub delColumnsNotInDictionary() Dim d As Long, ky As Variant, dict As Object Dim c As Long, lc As Long Set dict = CreateObject("Scripting.Dictionary") dict.comparemode = vbTextCompare dict.Item("Sheet1") =...

Hi, this works for me wonderfully ....want to know if lookup is done using column number or column heading ...because when i checked original data sheets in some sheets column B heading name is used differently like "Customer name" and as i mentioned in dummy sheets its "Username". i hope it...

pleas find attachment ... i have attached dummy data.. raw number may increase and decrease in sheet1-7 but sheet8 is fixed

The sheets1-7 look like file1 and columns in sheet1-7 look like file2 I need sheet1-7 vlookup with sheet8 (sheet8 look like file3) usernames which are matching should be saved and remaining which are not matching (i.e #N/A) in sheet1-7 should be deleted. sheet8 is only for vlookup purpose...

i am looking for a vlookup VBA code for my project. i have Multiple sheets llike sheet1,sheet2,sheet3,....upto sheet7 in these sheets i have different columns and a usernames column (column B) as common. i have one more sheet8 in same excel work book in that i have only one column with name...