Sub T()
For Each sht In ActiveWorkbook.Sheets
sht.UsedRange.Value = sht.UsedRange.Value
Next
End Sub
Try this
Mandeep baluja
On Wednesday, 29 March 2017 12:54:31 UTC+5:30, Sundarvelan wrote:
>
> Dear Friends,
>
> I have excel book with 70 to 90 sheets, each sheet
Apply data validation in D4:D100 with Custom
formula =COUNTIFS($D$4:$D$30,D9,$A$4:$A$30,A9)=1
Regards
Mandeep baluja
On Monday, 17 April 2017 09:46:30 UTC+5:30, big smile wrote:
>
>
> Hello Friends
>
> I want that Column A & Column D this both contains if matches
&g
Show me the new output for the new format.
Regards
Mandeep baluja
On Tuesday, 26 July 2016 02:22:13 UTC+5:30, Mike B wrote:
>
> Hi All,
>
> Please find an updated workbook with three worksheets which show the "New
> Format" of data the "Old Format" of data and
Try this formula and drag it down.
=LEN(F5)-LEN(SUBSTITUTE(F5,"o",""))
' Regards :- Mandeep baluja
'https://www.facebook.com/groups/825221420889809/
'https://www.linkedin.com/in/mandeep-baluja-b777bb88
Add a share if it helps :)
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
please share your sheet without password after pasting this code so that i
can check.
On Monday, May 16, 2016 at 12:45:30 PM UTC+5:30, Ashkan Razania wrote:
>
> It didn't work. same problem
>
> On Monday, May 16, 2016 at 1:17:15 AM UTC-5, Mandeep Baluja wrote:
>>
>> Au
Share your sheet otherwise its not possible what the other variables
holds Position ?? Player ??
Regards :- Mandeep baluja
'https://www.facebook.com/groups/825221420889809/
'https://www.linkedin.com/in/mandeep-baluja-b777bb88
On Friday, May 13, 2016 at 7:28:01 AM UTC+5:30, Jaime Richmond
In b1 put this formula =IF(A1>0,TODAY(),"")
On Sunday, May 15, 2016 at 4:54:53 PM UTC+5:30, NIJ wrote:
>
> is there any function in excel (2003) for
>
>
>
> if value more than 0 entered in cell say A1 should show today's date
> in cell B1
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Autofill works in scenario if data you want to paste it down similarly.
What you're doing is selecting two columns and pasting it more than 2
columns that's not possible bro.If you wish to paste your data
automatically you can do this by selecting the appropriate no of columns.
Private Sub
Great Paul
On Tuesday, May 10, 2016 at 4:53:10 PM UTC+5:30, Paul Schreiner wrote:
>
> What I mean is:
>
> Protection can be at either the Workbook level, WorkSHEET level, or both.
> Some of the worksheets are protected.
> It LOOKS like the workbook protection flag is set, but the workbook
ivot 101 value (NA)").Cells(Rows.Count, 18).End(xlUp).Row
Range("R7:R" & lr).FillDown
End Sub
' Regards :- Mandeep baluja
'https://www.facebook.com/groups/825221420889809/
'https://www.linkedin.com/in/mandeep-baluja-b777bb88
Add a share if it helps :)
'***
every code
>> to avoid flickering.
>>
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concis
;up" Then
Sheets("to").Cells(i, 2).Value = ""
Sheets("to").Cells(i, 1).Value = ""
End If
Next i
End Sub
Regards,
Mandeep baluja
https://www.linkedin.com/messaging/thread/6086488646137958400
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
PFA and let me know !!
Regards,
Mandeep baluja
https://www.linkedin.com/messaging/thread/6086488646137958400
https://www.linkedin.com/in/mandeep-baluja-b777bb88?trk=hp-identity-name
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
>
> Ya I did this for consecutive sequence of 19,23,28 ,Please find the
> attached formula in the file with helper.
>
Regards,
Mandeep baluja
https://www.linkedin.com/messaging/thread/6086488646137958400
https://www.linkedin.com/in/mandeep-baluja-b777bb88?trk=hp-identity-name
Send me the sheet !!!
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please
zaks Every thing is possible Except my increment :P !! Elaborate what you
wish to combine from Every sheet.
@ Devendra :Same process, but for workbooks you need to loop files in
folder one by one and Consolidate it !!
*Regards, *
*Mandeep baluja *
*https://www.linkedin.com/messaging/thread
ed" Then
sht.UsedRange.Copy ws.Range("A" & Cells(Rows.Count,
1).End(xlUp).Offset(1, 0).Row)
End If
Next
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A
Simple use this formula after pressing the button, Without any hassle
,Clear sheet after doing work.
>
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>
> Haha !! Glad to Help Bro :P,Thanks for providing the references otherwise
>> it will be cumbersome to look values !!
>>
>
Regards,
Mandeep baluja
https://www.linkedin.com/messaging/thread/6086488646137958400
https://www.linkedin.com/in/mandeep-baluja-b777bb88
>
> Use a mail merge option in word You can refer to google to see step by
> step process,In my early phase I tried this for more than 2000
> customers,Create an excel sheet set the tags in Word mail merge it will
> create that for you.
Regards,
Mandeep baluja
--
Ar
We can't entertain manual changes request, As your data is not correct Lots
of typo errors in this Ex: "Wednesdsy",Extra Spaces in no particular trend
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Joi
e greater than 12,dates should not exceeds 31.
Please find the attached Data
Regards,
Mandeep Baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
If Target.Count > 1 Then Exit Sub
If Target.Value <> "" Then
If Not Intersect(Target, Range(Cells(lr, "A"), Cells(1048576, "A"))) Is
Nothing Then
Cells(Target.Row, 2).Value = "Entry done at: " & Now()
End If
End If
End
Check this out !!
Sub getproperties()
On Error Resume Next
rw = 1
Worksheets(2).Activate
For Each p In ActiveWorkbook.BuiltinDocumentProperties
Cells(rw, 1).Value = p.Name
Cells(rw, 2).Value = p.Value
rw = rw + 1
Next
End Sub
Regards,
Mandeep baluja
--
Are you =EXP(E:RT
>
> Do you have more than 1 macro ? Why don't you paste the code in notepad
> and simply replace Msgbox with 'Msgbox and paste it in vba module.
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! J
Tried 15 times every time it works perfectly !!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor
eNum, " ' MsgBox " & DQUOTE & "All objectes
deleted successfully" & DQUOTE
LineNum = LineNum + 1
.InsertLines LineNum, "End Sub"
End With
End Sub
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
>
> check my code
>
https://groups.google.com/forum/?hl=en%3Fhl%3Den#!searchin/excel-macros/mandeep%7Csort:date/excel-macros/x6VYCJQs1lg/7lMf8CAuDgAJ
Regards,
Mandeep baluja
https://www.linkedin.com/messaging/thread/6086488646137958400
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
>
> check my code
>
https://groups.google.com/forum/?hl=en%3Fhl%3Den#!searchin/excel-macros/mandeep%7Csort:date/excel-macros/x6VYCJQs1lg/7lMf8CAuDgAJ
Regards,
Mandeep baluja
https://www.linkedin.com/messaging/thread/6086488646137958400
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Resolution Try this Regards, Try to change the directory path and run the
macro where you have access. Mandeep baluja
Examine the path of the WebDir and DBDir folders. To do this, log into
Forecaster by using the SYS user and then clicking the company link. Both
the WebDir and the DBDir
in
googlechrome but not in internet explorer you will see when you do. And
then lookup for last file downloaded in download folder and copy paste the
data.
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook
d
Set destpath = Application.FileDialog(msoFileDialogFolderPicker)
destpath.Show
destfld = destpath.SelectedItems(1) & "\"
' Debug.Print destfld
For i = 1 To Range("A" & Rows.Count).End(xlUp).Row
fName = Cells(i, 1)
FileCopy Sourcefld & fName, destfld &am
>
> Small error in paul code change this line Set fc = fl.Files to Set fc =
> fldr.Files
>
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://w
>
> Check this out !!!
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread tit
>
> Check this out !!! Regards, Mandeep baluja
>
Sub MyFilter()
Dim path1 As String
Dim lngStart As Long, lngEnd As Long
lngStart = Range("f1").Value 'assume this is the start date
lngEnd = Range("g1").Value 'assume this is the end date
>
> *What are the parameters/criteria to do the bold,Give us output format
> required and list of words that need to be bold by giving example in Excels
> sheet.*
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TI
nrows
Searchstring = .Range("A" & nrow).Value
searchchar = cmparr(i, 1)
Strtpnt = InStr(1, Searchstring, searchchar, vbTextCompare)
endpnt = Len(cmparr(i, 1))
If Strtpnt <> 0 Then
.Range("A" & nrow).Characters(Strtpnt, endpnt).Font.Bold = True
>
> PFA !! thread closed !!!
Regards,
Mandeep baluja
https://www.linkedin.com/messaging/thread/6086488646137958400
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebo
>
> hey Man,
>
Read what i wrote bro on side *Put these values in column F as values you
will get the desired result** ,which means Copy cells Q2:Q21 go to cell f2
and do pastespecial paste as values check your results then.*
*Regards, *
*Mandeep baluja *
--
Are you =EXP(E:RT) or
Hey Fabio,
Please clear the doubts
3 Tabs means Three worksheets ??
Add means merge ??
Filter the data on what criteria ??
Are you looking to merge files with VBA code automatically ?
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
cel files ,Now you have the names of file you are interested in
!!
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RUL
Check this out and let me know !! Regards, Mandeep baluja
Sub SearchDir()
Dim i As Long: i = 2 'A variable to paste values in main
sheet
Dim Searchword As Variant 'Search value to be used
Dim Wbmain As Workbook 'Main workbook
Dim fldAs Object
,3columns to right)
Here the value of L9 = 3 which is column which means 3 columns to right*(Which
is not defined in Array)* from starting and M9 = 1 Which is the row
*Change your array to :- $A$64:$D$501 *
*Regards, *
*Mandeep baluja *
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A
PFA !!
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
>
> Use the worksheet event to trigger, It depends on you where you want to
> place date.
>
Private Sub Worksheet_Change(ByVal Target As Range)
'Application.EnableEvents = False
Range("E1").Value = Date
'Application.EnableEvents = True
End Sub
Regards,
Mandeep baluja
>
> Check this result of your first query. Second will done after completing
> my ofc work :D Not have much time to involve today
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official F
>
> check this formula !! I don't use solver in my work if I can achieve this
> with simple formula
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this fo
>
> This question has gone over my head !!! Need a better explanation for this
> !!
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.fac
>
> This can be achieved easily with the VBA code, Why don't you give it a Try
> to loop files reside in folder and open it and checking all sheets one by
> one and use find method to search for specific keywords.
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(
PFA !!
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles
on what
website you're using and what tags value you wish to achieve.
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
Please send a personal msg to him !! Thread closed !!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor
Show me the file with absentees not updated so that i can check and rectify
it once again.
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com
ot;Sheet3").Cells(Rows.Count, 11).End(xlUp).Row
For i = 1 To l1
ReDim Preserve varout(1 To counter)
varout(i) = ws.Cells(i, 1).Value
counter = counter + 1
Next
' MsgBox Join(varout, ",")
For j = 1 To l2
ReDim Preserve varout(1 To counter + 1)
varout(counter) = ws.Cel
>
> Didn't get what is ref.name ??? Didn't find it anywhere in your data,Will
> it be possible if you share the output required format.
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official F
Does output sheet created for each Pref value given below ?? if yes are
these sheets created in same workbook with Pref name if not, means you need
only one sheet for pref 10001 ?
Regards,
Mandeep Baluja
Pref 1001 1002 1005 1007 1009 1005 25000 151233
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
>
> PFA !! Ticket closed
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread tit
Hey Devendra,
Asked for output format? your query is not understandable. data shuffled
all the data ??,
Show me the output you require for this data given below :-
Col 1Col 2
A10,8year,5 year,15
B15,20year,17
D30,50 year,12
--
Are you
Multiply date with 1
On Thursday, January 14, 2016 at 5:54:19 PM UTC+5:30, neeraj chauhan wrote:
>
> Dear sir,
>
>
>
> Thanks sir !!
>
> Kindly share the formula.
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com
>
> Your Date is not date but to convert a date to number you can simply
> multiply it with one this scenario works most of the cases but not for all.
>
For Example your date is in A1 put formula in b1 = A1*1
Regards,
Mandeep baluja
ticket closed
--
Are you =EXP(E:RT) or =
Check this out I have extended your date to 1 to 15 as instructed
Regards,
Mandeep baluja
Sub Fill_Absents()
Dim workrngNE As Range
Dim workrngPE As Range
Dim workrngSS As Range
Dim Datasheet As Worksheet
Dim Nrows As Long
Application.ScreenUpdating = False
Set ws = Sheets("Consoli
>
> Can you please provide the output format you're looking for, This will
> help us for better understanding.
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this fo
Hey Kat,
I am sorry but i didn't get the logic of this code which is totally
different from your above query,Things which i understand its just checking
whether file_name following the criteria or not,
if 9th letter of the file name is equal to R then do something else show
error in all
>
> PFA !! Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
Put this in f8 =MAX($C$8:$C$11)
put this in g8 =MIN($C$8:$C$11)
Ticket closed -
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
n interval
Confirm this first !!
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread ti
>
> Hey check this out !!
>>
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise,
eir score 30& 10 = 40 gets divided by 4. so
the score in k4 is 20,l4=30,m4=0,n4=0,o4 =25 & p4=25,*so that final score
in i4 is 100. if any parameter goes "No"*, then its number get deducted
from total score.
8) Also, in k11, why the score is 20. It should be 10 only accordin
Check this out !!
REgards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
Let me know !!
Sub CreateSheetsDemo()
Dim wb As Workbook
Dim wbtemp As Workbook
Dim Workrng As Range
Dim uniquename As Variant
Dim Dic As Object
Dim lr As Long: lr = Sheets("Order").Cells(Rows.Count, 4).End(xlUp).Row
mypath = ThisWorkbook.Path & "\"
:(.
Once the file is downloaded rest of work is easy
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
Glad to help !!!
Regards,
Mandeep baluja
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thr
Did you run the code in input file ? Have you tried debugging of code step
by step ? Why paste:=xlpasteall is deleted ? I have not received this error
while running this code something u are doing wrong unintentionally.
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
>
> Try This code !!
>
Sub CreateSheetsDemo()
Dim wb As Workbook
Dim wbtemp As Workbook
Dim Workrng As Range
Dim uniquename As Variant
Dim Dic As Object
Dim lr As Long: lr = Sheets("Order").Cells(Rows.Count, 4).End(xlUp).Row
mypath = ThisWorkbook.Path & "\"
>
> Check this out,Easily achieved with formula
> {=IFERROR(INDEX(Raw!$D$2:$H$85,MATCH('WAVE 1'!$A4&'WAVE 1'!B$2&'WAVE
> 1'!$A$2,Raw!$A$2:$A$85!$B$2:$B$85!$C$2:$C$85,0),MATCH(B$3,Raw!$D$1:$H$1,0)),0)}
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =
Check this out !! and let me know
Sub CreateSheetsDemo()
Dim wb As Workbook
Dim wbtemp As Workbook
Dim Workrng As Range
Dim uniquename As Variant
Dim Dic As Object
Dim lr As Long: lr = Sheets("Order").Cells(Rows.Count, 4).End(xlUp).Row
mypath = ThisWorkbook.Path
07ad6d#gid=0;
ie.Visible = True
Application.SendKeys "%+FD{Enter}", True
End Sub
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discus
Check this out !!!
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
Hi,
Kindly elaborate your query !!
Regards,
Mandeep Baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread
,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
to retrieve and on what criteria as
you sales table have duplicates.
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
Check this attachment !! userid for admin is : admin and password is 123
same as for Guest.
Regards,
Mandeep baluja
https://www.facebook.com/groups/825221420889809/
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
Check this out is this you're looking for !! Regards, Mandeep baluja
Sub GetDetails_of_Sheet()
Dim ws As Worksheet
Dim i As Long: i = 2
On Error Resume Next
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each sht In ActiveWorkbook.Sheets
If sht.Name = "
g and date format to
mm/dd/ you will get the correct results.
Now, As I checked the Question You Can solve it by Simply using Correct
formats of Date by changing Dates Format.
Note:: Don't forget to remove the Spaces around your Text
Thanks,
Mandeep baluja
--
Are you =EXP(E:RT) or =NO
Run this code !! Mandeep baluja
Sub SplitPara()
Dim lr As Long: lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
Dim j As Long: j = 0
For Nrow = 2 To lr
arr = Split(Trim(Range("A" & Nrow).Value), vbLf)
ReDim arr1(LBound(arr) To UBound(arr))
For lb = LBound(arr)
Check this updated Attachment !!!
Regards,
Mandeep baluja
https://www.facebook.com/groups/825221420889809/
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
Check this out !!
Mandeep baluja
On Wednesday, December 9, 2015 at 3:31:45 PM UTC+5:30, Sadiq wrote:
>
> Hello Team ,
>
>
>
> I have a excel sheet where have Team Name in “A” column and in “B” column
> we have count. I need Team name details in another sheet with
Go to tools reference enable microsoft internet controls, microsoft html
object librarary. I did the coding to process data from excel to this
website but unable to fill the datepicker control working on Jquery to do
the same that will soon post the same.
Regards,
Mandeep baluja
Check this out and let me know !!!
Two formulas to be used !!
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
Check this out !!!
Regards,
Mandeep baluja
On Wednesday, December 9, 2015 at 5:22:27 PM UTC+5:30, Sadiq wrote:
>
> I did not required the count of name .
>
> I need that names in cells of given count.
>
> e.g -
>
> Name- Sadiq
> Count 20
>
> I need
Hi,
Give us a clear explanation to what to achieve by giving some output !!
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
Thanks Bro,I tried my best took some help from my friend lokesh for
Datepicker control. By google chrome select the tag element and see the
name by right click and go to inspect element and check the name !! You
Can't name them but you can assign it to objects and do the manipulation on
; your requirement.
Regards,
Mandeep baluja
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor threa
>
> Find the attachment and let me know !!
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Us
Sorry , I am bit confused are you willing to run a query of SQL from
Excel, Thant's needs a connection, Or you're trying to work in Excel as
same as you do in SQL by Getting Data as per your requirement from Sheet1
to Output sheet with the help of Macros/VBA Codes.
Regards,
Mandeep baluja
for negative
=IF(AND(J8:O8>0),"True","False")
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use c
Run this code and let me know
Regards,
Mandeep baluja
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Rownum As Long:
Dim colnum As Long:
Dim Temp As Long: Temp = 4
Dim lastentry As Long
With ActiveSheet
For colnum = 2 To 6
If colnum = 3 Or colnum = 6
Hi Paul, Thanks for you Good suggestions will apply the same in future, the
thing which i was looking to remove the InStr statements which is checking
multiply as you instructed combining the values first and adding it in
dictionary object to remove duplicacy(Given Below) will not combine the
>
> Check this attachment !! regards, Mandeep
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor
>
> Please follow the group rules, Post question related to Excel , Try this.
>
> http://www.labnol.org/internet/transfer-gmail/28088/
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join offic
1 - 100 of 454 matches
Mail list logo