I tried taking a look at it, but there were too many questions to address in the time I had available.I can try to describe SOME of questions. Keep in mind that YOU know what you're attempting to do, YOU know what the data means and YOU know what you want your report to look like.WE can only spend time guessing, only to have you disappointed and seeking a revision.Another point is, most of the people you're seeking help from are not in the same business that you are.So, terms that are commonplace to you, may not have the same meaning for others. I've never done "bookings".I don't know what is involved or what kind of reports are required. So, you said:Right now am working in on report in which I have to count the a particular date in multiple sheets & am doing it by using the function - Countifs and the i have to write a long formula for it. Another one issue is to extract total amount of bookings in current week in multiple sheets.
So, it SOUNDS like you are trying to do two things:1) Count the occurrences of
a particular date on multiple sheets2) total the amount of "bookings" in the
"current week" from the sheets.
In your sample file, you have two sheets which have some data, which I "assume"
are what you are calling "bookings".You also have a sheet called
"Consolidated", which seems to be where you've specified a date, and used the
countif() function to count the presence of the date in the other two sheets.
How many sheets will you have in the final report?If you're just dealing with
12 (one for each month of a year)I'd be inclined to stay with using countif()
and sumif() functions.
What day of the week does your "current week" start on?The first entry in the
"Dec 13" sheet is for July 16, 2013. This was a Tuesday.so, are you looking
for total entries from Monday, July 15 to Sunday, July 21?
As I said, if your situation is that you'll only have 12 sheets in the
workbook,I'd consider simply creating a matrix of sheets and total them
individually.
Like the attached.You only need to add the sheet names to row 2 and copy the
formulae in rows 3 and 4.If you need a total, then simply add them.
If I've totally missed your point, I'm sorry.
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 Thursday, June 16, 2016 1:04 AM, Devendra Sahay
<devendrasahanypt...@gmail.com> wrote:
Hi Guys,
Please revert.
On Wed, Jun 15, 2016 at 11:10 PM, Devendra Sahay
<devendrasahanypt...@gmail.com> wrote:
Hi Guys,
Right now am working in on report in which I have to count the a particular
date in multiple sheets & am doing it by using the function - Countifs and the
i have to write a long formula for it.
Another one issue is to extract total amount of bookings in current week in
multiple sheets.
So If we can do it with help of macro or function then please help. Am sharing
sample file for the ref.
--
Thanks,Devendra
--
With Regard !!!Devendra Rahi
--
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.
FY Schedule(pms).xlsx
Description: MS-Excel 2007 spreadsheet
