date:20151223

Fwd: $$Excel-Macros$$ Need Help on attached sheet

2015-12-23 Thread Pankaj Sharma

Use this :


Sub Data_Formatting()

Dim rw As Long
For rw = 17 To ActiveSheet.UsedRange.Rows.Count Step 6
With Worksheets("Required").Range("B" & Rows.Count).End(xlUp)
.Offset(1, 0).Value = Range("D" & rw).Value
.Offset(1, 1).Value = Range("D" & rw).Offset(3).Value
.Offset(1, 2).Value = Range("F" & rw).Value
.Offset(1, 3).Value = Range("M" & rw).Value
.Offset(1, 4).Value = Range("O" & rw).Offset(3).Value
.Offset(1, 5).Value = Range("R" & rw).Value
.Offset(1, 6).Value = Range("T" & rw).Offset(3).Value
.Offset(1, 7).Value = Range("V" & rw).Value
.Offset(1, 8).Value = Range("Z" & rw).Offset(3).Value
.Offset(1, 9).Value = Range("AB" & rw).Value
.Offset(1, 10).Value = Range("AD" & rw).Offset(3).Value
.Offset(1, 11).Value = Range("AF" & rw).Value
.Offset(1, 12).Value = Range("AK" & rw).Offset(2).Value
.Offset(1, 13).Value = Range("AK" & rw).Value
End With
Next rw

End Sub




*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p ankaj123...@gmail.com *
*Skype**   pankaj.sharma_pj*




-- Forwarded message --
From: vikas khen 
Date: Thu, Dec 24, 2015 at 7:37 AM
Subject: $$Excel-Macros$$ Need Help on attached sheet
To: excel-macros@googlegroups.com


Dear Team,

Please find the attached excel sheet in which the raw data is sheet 1 and
the required output is in Sheet 2.

It would be very helpful if you help me on this.


Regards


-- 
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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


WeeklyBooking (Solved).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Need Help on attached sheet

2015-12-23 Thread vikas khen

Dear Team,

Please find the attached excel sheet in which the raw data is sheet 1 and
the required output is in Sheet 2.

It would be very helpful if you help me on this.


Regards

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


WeeklyBooking.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Excel sheet which shows folder name, the folder path of subfolder, the file name and file numbers

2015-12-23 Thread Katherine Loo

Hi Pawan, 

Thanks a lot for your help. My issue has been fixed.


On Wednesday, 23 December 2015 19:58:14 UTC+8, Pawan Yadav wrote:
>
>
> Hi Kath,
>
> Problem in For each loop, It starts with 1 row which has your header so 
> use this for loop code instead:
>
>
> For Each oFldr In oFolder.SubFolders
> iFolder = iFolder + 1
> Cells(iFolder + *1*, "A").Value = oFldr.Name
> Next oFldr
>
>
> Regards,
> Pawan
>
> On Wednesday, 23 December 2015 13:52:00 UTC+5:30, Katherine Loo wrote:
>>
>> Dear all,
>>
>> I would like to create an excel sheet which shows folder name, the folder 
>> path of subfolder, the file name in the subfolder and the updated revision 
>> numbers.
>>
>> I've written some codes and it can only shows the folder name and one of 
>> the folder name isn't appeared in the excel list. It would be highly 
>> appreciated if you could help.
>>
>> Thanks.
>>
>>
>>  
>>
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Get the Data from Web

2015-12-23 Thread Pawan Yadav

Hi All,

Is there any way to Grab the data from this website => 
http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm
 
using VBA code so that when ever I refresh the sheet it will automatically 
refresh according to website data. I use Data from web but it will not 
provide me any data :(

Thanks In Advance.

Regards,
Pawan 

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Remove all existing macros on certain date

2015-12-23 Thread Pravin Gunjal

Hi Expert,

Can i get a macro which can remove all existing macros from a file on certain 
date..

Kindly share the same. Thanks. 

Regards 
Pravin Gunjal 

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2015-12-23 Thread Pawan Yadav

You can also use this formula :

*=COUNTIF(D3:D22,"WO") *in Monday column and drag to right.

On Thursday, 10 December 2015 19:01:37 UTC+5:30, Sadiq wrote:
>
> Hello ,
>
> I need put Week OFF (WO) basis of attached excel (Day wise WO count) 
> (Excel attached with your reference.( if change day wise Week OFF count 
> then it should be automatically changed in Roster sheet. 
>
> Example- 
>
> We have 20 agents in a Shift and we need to give Weekly OFF to everyone 
> basis of attached sheet but WO should not be repeat more than one.
>
> *Sample- *
>
> Shift Timing-- 05:00-14:00
> Shift Count -- 20
>
> We can give Weekly OFF basis of Following days count.
>
> Monday-3
> Tue- 3
> Wed-2
> Thu-2
> Fri-2
> Sat-3
> Sun-5
>
>
>
>
> Regards
> Mohd Sadiq
> E-mail :- mohdsa...@gmail.com 
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Excel sheet which shows folder name, the folder path of subfolder, the file name and file numbers

2015-12-23 Thread Ashish Koul

try this
http://www.excelvbamacros.in/2012/05/file-and-folder-series-get-names-of-all_26.html

see if it helps

On Wed, Dec 23, 2015 at 1:51 PM, Katherine Loo 
wrote:

> Dear all,
>
> I would like to create an excel sheet which shows folder name, the folder
> path of subfolder, the file name in the subfolder and the updated revision
> numbers.
>
> I've written some codes and it can only shows the folder name and one of
> the folder name isn't appeared in the excel list. It would be highly
> appreciated if you could help.
>
> Thanks.
>
>
>
>
> --
> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on Facebook 
Join Us on Facebook 


P Before printing, think about the environment.

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Paragraph - Split Up - Excel

2015-12-23 Thread Pawan Yadav

Use this formulas:

=MID(F6,1,FIND(CHAR(10),F6))
=MID(F6,FIND(CHAR(10),F6)+2,FIND(CHAR(10),F6,FIND(CHAR(10),F6)+2))
=MID(F6,FIND(CHAR(10),F6,FIND(CHAR(10),F6)+2)+2,LEN(F6))

Regards,
Pawan

On Thursday, 17 December 2015 12:52:08 UTC+5:30, Veerappan Engineer wrote:
>
> Dear Experts,
>
> PFA the scenario like as Paragraph - Split Up - Excel.
>
> Please provide solution for that scenario
>
> Regards,
> Veera
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Excel lookup function

2015-12-23 Thread Pawan Yadav

Can you send the sample file for reference.


Regards,
Pawan

On Tuesday, 1 December 2015 20:53:42 UTC+5:30, Alan Walsh wrote:
>
> Hi All
>
> problem description. I have an excel sheet that i update manually. I want 
> to update automatically. 
>
> Here is what I have, A list of faults in a column, across each row is the 
> day and night shift, Monday to Friday.
> see below.
>
> Sheet 1
> Station Name Mon Day Mon Night Tue Day Tue Night Wed Day Wed Night Thur 
> Day Thur Night Friday Day Friday Night Station 18 (Vaccum) 276 363 231 146 
> 54 175 172 180 208 238  Station 12 Height Measure out of range 69 116 85 
> 107 48 60 52 59 96 74 
> I pull these faults every 12 hours from the database into an excel sheet. 
> i then manually update these.
>
> Sheet 2
>
>
>
>
>
>
>
>
>
>
>
> Reject counter for Zone 0, Station 18 
> (Vaccum)172
> Reject counter for Zone 0, Station 12 (CheckPresence)  
> 82
>
> I want to set up the lookup function in the first sheet, for each shift 
> and query the new data, I know this could be done in VB, but I am not that 
> well up on VB.
>
> even now when i run the lookup function i set my lookup value to  
> "*Station 18 (Vaccum)*" It did not work. the Astrix is for wild card yes? 
> any help on this would be deadly
>
> Alan
>
>
>
>
>
>
>
>
>
>
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Paragraph

2015-12-23 Thread Pawan Yadav

Use these formula :

1st Line formula :=MID(F6,FIND("Document 
Pg:",F6),FIND(CHAR(10),F6)-FIND("Document Pg:",F6))
2nd Line formula :   =MID(F6,FIND("Analysis 
Part:",F6),FIND(CHAR(10),F6,FIND(CHAR(10),F6)+2)-FIND("Analysis Part:",F6))
3rd Line formula :=MID(F6,FIND("Additional 
Function",F6),LEN(F6)-FIND("Additional Function",F6))


Regards,
Pawan
On Tuesday, 22 December 2015 13:28:23 UTC+5:30, Veerappan Engineer wrote:
>
> Dear Experts,
>
> Please find attached the Scenario.
>
> Thanks
> Veera 
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: help on find the list matches to the cell part value

2015-12-23 Thread Pawan Yadav

You can use this formula also:

*=IF(ISERROR(MATCH(MID(E2,FIND("/",E2)+1,LEN(E2))+0,$A:$A,0)),"No","Yes")*

Regards,
Pawan

On Tuesday, 22 December 2015 17:08:03 UTC+5:30, Ganesh N wrote:
>
> Dear team,
>
> I want to find the any of the given list of value matches (part) in the 
> particular cell using formula or macro.
>
> Please find the attached excel.
>
> If the solution in formula that would be great!!
>
> If you have any concern let me know.
>
> Thanks Team,
> Regards,
> Ganesh N
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: REPLACE

2015-12-23 Thread Pawan Yadav

Or you can use this:

=SUBSTITUTE(SUBSTITUTE(A2,TRIM(MID(A2,SEARCH("Inch",A2)+5,50)),""),"Emerald","Emerald

"&TRIM(MID(A2,SEARCH("Inch",A2)+5,50)))

On Wednesday, 23 December 2015 12:24:20 UTC+5:30, Vinod Kumar wrote:
>
> Dear Team,
>
> PFA required your help in replacing the content from last to med.
>
> Regards,
> Vinod
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Excel sheet which shows folder name, the folder path of subfolder, the file name and file numbers

2015-12-23 Thread Pawan Yadav

Hi Kath,

Problem in For each loop, It starts with 1 row which has your header so use 
this for loop code instead:

For Each oFldr In oFolder.SubFolders
iFolder = iFolder + 1
Cells(iFolder + *1*, "A").Value = oFldr.Name
Next oFldr

Regards,
Pawan

On Wednesday, 23 December 2015 13:52:00 UTC+5:30, Katherine Loo wrote:
>
> Dear all,
>
> I would like to create an excel sheet which shows folder name, the folder 
> path of subfolder, the file name in the subfolder and the updated revision 
> numbers.
>
> I've written some codes and it can only shows the folder name and one of 
> the folder name isn't appeared in the excel list. It would be highly 
> appreciated if you could help.
>
> Thanks.
>
>
>  
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: VLOOKUP Query

2015-12-23 Thread Pawan Yadav

Hi Shrini,

Use this formula instead => 
*=VLOOKUP(IFERROR(ABS(C2),C2),$H$7:$I$17,2,FALSE) *

Problem: ABS formula is not for Text value so it will return #Value
Solution: As you lookup value consist both number and text value, so if you 
want to use ABS formula than use the above formula.

If you still getting any issue then let me know :)

Regards,
Pawan 

On Monday, 30 November 2015 09:57:30 UTC+5:30, shrini wrote:
>
> Dear All
> I am using vlookup and facing following problem
> File attached
> thanks in advance
>
> -- 
> Shrini
>

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ VLOOKUP Query

2015-12-23 Thread Shrinivas Shevde

Dear Mandeep
Sorry for too delay reply .Actually I was on different project and now back
to the home.
Please find attached file.
Marked in yellow is not giving results as I am using Vlookup with ABS
function ,marked in brown gives results I am using Vlookup without ABS
function.
If I used the Vlookup without ABS then I am not getting results for
other.see the first row marked in grey.

Regards
Shrinivas

On Mon, Nov 30, 2015 at 9:57 AM, Shrinivas Shevde 
wrote:

> Dear All
> I am using vlookup and facing following problem
> File attached
> thanks in advance
>
> --
> Shrini
>
> --
> 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Shrini

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Vlookup.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Excel sheet which shows folder name, the folder path of subfolder, the file name and file numbers

2015-12-23 Thread Katherine Loo

Dear all,

I would like to create an excel sheet which shows folder name, the folder 
path of subfolder, the file name in the subfolder and the updated revision 
numbers.

I've written some codes and it can only shows the folder name and one of 
the folder name isn't appeared in the excel list. It would be highly 
appreciated if you could help.

Thanks.


 

-- 
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, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


get folder name to excel.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Fwd: $$Excel-Macros$$ Need Help on attached sheet

$$Excel-Macros$$ Need Help on attached sheet

$$Excel-Macros$$ Re: Excel sheet which shows folder name, the folder path of subfolder, the file name and file numbers

$$Excel-Macros$$ Get the Data from Web

$$Excel-Macros$$ Remove all existing macros on certain date

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

Re: $$Excel-Macros$$ Excel sheet which shows folder name, the folder path of subfolder, the file name and file numbers

$$Excel-Macros$$ Re: Paragraph - Split Up - Excel

$$Excel-Macros$$ Re: Excel lookup function

$$Excel-Macros$$ Re: Paragraph

$$Excel-Macros$$ Re: help on find the list matches to the cell part value

$$Excel-Macros$$ Re: REPLACE

$$Excel-Macros$$ Re: Excel sheet which shows folder name, the folder path of subfolder, the file name and file numbers

$$Excel-Macros$$ Re: VLOOKUP Query

Re: $$Excel-Macros$$ VLOOKUP Query

$$Excel-Macros$$ Excel sheet which shows folder name, the folder path of subfolder, the file name and file numbers

16 matches

Site Navigation

Mail list logo

Footer information