Re: $$Excel-Macros$$ VBA Macro for data split as per the specified format

Sub create() Dim wk As Worksheet, wk2 As Worksheet Dim i As Long, k As Long, z As Long, s As Long On Error Resume Next Sheets("T1").Delete Sheets("T2").Delete On Error GoTo 0 Sheets.Add(after:=Sheets(Sheets.Count)).Name = "T1" Sheets.Add(after:=Sheets(Sheets.Count)).Name = "T2" Set wk = Sheets

$$Excel-Macros$$ VBA Macro for data split as per the specified format

Dear experts, please provide the vba macro for attached excel sheet format split into separate sheets those formats are mentioned in the excel kindly do the needful thanks alot. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Fa

$$Excel-Macros$$ Macro to automatically convert prt scr image-based text to real text in cell

I need help programming my Excel VBA Macro to do OCR (text recognition) from a prt scr screen capture image and input the text into cells. Currently my Excel file has a push-button, and upon clicking on it the macro pastes into Excel the current clipboard image I have created by pressing prt

$$Excel-Macros$$ Re: Issue with Range and If statment

Error is shown because you cannot use the value of a range in IF statement. You can only use the value of each cell in that range. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook