vab

Hi, Please help me with the below, as I have data for 2 different dates and I need a vba code in excel so if i select a date on the dashboard it would populate the data for the given date only. Thank you in advance.

Hi, I have searched in many forums but don't get the best result the suit to my problem. I have two worksheets of a workbook. One is the "Data" and the other is a "Calculation". First Condition: When I select any cell in between Column I8:I1220 of the Data Sheet, the cell value is immediately...

Hi Folks I need small macros removeing Last 5 character of the Word In Exp: AT_1833 I need AT only. Removring _1833

Hello, Having trouble with a user form I am building. What I am trying to accomplish is a calculation to auto show in textbox1 the number of days between today and what is entered in datepicker1 - even when datepicker 1 is at default of today. Thank you,

Hi folks, Thank you for you support. I have search in google i find below from this sit(https://www.datanumen.com/blogs/create-login-window-protect-excel-workbook/) but it not suitable for me. Because of have 30 users and this code very long and user login not recode so. Please help me this...

Hello Every one Dim T as Variant T = InputBox("Enter Your CORP ID") ChDir "\\Client\C$\Users\T\Desktop" ActiveWorkbook.SaveAs Filename:= _ "\\Client\C$\Users\T\Desktop\From Application to MIS_V.0.1.xlsm", _ FileFormat:=xlOpenXMLWorkbookMacroEnabled...

hello , how to find duplicate rows and then copy and paste to a separate sheet, it must match the entire row contents. below are sample data: from A to Q column, total 2047 rows including heading. <tbody> 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0 0 0 0 0...

Hello, I have a document containing 3 sheets. sheet 1 pulls data from an external source sheet 2 uses index and match to locate and copy errors sheet 3 will record errors collected by sheet 2 sheet 2 is using index/match formulas to locate information there is 100 rows with the index/match...

Could some kind soul please advise me on VBA coding to complete the following; Search the Completed column (G) of the ToDo List worksheet for any date entries. If any entry found to cut and paste the entire row(s) onto the Archive worksheet (Ensuring they are pasted into the next free row)...

I'm dealing with a dataset that has columns that should be negative values, often those values are pasted from a source file which has them as positive numbers, thus far I am doing a paste special with the mutiply operation having copied a "-1" to the clipboard. I'd really like to avoid the few...

Dear All, I am trying to create a macro that will set the Lock check box to True for a cell if Conditional Formatting rule #1 for that cell is True. I borrowed some code and ended up with the following that does not work correctly. This code never results in a True. I don't understand...

I would like to create a custom function that would convert a date in format mmddyyyy into a string with the format yyyymmdd. Here is an example 04/03/2009 (April 3rd 2009) ---> 20090403 I have the following code so far, but the only thing it returns is "0" <link rel="File-List"...