Search results

Hi Sid just use COUNTIFS function like that COUNTIFS($B$2:$B$24;"Inscope";$C$2:$C$24;"Azhar") This should resolve your problem. Cheers slaya_cz

Hi all I copy file from my computer to other users' computers using FileCopy command in my macro. However, I am unable to run this file on the other computers (I have admin access) through macro. I tried "cmd" command with path to the file, but it obviously works only for local, not network...

Hi Capo Mele check if you have VB filter range set for the whole table - otherwise please send here the file to test it. Good luck slaya_cz

Hi hsahoo84 try the following code. It will open all xlsx files and save it as xls. I keep the original (xlsx) files in the folder (so you have some kind of backup). Hope it will help. Best regards slaya_cz Sub open_save() With Application.FileDialog(msoFileDialogFolderPicker)...

Hi kalpeshpatel maybe something like this? Sub Macro1() Dim Password Password = InputBox("Enter your password:", "Password", "********") If Password = "password" Then MsgBox "Access available", vbInformation, "Access" ' there is rest of...

For sure it can be done through macro, but what about use of VLOOKUP? Just use one additional column with CONCATENATE function, so if the columns are 997 90 Rupa the used function is CONCATENATE(A1;"x";B1;"x";C1) You see as result "997x90xRupa". You add this additional...

Hi rsk then just change formula to cover all the sheets - i.e. if you have 3 sheets, formula is =COUNTIF(Sheet1!A:A;Sheet3!A1)+COUNTIF(Sheet2!A:A;Sheet3!A1) in order to test first two sheets. Definitely, much easier (from my point of view) would be to have all the data at one sheet, with...

Hi rsk I would recommend to use additional column into next sheet with the formula like that =COUNTIF(Sheet1!A:A;Sheet2!A1) I assume that projects ID are displayed in the column A, started from cell A1. All ID with result different than zero are displayed in the previous sheet, so you can...

Hi xlfan check this, I hope that it will help you - each time, when there is start date lower than last end date for particular machine it will display notice information http://www.2shared.com/file/f2WdEfFx/Machines.html Kind regards Pavel