columms

  1. K

    Show Columns dynamically

    Hello, I'm looking for a way, preferably Power Query, to have a sheet with a table or text file with column names that are visible when loading a spreadsheet. For example I have a csv with the following columns: <colgroup><col></colgroup><tbody> Caption IP_Address AgentPort...
  2. M

    Copy and paste data in multiple columns in to one column

    Hi there, I have data in multiple columns on Sheet "Fields" - from A-AS. Each column varies in data and has 1-100 rows populated. I wish to take all this data from these columns and paste them into one column on the "Sheet3" tab. On the fields tab there is a header row which I do not require...
  3. WERNER SLABBERT

    DUMB Question: SUMIFS with only one date... but multiple entries in about 10000 rows...

    <tbody> Ref Company Date Company INV Number Sub Total Expenses Difference Grand Total Paid Credit Status Date Sum Outstanding Amount Sum by Date 1 Test 2018/10/03 Test 2018/10/03_Test0001 Test0001 R3 888,00 R2 110,00 -R 4 002,00 R 5 998,00 Yes OPEN -R 4 002,00 0,00 43377 43376 2 test...
  4. P

    Seach for string in all colums and sheet and delete row(s) is perfect match

    Hi I hope you can help me. The following macro works but it also deletes columms that partly contains the string its searching for. 'Sub Remove_columns() ' Dim wS As Worksheet ' For Each wS In ThisWorkbook.Worksheets ' With wS ' For i = .Columns.Count To 1 Step -1 '...

Some videos you may like

This Week's Hot Topics

Top