What is the format of the data source?What are you trying to do with the data?
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
If the row count is really 60lac than I strongly suggest you to please use
MS-Access for any DB (like MYSql or MSSQL) as Excel have rows limit (10lac
only.)
--
On Tue, Sep 6, 2016 at 1:24 PM, Malungo Tomson Banda <
malungotoms...@gmail.com> wrote:
> I need help breaking a numerical data range.
I need help breaking a numerical data range. I have an excel worksheet with
over 600 rows of data of which I am interested in just two columns that
contain numerical information.
Here is a sample.
RCV Serial StartRCV Serial End
801120206779111 801120206779111
105100851967111 1
Hi Joe,
In order to do so, an user form needs to be created which will ask for a
user name and password. Once the individual specifies the credentials, user
will be able to work on this.
If you could share the file, this can be done.
Thanks,
Ankit Mehra
On 8 Feb 2014 13:32, "Joe Rainone" wrote:
I am hoping some one can help me.
Here is what I need.
We are using one excel spreadsheet at work. This one excel spreadsheet has
7 different worksheets for 7 different users. All users have their own
password to protect and un protect their work. All their work is linked to
an 8th worksheet
Give us more information..for this.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sandes Bagwe
Sent: Tuesday, September 24, 2013 8:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I need help on one Macro creation
Hello All,
I
Hello All,
I have attached one excel file in which one column is source and other in
target, for XXX in target suppose transalation is given, for the source
which have blank in front of it copy the source and hide the all text
except the text just copied. Can any one help to create macro to wo
Try to using Offset
Ex: Before you run your code, active / selected cell was on C3, then try
to run this code
Sub Tes()
ActiveCell.Offset(1,0).Select'Move 1 Cell Down
Stop'See Your Current Selected Cell Now, then back here and
press F8
ActiveCell.Offset(0,1).Select'Mov
sorry, On Red Bold i mean ActiveCell.Offset(1,1)
On 31-08-2013 0:56, De Premor wrote:
Try to using Offset
Ex: Before you run your code, active / selected cell was on C3, then
try to run this code
Sub Tes()
ActiveCell.Offset(1,0).Select'Move 1 Cell Down
Stop'See Your Current Se
Hello, I am new to macros, and to recording them. I created a webquery with
a parameter that it edits a part of the query based on a cell I select. I
now have to run this web query 800+ times. So I recorded myself doing it
with the "Use relative references" checked. But it always puts the webque
For ex i have thousands of records in which one col has 7 digit number in
many rows. I need to extract only rows having that 7 digit number.
That number has digits 0-9.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANN
Thanks very much for your help, that's exactly what i need.
Thanks again
On Thu, Oct 6, 2011 at 3:56 AM, ChilExcel wrote:
> Please see attachment
>
> Chilexcel
>
>
> 2011/10/4 Ahmed Emam
>
>> Hi all members,
>>
>> I need an Excel sheet that contains check list for about 20 items , and
>> that w
Hi,
Do You want something Like this :
Sub MakeComponentinRunTImeOnSpreadSheet()
On Error Resume Next
Dim cb As OLEObject
n = 5
For i = 1 To 10
Set cb = ActiveSheet.OLEObjects.Add(classtype:="Forms.Checkbox.1")
With cb
.Top = n
.Object.Caption
tober 04, 2011 1:16 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ I need help
>
> Here it's attached
>
> On Tue, Oct 4, 2011 at 8:39 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Ahmed,
>>
>> if possible, Can you share Sample shee
Can you simply use
data>validation
as shown in the attached
From: Ahmed Emam
Sent: Tuesday, October 04, 2011 1:16 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ I need help
Here it's attached
On Tue, Oct 4, 2011 at 8:39 PM, NOORAIN ANSARI wrote:
Dear Ahme
Here it's attached
On Tue, Oct 4, 2011 at 8:39 PM, NOORAIN ANSARI wrote:
> Dear Ahmed,
>
> if possible, Can you share Sample sheet with group..
>
> On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam wrote:
>
>> Hi all members,
>>
>> I need an Excel sheet that contains check list for about 20 items
Dear Ahmed,
if possible, Can you share Sample sheet with group..
On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam wrote:
> Hi all members,
>
> I need an Excel sheet that contains check list for about 20 items , and
> that will be as a to-do note.
> Can anyone help me?
>
> Thanks in advance
>
> -
the file i need will have a list and every item will has in the next column
a check box that when i finish with one item i can check it.
As i told before it will be a to-do list.
Thanks
On Tue, Oct 4, 2011 at 7:18 PM, rajan verma wrote:
> hi,
> please explain ..
>
> On Tue, Oct 4, 2011 at 11:38 A
hi,
please explain ..
On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam wrote:
> Hi all members,
>
> I need an Excel sheet that contains check list for about 20 items , and
> that will be as a to-do note.
> Can anyone help me?
>
> Thanks in advance
>
> --
>
> ===*
> *
>
Hi all members,
I need an Excel sheet that contains check list for about 20 items , and that
will be as a to-do note.
Can anyone help me?
Thanks in advance
--
===*
*
*Ahmed Abu Al magd** Al emam***
General Accountant
*Al-Amana Technology Est. for Contracting*
I
I need help
in the attach
Conversion of data in the Sheet1
Like in Sheet 2
What is the Function that can be used
Thank for all
--~--~-~--~~~---~--~~
--
Some important links for e
21 matches
Mail list logo
