Glad you could fix your problem
Thanks a lot for your Thanks ...AND for the Like
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 ... !!!
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
Display More
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 ...
To switch to a different layout, see attached your test file ... without any macro ...
Hope this will help
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 ..
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