date:20170725

Re: $$Excel-Macros$$ Macro for Copy Paste

2017-07-25 Thread Shrinivas Shevde

 Can Anyone please help me?

On Mon, Jul 24, 2017 at 2:36 PM, Shrinivas Shevde 
wrote:

> Dear All
>
> I have a work book which contain many daywise sheet in which I maintain
> machinewise data.
> I have 20 machines all machines are not running daily so if machine is not
> running I hide that rows and machine running will be visible.
> There is down time for a machine having many reasons which are captured in
> different rows but the machine no and other in merge cell.
> Now I want to manke a single sheet where I will get all daywise data.
> See the attached file
> I tried it manually but it will take lot of time.
> Can Anyone will write macro.
> see "required output sheet"
>
>
>
> --
> 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.
>



-- 
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.

$$Excel-Macros$$ Looking for Senior Fullstack Java Developer Sterling, VA send resume- vik...@principlerpo.com

2017-07-25 Thread Vikas

Hi,

Hope you are doing well.!

We have urgent position Senior Fullstack Java Developer for location
Sterling, VA, please let me know your interest, and share me your updated
resume.



Position: Senior Fullstack Java Developer

Location: Sterling, VA

Terms :Contract,
Interview: Phone and face to face



   - 8 years of Full stack Java/j2EE development
   - MVC Framework
   - Oracle database- must be able to create new set of tables, design
   tables, and performance tuning
   - Spring Framework



Thanks & Regards



*Vikas *

*Principle RPO Group(PRG)*
1370 Broadway

5th Floor Suite # 553

New York, NY 10018
Phone: 312-361-8994 X 123

Fax : 646-349-2453

*Email*: vik...@principlerpo.com
*Website:  *www.Principlerpo.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.

$$Excel-Macros$$ Looking for QA Engineer - Philadelphia PA Send Resume at- vik...@principlerpo.com

2017-07-25 Thread Vikas

Hi,

Hope you are doing well.!

We have urgent position QA Engineer for location Philadelphia PA, please
let me know your interest, and share me your updated resume.



Position:QA Engineer

Location: Philadelphia PA

Terms :Contract,
Interview: Phone and face to face







Participate and analyze requirements during the requirements analysis phase
of projects.

• Develop and execute automated test scripts using Selenium with
C#, which will require programming in C#.Net and other scripting languages.

• Execute automated test suites and Analyze test results to
identify options for improving the effectiveness of automated testing using
MTM and on Azure.

• Develop custom Quality Assurance Metrics and reporting solutions
using C#, SQL, XML, html, CSS.

• Work in a multi-environment automation test execution platform.

• Assist in implementing and maintaining a Continuous Integration
Solution to integrate test suites into the test management system and
custom test harnesses.

• Create, coordinate, and execute manual application test cases and
test plan

• Review functional specs and user stories to design test
cases/scripts and test plans.

• Create and analyze test data.



Thanks & Regards



*Vikas *

*Principle RPO Group(PRG)*
1370 Broadway

5th Floor Suite # 553

New York, NY 10018
Phone: 312-361-8994 X 123

Fax : 646-349-2453

*Email*: vik...@principlerpo.com
*Website:  *www.Principlerpo.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.

$$Excel-Macros$$ Looking for DevOps Engineer - Philadelphia PA send resume - vik...@principlerpo.com

2017-07-25 Thread Vikas

Hi,

Hope you are doing well.!

We have urgent position DevOps Engineer for location Philadelphia PA,
please let me know your interest, and share me your updated resume.



Position: DevOps Engineer

Location: Philadelphia PA

Terms :Contract,
Interview: Phone and face to face



*Responsibilities:*

*Dev/Ops tooling – *

· Config Management - primarily Puppet (ansible, chef, etc. are
similar but we use Puppet so I’d really like someone with solid experience)

· Monitoring/Telemetry – Experience setting up and managing
monitoring and telemetry

o   Prometheus

o   Grafana

o   Sysdig

· Log Aggregation – experience using these tools, not worried about
set-up/administration

o   Splunk

o   ELK – Elasticsearch/Logstash/Kibana

· Linux System Administration – Need strong Linux background we use
RedHat/CentOS

· Kubernetes – huge “nice to have” – I think it will be hard to
find a lot of candidates with this but a BIG plus.  Looking for experience
using Kubernetes, not worried about administrative.

· Docker – Similar to Kubernetes – big plus

· Any experience with IP Video is obviously a huge bonus

o   MPEG-2, MPEG-4 MPEG DASH, HLS, HDS, …

·  Must haves are Linux, and Puppet and some of the other tools I
listed (or similar tools) – preference towards open source tools.

 *Softer-skills:*

·  Great communication – as we discussed, small team, lots of cross
functional work

· Hungry to learn – there will be no shortage of new topics, a true
hunger to learn can make up for a lot of gaps in the tech skills area

· Reverse engineering – need to have the mindset to reverse
engineer a problem; we move very fast and there’s not a lot of documentation

· Statistical thinking – they should be able to look at large
amounts of data and spot anomalies.  Also need to be able to identify what
data we would want to see in the first place

· Improvisation – Need to be a little creative with how they solve
a problem

· This individual will be in our on-call rotation, they go on-call
for 1 week and we rotate through the team – currently 3 members so they are
on call every 3rd week.







Thanks & Regards



*Vikas *

*Principle RPO Group(PRG)*
1370 Broadway

5th Floor Suite # 553

New York, NY 10018
Phone: 312-361-8994 X 123

Fax : 646-349-2453

*Email*: vik...@principlerpo.com
*Website:  *www.Principlerpo.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.

$$Excel-Macros$$ Re: Convert Excel to Web Based Application

2017-07-25 Thread torresmatthew84

Spreadsheetweb  can transform Excel 
spreadsheets into web applications. It comes with extras such as database 
integration, user management, and workflow support. 

Your data and formulas will be static to the end user. Every time you 
access the web application, you will be interacting with the 'original 
workbook' and not something people filled out. 

A web application created with Spreadsheetweb will allow users to enter 
data, which can then be exported in CSV format. You can also access the 
'form' user has created from the web interface. 

On Tuesday, May 9, 2017 at 5:31:33 AM UTC-4, Besi Bekas wrote:
>
> Hi, i need to convert my excel work to web application like i saw in 
> www.excelformat.com, anyone knows is there free tools to convert my excel 
> to web application? Please informs Thank you

-- 
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$$ Help on Week Formula

2017-07-25 Thread Paul Schreiner

I think you'll need to be more specific on how you want the "weeks" 
calculated.For instance, in August (2017) August 1 is on  a Tuesday.
so, the weeks are handled:

but, July 1 is on a Saturday,so, does Week 1 only have a single day?
Or is July 1 counted as part of week 5 of June.If so, what is the minimum 
number of days counted in a week 1?
Or are you wanting a simple count of days:Week 1 = first 7 daysWeek 2 = Second 
7 daysetc.
 Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
- 

On Tuesday, July 25, 2017 3:34 AM, Chandra Shekar 
 wrote:
 

 Hello Team,
Could you please help me in attached week formula.
Regards,
Chandru-- 
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.

Re: $$Excel-Macros$$ Change Cell based on Selection of Other cell

2017-07-25 Thread Vijayendra Rao

Hi,

I got answer in VBA. Attached is the updated file.

Regards,
Vijayendra

2017-07-23 6:00 GMT+05:30 who :

> Unless the IF() statement has changed, it only allows 7 nested ifs, which
> is not sufficient to do this with out the use of VBA. Thanks, David
>
>
> On Monday, July 10, 2017 at 4:59:17 AM UTC-7, Vijayendra wrote:
>>
>> Hi Experts,
>>
>>
>> Request you to help to resolve this below query.
>>
>> Need to change the cell based on selection of other cell. Attached is the
>> sample file, in this file Column E3 should contains based on the active
>> cell selected between A2:A14. Is it possible to do with any functions /
>> macros.
>>
>>
>> Regards,
>> Vijayendra
>>
>> --
> 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.


Selected Cell - Values.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Find out the value of the cell based on row and column

2017-07-25 Thread Vijayendra Rao

Hi Paul,

Thanks for your support. I tried Indirect function and it did not work. I
have used macros which is working perfect. Attached is updated file.

Regards,
Vijayendra


2017-07-21 21:12 GMT+05:30 Paul Schreiner :

> use:
> =INDIRECT(E3)
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Friday, July 21, 2017 6:53 AM, Vijayendra Rao 
> wrote:
>
>
> Hi Experts,
>
> I have cell value called $A$5 (Will change based on selection of active
> cell) and need to get the suitable function which should reflect the
> value of the $A$5 (will change). Attached is the excel file, request you
> to help on the same.
>
> Regards,
> Vijayendra
>
> --
> 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.
>



--

-- 
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.


Selected Cell - Values.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Help on Week Formula

2017-07-25 Thread Aindril De

Please use the following formula in the cell C2
="WK"((DAY(A2)+6)/7)

And drag down to copy the formula.
Cheers!!
Aindril

On Tue, Jul 25, 2017 at 1:03 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hello Team,
>
> Could you please help me in attached week formula.
>
> Regards,
>
> Chandru
>
> --
> 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.
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

-- 
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$$ Help on Week Formula

2017-07-25 Thread Chandra Shekar

Hello Team,

Could you please help me in attached week formula.

Regards,

Chandru

-- 
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.


Week_Formula.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Macro for Copy Paste

$$Excel-Macros$$ Looking for Senior Fullstack Java Developer Sterling, VA send resume- vik...@principlerpo.com

$$Excel-Macros$$ Looking for QA Engineer - Philadelphia PA Send Resume at- vik...@principlerpo.com

$$Excel-Macros$$ Looking for DevOps Engineer - Philadelphia PA send resume - vik...@principlerpo.com

$$Excel-Macros$$ Re: Convert Excel to Web Based Application

Re: $$Excel-Macros$$ Help on Week Formula

Re: $$Excel-Macros$$ Change Cell based on Selection of Other cell

Re: $$Excel-Macros$$ Find out the value of the cell based on row and column

Re: $$Excel-Macros$$ Help on Week Formula

$$Excel-Macros$$ Help on Week Formula

10 matches

Site Navigation

Mail list logo

Footer information