Hi
The above file will be used by two person - User and the Administrator,
administrator can edit anywhere, while the user can edit only in the range
specified, based on this I have done something in the file attached but
would help you guys to pls help. Please find attached the excel file.
1. Fo
Hi Mathan,
I used column A to determine the number of rows that should be
included in the
pivottable range. And I used Row 1 to determine the number of columns.
I assume that the headers are all nicely valid--no duplicates and no
blanks,
right. And that you want Sum for each of those other fields
Dear Friends,
Please help
On Tue, Dec 8, 2009 at 4:53 PM, Mahesh wrote:
> Hi All,
>
> Please help on this issue
>
> On Mon, Dec 7, 2009 at 9:36 AM, Mahesh wrote:
>
>> Hi Bruce,
>>
>> Thanks for the help.
>>
>> But i need something diff.
>>
>> Attached is the xls with the links.
Hi All,
I have created a Tool using Excel , Access & VBA. My both Excel GUI file &
Access database is in the same folder. I want that user should not be able
to open this Access Database. I need help in VBA part how to open a Access
password protected database in excel. I am using ADO for database
Thanx Andy .
On Wed, Dec 9, 2009 at 9:15 PM, Aindril De wrote:
> Hi Bharghav,
>
> Try this in any cell other than A1,
> Suppose A1 contains the text Data for abc 07
>
> =MID(A1,FIND(" ",A1,(FIND(" ",A1,1)+1))+1,(FIND(" ",A1,FIND(" ",A1,(FIND("
> ",A1,1)+1))+1)-FIND(" ",A1,(FIND(" ",A1,1)+1))-1))
Hi Bharghav,
Try this in any cell other than A1,
Suppose A1 contains the text Data for abc 07
=MID(A1,FIND(" ",A1,(FIND(" ",A1,1)+1))+1,(FIND(" ",A1,FIND(" ",A1,(FIND("
",A1,1)+1))+1)-FIND(" ",A1,(FIND(" ",A1,1)+1))-1))
Regards,
Andy
On Wed, Dec 9, 2009 at 7:26 PM, bharghav r wrote:
> All,
>
>
All,
I am looking at a function which can search for the 3rd word(substring) in a
string.
Example:
Data for abc 07 => abc
Data for fgdg 09=>fgdg
--
Thanks and Regards
Bharghav R
--
--
Some important l
OK.. I tested the use of the hlookup
(I'm usually using vlookup, so I don't have much practice)
I put the column numbers in row 16.
This formula finds the maximum value in the row and returns the
column number from row 16.
=HLOOKUP(MAX(B1:K1),B1:$K$16,ROWS(B1:$K$16),FALSE)
if you want the result t
Are you SURE you want a macro?
the =max function could return the maximum value in the row.
I'll have to test it, but the =hlookup function
should be able to return the column heading.
if you want the column NUMBER, then you could put the
numbers in the first row of the matrix...
if you want a mac
If you're wanting to REPORT from Access...
it's fairly simple!
You just need to define an external data source.
Excel lets you define the tables and join conditions
that you need and the fields you want to retrieve.
it then inserts the data in a sheet.
the nice thing is that you can "refresh" the
Define: "Many" (approximately)
Because: To ME, "many" in this context is > 250
while to some, the thought of calling up each file
and saving it as a csv or txt file for more than
50 is "many".
I once had to open and add a confidentiality "stamp"
to 2500 images.
I had to do it manually, because
Hi,
Please find the below code for reference:
Sub ADOFromExcelToAccess()
' exports data from the active worksheet to a table in an Access database
' this procedure must be edited before use
Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long
' connect to the Access database
Dear Pooja Jee,
Hope the solution provided by Dave serves the purpose.
Regards,
C.G.Kumar
From: Dave Bonallack [mailto:davebonall...@hotmail.com]
Sent: Friday, November 20, 2009 9:57 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Require help on a condition
Hi
13 matches
Mail list logo