Search results

Hello there, I ask for how can i apply "approximate match" VLOOKUP in PowerPivot, as i need to add a calculated column to match the data in column called AHT Install.. in powerpivot to match it _with an approximate method_ with an other column located in different sheet called "AHT Matrix" eg...

Hi, i need you support in handling this issue for distribute a duration of time to quarters, as i have a phone calls duration for IDs, this calls need to distribute its duration to intervals, eg: if a call duration is 0:21:0 from 10:05 AM till 10:26 Am, so this call is located in 2 interval...

@NARAYANK991 , so sorry for confusing the VBA is unprotected now the workbook have multiple forms, the listbox is lacated at a form that titled: "Rewarding" this form is called from "LoginUF" , button of "Rewards" from the Interface you can Hit Agent Login Icon then fill at username field...

Sorry, the excel sheet accessed the limit to upload so that you can download it from the below URL http://1drv.ms/1wX0KWR Gratefully,

Dear, Please i need support in retrieving the autofilter data to listbox, as when running the code the autofilter is reflecting the the source sheet only but the listbox have the entire range Private Sub btn_Redeem_Click() Application.ScreenUpdating = False Dim crng As Range With...

Ok, Can I use the table name in retrieving the user as after that i'll have more than one table contains a user for multiple level authorization Gratefully,

@Somendra Misra , sorry the first user only that have the access to login and the rest of users is not Gratefully,

1: The Users will change passwords after that, these password are defaults 2: the username will be unique without any duplication Gratefully,

@Somendra Misra , thanks a lot for your effort, sorry if the case isn't clear at 1st post, there is a sheet called "User" that contain the Users and its password that need to give them the access, need to login with these users, when fill the password in its field the password is visible, i...

Dears, i need support in userform VBA, as i have a workbook with 4 spreadsheets >> Sheet titled "Interface" have a userform Icon to access with user name and passwod the rest of sheets are very hidden are called "Data 1" & "Data 2" and "Users" the "Users" have the usernames and passwords that...

@Somendra Misra as usual your support is highly appreciated thanks a lot,

Hello there, i have a looked up data with a different format but i can't create a chart for this data at sheet called "Interface" need to create a charts for this inputs thanks a lot,

Hi, sorry i can't get exactly how can i solve this problem, the file is saved already with XLSM. could you please clarify how can i save the hidden sheets to a new XLSM file Thanks a lot,

Dears, kindly i need your help in solving a trouble in shared workbook as this sheet have an "user form" for authorization level option. when saving this workbook in any PC, the workbook has been crashed without saving. i noticed when deactivate the authorization level option the problem is go...

Hi steve, i need to know the creator of this ticket, and this data is exported with the shown form, the employee name is filled within a "large text" when exporting the employee name can match some results else in my report

@Somendra Misra & @Steve May can i depend on the 2nd table in exporting the name only, as at my data source the word of "Chat Support" isn't followed always by a Name. check the full data thanks a lot,

Dears, i seek for a function could help me in extracting a name form a text like text: [11:29:15] Chat queued to Live Chat Support Amr Nasr name: Amr Nasr need to extract the names from this text, the attached file contain 2 tables, the first have a data that need the extraction the 2nd...

Dears, i have a code that i can mail some row to a specific users in the sheet that called "Mailinfo" Sub Send_mail() Dim OutApp As Object Dim OutMail As Object Dim rng As Range Dim Ash As Worksheet Dim Cws As Worksheet Dim Rcount As Long Dim Rnum As Long Dim...

Dears, i have a workbook that contain multiple spreadsheet, the 1st "interface" contain 2 userform to retrieve some data based on multiple inserted criteria, when fill the userform data a popup sheet called "Output" will retrieve some columns from the source sheets, the rest of the other...

@Deepak Dear, if available i need another request may be complicated for me but according you are providing i think that it will like a piece of cake for you, at agent userform at Rewarding button i need this data to be preview in a form not in an excel sheet >> for every agent, there is, at...

Hello, thanks a lot, it's really do a perfect job

Dear @Luke M it's go well thanks a lot,

Hi @Luke M thank you for replying, unfortunetly i face an error when activating the above code in highlighting this line with yellow color Set destWB = Workbooks.Open(filePath) the destination for the "Database" workbook is \\10.11.240.10\ds-wfm\Adora\Bus Test\database.xlsx thanks a lot,

Hello, i need a help in paste a range from sheet to another one in a different workbook i have a workbook called "Main" want to copy a schedule range from a sheet called "Preview" in columns ("A:F") to another workbook called "Database" in an active sheet called "Adherence" but i need to copy...

Hi Deepak, Ok there is no problem to apply these changes in users as you clarified the users has been modified, and what about of retrieving data it will be the same retrieved in post #38. thanks a lot,