datas

  1. M

    How to determine date responses when their values are different

  2. S

    VBA UserForm || Textbox Autofill Using Worksheets

    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...
  3. J

    compain multiple files in one file

    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...
  4. A

    Shuffling the datas base on their columns and rows.

    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...
  5. A

    Counting formula by multiple columns

    <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>...
  6. A

    Randomly mixing datas base on same columns..

    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...
  7. K

    Converting excel sheet from one format to required format

    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...
  8. A

    Listbox with header option

    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 =...
  9. A

    Code to delete row.

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

    Excel cells sorting

    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.
  11. D

    Multiple Lookup in single cell

    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
  12. A

    Listbox printing and converting to PDF FİLE...

    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...
  13. Leandroarb

    Loop to Selection.Delete Shift:=xlUp

    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...
  14. A

    Code to filter datas and copy on cells

    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...
  15. A

    Count if formula by two sheets

    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...
  16. A

    Filter datas base on by two combobox and populate them into the listbox.

    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
  17. A

    Userform filter datas by two combobox criteria.

    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 =...
  18. G

    How to compute spread and % difference between highest and lowest value in 2 columns?

    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...
  19. V

    TRIM using VBA

    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...
  20. Nelson78

    Add workbook and automatic dispatch via mail

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top