Not sure were to post this.....*lol*
I need to have a MAIN workbook query a DATA workbook (usually closed) and update with the new records added. That is User1 enters data in DATA.xls User2 opens MAIN.xls and can update his MAIN.xls with any new records added in DATA.xls.
Long story short, I’m...
Not sure were to post this.....*lol*
I need to have a MAIN workbook query a DATA workbook (usually closed) and update with the new records added. That is User1 enters data in DATA.xls User2 opens MAIN.xls and can update his MAIN.xls with any new records added in DATA.xls.
Long story short, I’m...
thanks the set up you gave me works great...! :)
However the results are deleting not adding to the range I send to.....xlInsertDeleteCells is this the problem ?
Would like to use a variable insteat of the hard code for the time " '2004-01-24 16:23:06' "criteria in this query.....
With ActiveSheet.QueryTables.Add(Connection:= _
"ODBC;DSN=Excel...
Using the following sub to act as a filter....
I have about 5000 records.
This sub is low...!
is this the fastest way to show and hide rows based on the same logic of the below cod ?
can I incorporate the logic in a filter ?
Sub OptionButton3863_Click()
Dim rr As String...
getting a error when I try to incorporate....Sub OptionButton3862_Click()
Application.ScreenUpdating = False
For Each r In Sheets("Master").Range("A:A")
If r.Row > 4 Then
If r = "" Then Exit For
If IsNumeric(r) And r >= 2000 Then
r.EntireRow.Hidden = True
Else
If...
Thanks...works great...
PS:
I need a function to determine if a value of a cell is numeric and if not just extract the numbers in order from left to right ....:)
Hi Skip...thanks for the reply....
I put 3 optionbuttons on my worksheet(forms/optionbutton)
I would like the following :
Sub OptionButton3861_Click()
if OptionButton3861 = true do nothing
else
ActiveSheet.Cells.EntireRow.Hidden = False
End Sub
I would like to use 3 option buttons to hide/display rows depending on which option button is selected.....
How would I trigger macro ?
how would I know which option button is checked ?
Working with a worksheet which has numbers preceded by '.
Ex: cell content = '123
which makes the number seen as text...how can I remove the ' to get all my data as numbers ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.