Posts by Carim

Quote from Mehmetozkan

Great job Carim

Thanks for your attention

Glad you could fix your problem

Thanks a lot for your Thanks ...AND for the Like

Let me clarify one point :

Do we agree that last two digits of the date of birth are located in cells R4 and S4 ....

and not in cells L4 and M4 as you indicated ...

Moreover, an important Remark :

please NEVER NEVER use MERGED Cells .... they will only create HUGE headaches for you ... !!!

As already indicated, should you rather have a macro for your spreadsheet ...

just attach a sample file ... without any of your confidential data...

Thanks for your file

As soon as I have a moment, will take a look at the rules you have prepared ...

Thanks for your Thanks

Hello again,

You could test following modification

Private Sub ComboBox1_Change()
    If ComboBox1.ListIndex > -1 Then
        Application.DisplayAlerts = False
        wb1 = ComboBox1.Text
        Set r = Worksheets(wb1).Range("A18:A38", "D18:D38")
        Set dest = Worksheets("Sheet1").Range("K9", "N8")
        r.Copy
        dest.PasteSpecial Paste:=xlPasteValues
    End If
' Convert into Kilo Hertz
    For i = 9 To 28
        If Cells(i, 11) > 999 Then
            Cells(i, 11) = Cells(i, 11) / 1000
            Cells(i, 12) = "kHz"
        End If
    Next i
End Sub

Hope this will help

Thanks for your file

It does make things much much easier ...!!!

As soon as I have a moment, will look for a solution ...

Hi,

Attached is a proposal

Hope this will help

Hello,

To make everything much easier for everyone ... just attach a sample file to illustrate your expected result ...

Glad you could fix your problem

Thanks for your Thanks ... AND for the Like

To switch to a different layout, see attached your test file ... without any macro ...

Hope this will help

Once you have had a look at your Version 2 ... feel free to share your comments

You have added a password which prevents any body from accessing your sheets ...

It seems to me your question has been answered ...

Can you explain your latest message # 7 ...

Just had a quick look at your latest request ...

You are very seriously over-complicating your own life ...!!!

At the initial stage, you should not worry about HOW the macro will be launched ... !!!

1. Build a clear understandable workbook structure

2. Keep in mind simplicity will make your life ( and maintenance ) easier

3. Create the reports and macros you need

4. and ... as a last step, think about how to run your macros ...

By the way, for your own information ... all previous macros were already built with " two dimensional lookups " ...

since, you needed to have a series of Offsets for the Columns ... and multiple criteria for the rows ...

Before diving into you new request ...

Just a quick warning about your Worksheet_SelectionChange() ... since it is built quite ' dangereously '

and could cause you many problems ...

From your different explanations, cannot determine if an Event macro is precisely what you truly need ...

Could you attach a sample workbook which properly illustrates all your constraints ... and your expected result ..

Quote from Mehmetozkan

I think the variable wb1 has defined as the user select the sheet from the combobox.

Agree with you ... but the question remains ... what are the choices presented in the combobox ...???

OK ... so after adding a second dimension ...

Do you plan to add a third dimension ...

Hello,

If you are getting a compile error 1004 message at the line #10 ...

it probably means the worksheet name added in the TextBox1 does not match a worksheet name in your file ...

Hope this will help