On Thu, Jan 27, 2011 at 11:37 AM, ashish koul koul.ash...@gmail.com wrote:
Sub consolidatefromdifferentworkbooks()
Application.DisplayAlerts = False
'On Error GoTo abc
Dim ask As Workbook
Dim ask2 As Workbook
Dim ASK3 As Workbook
Set ASK3 = ActiveWorkbook
Dim i As Long
Dim j As Long
Hi Ashish,
I can't thank you enough for this great solution:)
I'd hate to be a pain in the neck but I do have a couple of questions
more.
Would it be possible to specify only one sheet to be merged? My
workbooks contain several, but only one is relevant for the database.
And, if I run this macro
Hello Expert,
In Attached Sheet i am making a tracker For Attrition In first summary sheet
i have to show Band with Colour corresponding to his Last Dated Status.
Please help me to get that Result on Summary sheet through formula .
Thanks,
CS
--
Hi CS,
If you want to color the band. You can Conditional Formatting to get the
result.
Regards
Umesh
On Thu, Jan 27, 2011 at 3:04 PM, Born to Win cs4...@gmail.com wrote:
Hello Expert,
In Attached Sheet i am making a tracker For Attrition In first summary
sheet i have to show Band with
hi
try this code if the sheets postion or names are fixed from which data is to
be merged in all workbooks
then simply change below yellow marked line currenty it will copy on sheet
1 from all the workbooks.
2nd - once you get all the file names to be merged you can manually delete
that row,
Hi
Find the attachment.
Thanks Regards
Thamu
On Thu, Jan 27, 2011 at 3:04 PM, Born to Win cs4...@gmail.com wrote:
Hello Expert,
In Attached Sheet i am making a tracker For Attrition In first summary
sheet i have to show Band with Colour corresponding to his Last Dated
Status.
Please
Dear Ankur Pandey
You cannot able to keep it in a single row If you have large amount of data.
Because Excel 2003 has only 256 columns and excel 2007 has only 16384
columns.
Thanks Regards
Thamu
On Thu, Jan 27, 2011 at 2:55 PM, ankur ankurpande...@gmail.com wrote:
hi excel experts
i need
Dear Jitendra,
Simply palce the cursor in any other worksheet.
for example if you want to count the number of nonblank cells in sheet1,
just place the cursor anywhere in sheet2 and =COUNTA(Sheet1!1:65536)
Thanks Regards
Thamu
On Wed, Jan 26, 2011 at 11:43 PM, Dilip Pandey
Dear Amir,
IFERROR will not work in excel 2003. Try this one
=IF(ISNA(IF(ISNA(VLOOKUP(B6,$E$3:$F$3,2,0)),VLOOKUP(B6,$H$3:$I$3,2,0),VLOOKUP(B6,$E$3:$F$3,2,0))),VLOOKUP(B6,$K$3:$L$3,2,0),)
type the above formula anywhere in worksheet. cel (b6) is taken as lookup
value.
Thanks Regards
Thamu
On
Hi,
I just checked your file. You need to do a few modifications to your
pivot.
1) Click on pivot table. Select Options and make Field List visible.
It's the option on top right in Option tab. Remove Insurance , Claims
and Reinsurance for Colum Labels.
2) Drag insurance in the sum Values area
first of all, it needs to be a TRUE Excel DATE,
not just a string of characters that LOOK like a date.
To determine this, try changing the format to General.
If it is a date, it will convert to a number.
That's because to Excel, a date is really the number of
days since 1/1/1900.
So today,
We have a stacked bar graph that displays 26 4-week periods spanning
two years. The requesting department would like to differentiate the
colors on the bars for the past year from the colors on the bars for
the current year.
This is using Excel 2003. When I try to edit the colors for the graph
Hi Ashish,
Life and death matter, I have a workbook and again it has diff sheets like
sheet 1 to sheet 11. and now my task is to copy unique names from sheet 1
search in other sheets if it is existing then I need to copy only those row
from the diff sheets and create a fresh new workbook and
use 2 for second sheet or 3 for 3 rd sheet like
sheets(2).select or you can also sheets(abc).select
Workbooks.Open Filename:=Sheets(1).Range(a i).Value
Set ask2 = ActiveWorkbook
Sheets(1).Select
@shannur can you send a sample workbook
On Thu, Jan 27, 2011 at 9:04 PM, shannu shannu
shannur can you attch the sample workbook
On Thu, Jan 27, 2011 at 9:13 PM, ashish koul koul.ash...@gmail.com wrote:
use 2 for second sheet or 3 for 3 rd sheet like
sheets(2).select or you can also sheets(abc).select
Workbooks.Open Filename:=Sheets(1).Range(a i).Value
Set ask2 =
put sheetnames always in double quotes Sheets(PRIPRAVA_PROJEKTA).
On Thu, Jan 27, 2011 at 9:23 PM, Seba sebastjan.hri...@gmail.com wrote:
Hi,
I made the following change for sheet name and I get the error
Subscript out of range. Sheets(1) - Sheets(PRIPRAVA_PROJEKTA)
Sub
Sub consolidatefromdifferentworkbooks()
Application.DisplayAlerts = False
'On Error GoTo abc
Dim ask As Workbook
Dim ask2 As Workbook
Dim ASK3 As Workbook
Set ASK3 = ActiveWorkbook
Dim i As Long
Dim j As Long
Dim N, z, r, s, k As Long
s = 1
k = 1
Dim x As String
Dim temp As String
I have to count the number of claims based on status codes, but also,
group the counts based on whether the eff date and pymt dates match or
don't match and whether they have a pymt or notSo, the counts
would be listed by status, then broken out by 4 columns (dates match w/
pymt), (dates don't
What version of Excel are you using (Excel 2007 has some additional options)
Are you hoping for a Excel Function solution or a VBA solution?
Paul
From: Ahleah1031 jeannie.car...@chase.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Thu,
Hello Ashish
This file is amazing. Just as I had hoped for. Never ceases to amaze me
about the power of excel in the hands of people with expert minds like
yours.. :-) :-)
Am adding some more stuff to the file. Hope to get it done with as less
help as possible.
Thanks once again for the
Can you post the file? It will help us a lot!
--
Best Regards!
Prakash Singh Gusain
*Please visit my blog (**click here http://prakashgusain.blogspot.com/**)*
--
--
Some important links for excel users:
1. Follow
Hi Umesh,
I am working on data containing Authorized signatory list and wanted this
data on excel.
I have all data in pdf version and need to get this on excel.
In order to get this done I need your help to get vba coding for the
converting pdf data to excel data.
Kindly confirm if
I'm using Excel 2007 and would use EITHER excel function or VBA! :o)
On Jan 27, 11:55 am, Paul Schreiner schreiner_p...@att.net wrote:
What version of Excel are you using (Excel 2007 has some additional options)
Are you hoping for a Excel Function solution or a VBA solution?
Paul
I am amazed at what you have accomplished very simply but I do not
understand where you are storing the information in the Combobox1 and
combobox2 for the drop down selection process
Please help - I really think I would benefit in my programming by
utilising Userforms but I have always shied away
Friends - any body have *Microsoft excel professional plus 2010 key*,
version is *14.0.4734.1000 (32 bit)* please share
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
this will count everything even no. which are used for rough work.
lets us know what exactly u want by sending ur workbook.
a = WorksheetFunction.CountA(Sheet1.UsedRange)
From: Jitendra Verma jitendra.kumarve...@gmail.com
To: excel-macros@googlegroups.com
From your email client just send an email to
excel-macros@googlegroups.comwith the same subject line mentioned in
this mail.
We all will receive it in the group!
Best Regards!
Prakash Singh Gusain
*Please visit my blog (**click here http://prakashgusain.blogspot.com/**)*
On Thu, Jan 27, 2011
Hello Experts,
I have a file which has 11 tabs. The 10 have same template with first
row being the heading. The 11th sheet is suppose to be used as a
summary report sheet that pulls data from the first 10 sheets based on
the following criteria:
List all rows if business priority 1 or 2 (column
this macro is adding the data to combo box before you make form visible
if you check sheet1 cell d23 , d24, etc or a23, a24 its having values these
values are added to combobox1
Sub OpenDetails()
Dim i As Long
For i = 23 To Sheets(1).Range(d23).End(xlDown).Row
With OrderForm.ComboBox1
hi SK
attach one sample file for clear understanding
On Fri, Jan 28, 2011 at 4:30 AM, SK shivakashy...@gmail.com wrote:
Hello Experts,
I have a file which has 11 tabs. The 10 have same template with first
row being the heading. The 11th sheet is suppose to be used as a
summary report sheet
please send us a sample file...
Regards,
Manoj Kumar
On Fri, Jan 28, 2011 at 4:30 AM, SK shivakashy...@gmail.com wrote:
Hello Experts,
I have a file which has 11 tabs. The 10 have same template with first
row being the heading. The 11th sheet is suppose to be used as a
summary report
Dear All,
Good morning!
I want to do subtotal on quarterly basis in the attached excel sheet. Could
you please help me out on this? Is there any formula to do subtotal/total on
quarterly basis
Pls. see attached file.
Thanks regards,
Usha
--
Hello Hanumant
Thanks a lot for your efforts. As always, this group has once again
helped me to quickly solve my problems within the shortest possible time.
Yes, I agree that many data validations are yet to be done. However,
ideas are bouncing off me as I progress. Hopefully, ideas at a
Hi Usha,
check the attached file, see if this helps u out...
Regards,
Manoj Kumar
On Fri, Jan 28, 2011 at 10:35 AM, Usha Negi ushadhvin...@gmail.com wrote:
Dear All,
Good morning!
I want to do subtotal on quarterly basis in the attached excel sheet. Could
you please help me out on this?
34 matches
Mail list logo