Posts by Tom.Jones

Hello,

Please help me with a VBA code, which list the sheet names of files in a folder.
I would like filenames, to be listed in row 1 and the sheet names to be under the name of each file.

Thank you

Re: Reordering data

RoyUK, Thank you very much.

Re: Reordering data

RoyUK, Thank you verry much.

Re: Reordering data

Thank you RoyUK.
Please, can you modify the code, to write headers (STA and SRC) for all columns with data?
Thank you.

Re: Reordering data

Excellent John_W, thank you so much.

Hello,

I kindly ask you to help me with a VBA code to reorganize the data in sheet1 in Sheet2 as it is in the attached file.

Thank you.

Re: VBA - Script to move any kind of documents from one folder to another...

S O

can you attach FileExists function?

Thanks

Re: Counting characters and restart after a certain character count

mikerickson,

Thank you.

Hi,

In Row 1 am certain characters from A1 until BB1. And there, I have a certain character, say #, and I need a formula to count characters from row 1 to the # character in Row 2, and after that character to restart numbering from one to the next character # and so on until the BB1.
Let say that the row 1 is the # character in D1, F1 and K1
In row 2 beginning with A2, I want to show the following sequence of numbers: 1, 2, 3, #1, 1, #2, 1, 2, 3, 4, #3, 1, 2, 3 .... .

Thanks.

Re: Writing in the cell colorful by conditional formatting.

I received. I sent mail to you.

Re: Writing in the cell colorful by conditional formatting.

Thanks for file but I cant explain very well.
Can I send the file (with a single sheet) that you realize what it is? data is sensitive and can not attach the file to the site.

Re: Writing in the cell colorful by conditional formatting.

Thank you for reply Luke M, but for some reason don't work for me.

Hi,

In a range, say E10: AA80, I have a few columns highlighted in yellow (through a formula of conditional formating). These columns are not the same in all spreadsheets (spreadsheets are 15), they differ depending on the sheet. It is possible, using a VBA code, as in all cells colored in yellow, appear word Tk.

Thank you.

Re: Match worksheet name to column heading and then copy and paste relevant column da

Try to uploade a file with no sensible data.

Re: Change code, copy the ListBox selection in sheet range A: I

Excellent. Thank you very much MickG. The code works perfectly.

How can I change this code, so, copy the data in column A, column until I
Now only copies data in column A.

Dim i As Long
Dim ary
    
    ReDim ary(0 To 0)
    With Me.ListBox1
        For i = 0 To .ListCount - 1
            If .Selected(i) Then
                ReDim Preserve ary(1 To UBound(ary) + 1)
                ary(UBound(ary)) = .List(i)
            End If
        Next
    End With
    
    Cells(ActiveSheet.Rows.Count, "A").End(xlUp).Offset(1).Resize(UBound(ary)).Value _
        = Application.Transpose(ary)

Re: Automatically hide from LastRow to the end of rows

Yes this is it. Thank you very much cytop.

Re: Automatically hide from LastRow to the end of rows

Yes cytop, it works but not the way I want. It prevents the user scrolling to them and I want to hide rows if possible.
Thanks.

Re: Automatically hide from LastRow to the end of rows

Thanks cytop,

Somehow not working. Gonna tests.

Hallo,

I need some help.
Copy some data from one sheet to another sheet, but the number of rows is not always the same. How do they automatically hide rows below the last line data.