Hi,
I have data in workbook with 4 worksheets i want to copy those data into new workbook with 2 worksheets( SF & EE) only this workbook save in desktop with current month name & year. can some one help how to create vba code for this
Hi
Now I have mention expected result as well in this file.
Where is Add details mention in Column E then check range if any non blank cell if found any value then check above cell if any data or not if data found then this consider as in correct format & Below cell data is any value found...
Hi
I have multiple file in one folder all files format is fix like sheet names and Template format.
I want to check Sheet 1 Data IF Add details word match in range E14:E100 this case is match.
Then Check Same Row from Column F to AJ Non Blank Cell If find non Blank cell then is any value in...
We tried with this on our macro but it is not work so please give idea for this
Set ieDoc = IE.Document
Set ieCom = IE.Document.all
kRow = 0
kCol = 1
For k = 1 To ieDoc.all.Length - 1
If TypeName(ieDoc.all(k)) = "HTMLTable" Then...
Hi
If Comments is NO on web page then corresponding checkbox will be clicked or selected.
For Yes comments checkbox won’t be clicked.
After Selecting all the checkbox with “No” comments on webpage, Delete button will be clicked
I want this through be done via Excel VBA please help on this...
Hi
I tried with this its work but apart from any method & how to highlight more than 1 same criteria
Please tell me
=IF(SUMIFS($D$3:$D$14,$B$3:$B$14,$G10,$C$3:$C$14,H$2)=0,"",SUMIFS($D$3:$D$14,$B$3:$B$14,$G10,$C$3:$C$14,H$2))
Hi
I have data in that match multiple criteria i.e Assignment & Element if both match then give Units i have tried with vlookup but if more than 1 same value then this will not work in that case i want to highlight that Assignment number & add up that Units
please tell me how to do this
This one formula i tried but in this how to minus 2 from last 3 numbers can you please tell me
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,".",""),"(","_"),"^","_"),"+"," ")
i do not have code with me now so i can not share that and my question is when 3.58E+156 this type of value how to convert like after + sign number 156 minus 2 then 154 comes then original value 358E154
Ok that macro part i will check but if any method like this to replace "." then "+" and after + sign number -2 from that value means from this value 3.58E+156 358E154 my original value come
Please tell me how to do this
Sub ChgInfo()
Dim WS As Worksheet
Dim Search...
Macro part from MS access data base this macro pull data from table so i am not aware where i need to change in code because in that macro SQL method is also use so i am not sure
i tried with this method format text but when macro copy paste data then this values are converted so please tell me how to this type value converted into original value
Hi
I have data in excel when 358E154 this data enter into cell then this convert like this 3.58E+156 can any one tell how to avoid this or if this type of value how to convert again into like this 358E154 please tell me
No Veltm say vlookup work in my file so i ask where show me then he post then i ask upload with my file data then no one upload that but telling no vlookup is work then u told me lookup table is not sorted then i both of pic then u told me no we are saying u need to sort the data where i post...
Ok when you are telling me vlookup work without sorting array table then please upload file with formula so i know what is wrong when i used vlookup
This Formula work in this type
=INDEX(Reference!C$2:C$11,MATCH(H2,Reference!B$2:B$11,-1))
Please upload file with vlookup without sort array table