datas

Hi Friends, I Have a userform consisting of some textbox. I wanted to add one feature to the textbox1 like Auto filling when we write. Example : I have a sheet where 2 columns are there. One is A and another is B. I have some datas in these columns as well. So when user starts write in...

Hi all, I have been compain 100 files in one master file using VBA, Sub GetSheets() Path = "C:\Users\dt\Desktop\dt kte" Filename = Dir(Path & "*.xls") Do While Filename <> "" Workbooks.Open Filename:=Path & Filename, ReadOnly:=True For Each Sheet In ActiveWorkbook.Sheets...

Hello, Please help me with given sample tables below. First table shows the original datas... Second table is the results what I wanted to get by clicking the button all datas will randomly changed with below conditions. 1. Column A and Column B will be related datas.(If A1 goes to another row...

<colgroup><col span="2"><col><col span="2"></colgroup><tbody> COLUMN-M COLUMN-N COLUMN-P COLUMN-R 1 1 1 6 1 2 2 6 1 3 3 5 1 4 4 3 1 5 1 6 2 1 2 2 2 3 2 4 2 5 2 6 3 1 3 2 3 3 3 6 3 2 4 4 4 5 4 1 </tbody>...

Good Day, I have a data table like below starts from A2 to C19 Is it possible to ruffle those datas randomly by clicking a command button? Every column will remain with same datas ony their rows will be changed... Thank you... <colgroup><col span="3"></colgroup><tbody> NAME1 1 1 NAME2 1 2...

Dear Friends, It would be helpful if someone can help me with following issue. I have an excel sheet attached in the below link. I have two sheets one which i recieve as an input(org). This input sheet should be converted into another sheet(sheet 3) of different format with datas from the...

Dim re As Range, J As Long, jj As Long6 With Sheets("list").Range("a:a").CurrentRegion.Resize(, 15) ReDim a(1 To .Rows.Count, 1 To 15) For J = 1 To .Rows.Count For jj = 1 To .Columns.Count a(J, jj) = .Cells(J, jj).Text Next Next End With With ListBox1 .ColumnCount = 15 .ColumnWidths =...

Good Day, Is it possible to delete the row between (A:AZ) of the last entry of worksheet datas with a code?

Dears, I want to sort the cells A to Z , but the cells does not contain any datas presently. If datas are coming through another program into this excel, then the excel will be automatically converted to pdf with sorting the values. Is any body can help how to sort the empty cells A to Z in excel.

I have a multiple lookup formula which fetches data and shows multiple datas in a single cell. All datas are separated by commas. Is there any way to show multiple datas in separate lines in a single cell. Thanks

Good Day, Is it possible to print datas with calculation? I have huge of datas which located between the columns A:F And listing with a code given below... Application.ScreenUpdating = FalseDim a, i As Long, ii As Long, b(), n As Long ListBox1.Clear With ComboBox4 If .Text = "" Then Exit Sub If...

Hi, Please, a need delete cells equal "*". I try use this code: Sub DelTry() On Error Resume Next Do While ActiveCell <> "" If ActiveCell.Value <> "*" Then ActiveCell.Offset(1, 0).Select Else Selection.Delete Shift:=xlUp End If Loop End Sub But... suceless :( The datas...

Private Sub CommandButton1_Click() Dim LR As Long, i As Long LR = Range("A" & Rows.Count).End(xlUp).Row For i = 1 To LR With Range("A" & i) If .Text = Range("U1").Text Then .Offset(, 1).Resize(, 5).Copy Range("H" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues End If End With...

Hello, Good Day, My main datas are located on Sheet1 Columns A to AH all the way down. Column A has name of the months.Column D is the target datas. I want to put a formula on the Sheet3 cell A6 which will lookup on the same Sheet to cell B1 which has the name of the mounth, will check column D...

Good Day, How can I populate the datas into the listbox base on selected two comboxes. ComboBox1 datas located on column A "showing as months" ComboBox2 datas located on column B "showing as department names" Many Thanks

Private Sub ComboBox9_Change()Application.ScreenUpdating = False Dim a, i As Long, ii As Long, b(), n As Long ListBox1.Clear With ComboBox9 If .Text = "" Then Exit Sub If WorksheetFunction.CountIf(Worksheets("taxi").Range("a:a"), .Text) = 0 Then Exit Sub End If a =...

Here is the deal, i have 2 columns in a google sheet doc with a bunch of values and #error ! and #ref ! I use =$B:$B=max(IFERROR(B:B)) and =$C:$C=min(IFERROR(C:C)) to highlight the lowest value in C and the highest value in B, and ignore errors Problem 1= how to compute the spread and the...

Hi Friends, Good Morning!! I need your help on the below. In the Sheet1, Column A, I have the "N" of rows. Consider 24,000 everytime. In that few has space in the cell. Example: "College ", but it should be "College" (without space). Now i am manually copy all the data's in Sheet2 and using...

Good morning. I'm working on this stuff with the help of the macro recorder. But clearly it's not exaustive for specific needs. I've a workbook named "source". Starting from a sheet named "last" of this workbook, I've to generate a new workbook with some datas and sending it in csv format to...