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
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
see if it helps
On Mon, Aug 29, 2011 at 12:30 PM, anil kumar kmr7a...@gmail.com 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
--
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 Fri, Aug 26, 2011 at 7:37 PM, GreenBriar impedimenta.st...@gmail.comwrote:
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
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
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
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
Dear Cab,
Attachment Missing.
On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose swch...@gmail.com 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
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
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
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
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 dari...@gmail.com wrote:
Hi,
I have a macro that should open Access 2007 database in .accdb format.
Code works with .mdb format but with .accdb it
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
Thank you for quick responses :)
On 29 Sie, 10:40, Rajan_Verma rajanverma1...@gmail.com 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,
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:
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:
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
--
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
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,
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 rajanverma1...@gmail.comwrote:
*Hi ANANATA,*
*How will your ledger Look? Please provide sample sheet.*
* *
*From:*
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 kmr7a...@gmail.com wrote:
Dear all,
I am attach. file in this file has some add. and some add. are is double,
triple, so when i
By Collaborating Macros , Filter and or Pivots
On Mon, Aug 29, 2011 at 3:27 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Hi ANANATA,*
*How will your ledger Look? Please provide sample sheet.*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf
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
noorain.ans...@gmail.comwrote:
Dear Sajid,
As per your requirement Please try blow VBA code to
- Original message
From:Tritium sw...@tritiumindia.com
Date: 27 Aug 11 10:47:20
Subject: Openings for SQL DBA
To: venkatesa...@in.com
The sender of this email is registered with Naukri.com as Tritium
Experience required for the Job: 4 - 8 yearsAnnual Salary of the Job:
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)
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 =
On Aug 29, 3:36 pm, Chandra Shekar chandrashekarb@gmail.com
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
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
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
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)
amit.de...@merucabs.comwrote:
Dear Friends,
then ..press Alt + D +P +B and select new range ...
On Mon, Aug 29, 2011 at 2:59 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
That’s true… but what if I wants to refresh the Pivot table with new
data?
** **
Best Regards,
Amit Desai
** **
** **
*From:*
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
Thanks Daniel.
It really works.
Regards,
C.G.Kumar
On Sat, Aug 27, 2011 at 3:26 PM, Daniel dcolarde...@free.fr wrote:
Hello,
** **
See attached workbook.
** **
Daniel
** **
*De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
*De la part de*
34 matches
Mail list logo