Hi Noorain
On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI wrote:
> Dear Cab,
>
> Question -1, you can use attached Add in to Compare two worksheets..
> Question -2, You can group both sheets to same entry on same time.
>
> Press ctrl+shift+Pg down..
> Thanks for your reply and attachment.
Thank u very much got the solution.
Please let me know is there any other way to do this.
Thanks,
Chandra Shekar B
On Mon, Aug 29, 2011 at 5:49 PM, lifescholar wrote:
> On Aug 29, 3:36 pm, Chandra Shekar
> wrote:
> > Hello,
> >
> > Could you please let me know whats the error in using sumprod
Thanks Daniel.
It really works.
Regards,
C.G.Kumar
On Sat, Aug 27, 2011 at 3:26 PM, Daniel wrote:
> Hello,
>
> ** **
>
> See attached workbook.
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* C.G.Kum
Hi once again
This is totally new subject. I have model railroads. I would like to
control from Excel.(there are some other software available but I would
like to use Excel)
I want to send from Excel to a bus wire digital information showing the loco
number and direction of travel (fwd/re
then ..press Alt + D +P +B and select new range ...
On Mon, Aug 29, 2011 at 2:59 PM, Amit Desai (MERU)
wrote:
> That’s true… but what if I wants to refresh the Pivot table with new
> data?
>
> ** **
>
> Best Regards,
>
> Amit Desai
>
> ** **
>
> ** **
>
> *From:* excel-macros
Hey Amit,
use find and replace option "find value =" and "replace value
'="... and after past sheet again use find and replace
function now new "find value '=" and "replace value ="
On Mon, Aug 29, 2011 at 1:08 PM, Amit Desai (MERU)
wrote:
> Dear Friends,
>
> ** **
>
> Sinc
Hey Anil,
this post sent by mr.Bob
If you want to import a text file into Excel and have that data be in
multiple columns once it's in Excel, it must be either fixed width or
delimited. Fixed-width means that new columns occur at the same place on
every line. That's not very useful for most info
Hi
I would like to select an already named range and using a command button
convert it to dynamic named range by columns and rows.
Is this possible ? It would be a lot quicker than doing it manually each
time. I failed to make a lot dynamic when I set them up.
Appreciate your help, I am age
On Aug 29, 3:36 pm, Chandra Shekar
wrote:
> Hello,
>
> Could you please let me know whats the error in using sumproduct function in
> below code. I am getting error number 2015
>
> Is there any other way to use sumproduct function using vba with multiple
> condtions.
>
> Thanks in advance.
>
> Sub
Hello,
Could you please let me know whats the error in using sumproduct function in
below code. I am getting error number 2015
Is there any other way to use sumproduct function using vba with multiple
condtions.
Thanks in advance.
Sub ABNAMROAdd()
Dim compnm As String
lastcl = ThisWorkbook.Work
Dear KBJ,
W/S...
That converter is working fine on my system..
press alt+F11 and Paste it code in Module and Press F5.
I hope it will work fine..
Sub exltopdf_converter()
Dim wrknm As String
wrknm = ActiveWorkbook.Name
wrknm = Left(wrknm, InStr(1, wrknm, ".") - 1)
ActiveWorkbook.ExportAsFix
>
>
> - Original message
> From:""Tritium""< sw...@tritiumindia.com >
> Date: 27 Aug 11 10:47:20
> Subject: Openings for SQL DBA
> To:
>
> The sender of this email is registered with Naukri.com as Tritium
> Experience required for the Job: 4 - 8 yearsAnnual Salary of the Job: 0.0
dear Noorain Ansari (Assalamulaikum)
as per your tryit.xls its not working. plz give me detail.
with advance Happy Eid Mubarak to all.
sajid memon
On Sat, Aug 27, 2011 at 10:14 PM, NOORAIN ANSARI
wrote:
> Dear Sajid,
>
> As per your requirement Please try blow VBA code to Convert Excel file in
>
By Collaborating Macros , Filter and or Pivots
On Mon, Aug 29, 2011 at 3:27 PM, Rajan_Verma wrote:
> *Hi ANANATA,*
>
> *How will your ledger Look? Please provide sample sheet.*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ananta Sapko
Dear Anil,
Use Alt+A Q for Advance filter..
Choose *Filter the list-List range-Criteria range-Unique Records only
*
On Mon, Aug 29, 2011 at 3:06 PM, anil kumar wrote:
> Dear all,
>
>
> I am attach. file in this file has some add. and some add. are is double,
> triple, so when i use short key
Thanking you for response. I have attached the sample worksheet. Please find
the attachment. I hope for positive solution.
On Mon, Aug 29, 2011 at 3:42 PM, Rajan_Verma wrote:
> *Hi ANANATA,*
>
> *How will your ledger Look? Please provide sample sheet.*
>
> * *
>
> *From:* excel-macros@googlegrou
Dear Expert,
One last thing to remind that Color bar should increase or decrease when
duration is changed. Please help in this matter with Excel logical formulas
& conditional formatting, only. Try to avoid VBA, if possible. Thanks
Regards,
Zafar Iqbal
On Mon, Aug 29, 201
Hi ANANATA,
How will your ledger Look? Please provide sample sheet.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ananta Sapkota
Sent: Monday, August 29, 2011 3:09 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Dynamic Ledger
Hi Eve
Hi Everyone
I want to make dynamic ledger in excel with control button. Moreover I want
to add new party from by clicking new button. In this projects accounting
ledger are worksheets and they must be dynamic.
ananta
--
--
That's true... but what if I wants to refresh the Pivot table with new data?
Best Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Rajan_Verma
Sent: Monday, August 29, 2011 2:02 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-
There was a Spelling Mistake use this :
MicroSoft.ACE.OLEDB.12.0 instead of MicroSoft.Jet.OLEDB.4.0
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of oryn
Sent: Monday, August 29, 2011 2:16 PM
To: MS EXCEL AND VBA MACROS
Subject: Re:
Thank you for quick responses :)
On 29 Sie, 10:40, "Rajan_Verma" wrote:
> Use ACE.OLDEB.12.0 instead of Jet.OleDB.4.0
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of oryn
> Sent: Monday, August 29, 2011 1:45 PM
> To
Use ACE.OLDEB.12.0 instead of Jet.OleDB.4.0
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of oryn
Sent: Monday, August 29, 2011 1:45 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ how to connect with accdb database from
Dear Dario,
See below link..
http://akoul.blogspot.com/search/label/Update%20Access%20Table%20from%20Excel
On Mon, Aug 29, 2011 at 1:45 PM, oryn wrote:
> Hi,
> I have a macro that should open Access 2007 database in .accdb format.
> Code works with .mdb format but with .accdb it doesn't. It ret
Hi,
I have a macro that should open Access 2007 database in .accdb format.
Code works with .mdb format but with .accdb it doesn't. It returns
message that programme is unable to open database (I checked it with
several databases in .accdb format). Does anybody have a solution?
Sub Pokarz_form_list
Pivot table has a cache Memory which holds all the data of Data Table if
data table is removed , Pivot table can not be refreshed. but you can get
all data from Pivot table, it means Data Stored in Pivot table will not
effect if Data Table is Removed ..
From: excel-macros@googlegroups.com [mai
Dear All,
We need MIS executive having very good knowledge of Advance Excel. Forward your
CV on my official ID. Girls are welcome too.
Role:
MIS Executive
JD:
1) To collect/extract the data from the various parties/system,
2) To prepare daily/weekly/monthly MIS,
3) To provide analysis
Dear rajan,
I verey thankfull to you. It work
Thakns
Anil
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Linked
Dear Cab,
Attachment Missing.
On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose wrote:
> Hi
> I have in attached workbook:
> Has two worksheets- 'ByGroups' and 'ByAssly"
> The two sheets should be the same, however they are in different order.
> First Question: Which is the best way to find the di
Hi
I have in attached workbook:
Has two worksheets- 'ByGroups' and 'ByAssly"
The two sheets should be the same, however they are in different order.
First Question: Which is the best way to find the differences between the
two sheets as at the moment so that corrections can be made. Have search
Dear Friend,
I am preparing an MIS however to compare the result of MIS I am also preparing
few Pivot table.
I want to keep the Pivot table & selected field intact even if the sheet in the
data table is removed. Is that possible?
Best Regards,
Amit Desai
Dis
Dear Friends,
Since the performance of excel was slow... & I have more than 1000 formula..
I have opted for following
1) Kept the formula only in first line & in following line made all cells
to value,
2) The formulas in 4 sheets were linked to "sheet1". Sheet1 was every time
refre
See if it helps
On Fri, Aug 26, 2011 at 7:37 PM, GreenBriar wrote:
> I have a column that has the data formatted like this: (This is a
> different column than previous post)
>
> Smith, John M
> Smith, Alex
> Jones, Mary
> Jackson Harris, Greg P
> Diaz-Garcia, Brenda Maria T
>
> etc
>
> I want it
Try this :
Sub Transpose()
On Error Resume Next
Dim scrrng As Range
Dim optrng As Range
Dim cell As Range
Dim k As Integer
k = 0
r = 0
Set scrrng = Application.InputBox("Please select Source Range", , , , ,
, , 8)
Set optrng = Application.InputBox("Please select Output Range (A
see if it helps
On Mon, Aug 29, 2011 at 12:30 PM, anil kumar wrote:
> Dear all,
>
>
> I am attach. a file in this file some add. and i want to change all add.
> in single column. I have given exp. in this sheet.
>
>
>
>
> Thanks & Regards
> Anil
>
> --
>
> -
Anil,
use this formula.
{=TRANSPOSE(A4:A6)}
--
--
One Team One Dream One Goal
Warm Regards,
Brajesh Kumar Porwal
"We can't Spell S_ccess without U"
Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.
On Mon, Aug 29, 2011 at 12:30 PM, anil kumar wr
Dear all,
I am attach. a file in this file some add. and i want to change all add.
in single column. I have given exp. in this sheet.
Thanks & Regards
Anil
--
--
Some important links for excel users:
1. Follow
37 matches
Mail list logo