Open .mdf files

Hello , please help... I'm trying to copy rows from master table sheet to different sheets based on the value of the cell in the column:

The column "AL" contains several values (validation list) for example dog, cat, giraffe... I'd like to automatically open new sheet for every value and copy the relevant rows to the new sheet. (the new sheets must have the name of the value).

In addition when a new data is added, I need the new rows to be added to the correct sheet

Sub Copy_Data()
Dim r As Range, LastRow As Long, ws As Worksheet
Dim v As Variant, s As String, LastRow1 As Long
Dim src As Worksheet
Set src = Sheet...

Good morning to all, can someone please tell me how to convert ounces (oz) to milliliter s (ml). Thanks
JPortillo

Hello,

I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard.
Normally to edit a cell, I would select the cell and hit F2, but the Logitech Bluetooth keyboard reserves F1-F3 for pairing different devices to the one keyboard (sounds neat!).
Anybody know of a shortcut to edit a cell that does not involve the F2 key?
thanks so much for any help!

System Configuration: Windows / Internet Explorer 11.0

Hi,

Is there a way to create a new tab based on column A?
For example: I want to create a new tab for each vehicle, copy and paste all of vehicle 722's columnA to Column F cells then move on to create a new tab for 725 and copy and paste all 725's Column A to F to the new tab. if the macro can also name the tab name as vehicle number that would be great.



this photo is just an example, Im dealing with 4000 rows so I am wondering if this is possible with a macro.

Thanks in advance.

Hello sir :
I want to find the student position.
But those student who fail in exam not incldue in the position.

Hello,

I would like to know how to remove the "False" Value when if function is nested. Here is an Example


=IF(G23=0,P15/Sum(D11:F11,IF(G23>0,P15/Sum(D11:G11))))

anytime G23 is greater than 0 I get False