Hi,
I see your code and this spread sheet is great. I was wondering if there
was a way to stop the code from running when you select the whole row to
copy and paste it in a different line.
On Thursday, April 25, 2013 at 3:24:17 AM UTC-4, Abhishek Jain wrote:
>
> Please see the attached.
>
> F
Does this function as an autocomplete for drop down validation lists? I've
been looking forever for a solution but I am beginning to lose hope. I
need it to function without using combobox.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Joi
I am not the greatest at coding, but this is sheer genius for me. I have
gotten it to work in a similar workbook with great results.
My question to this old thread is this: I have about 7 different
worksheets of lists. List 1 is used to autocomplete cells c7,c18,c19,c25
in the master sheet.
Its a name range. See the range under "Name Manager" in the "Formulas" tab
(Excel 2007).
HTH/Abhishek
On Thu, Jun 12, 2014 at 6:29 PM, Waqar Ahmed
wrote:
> Hello everybody,
>
> I have a problem that I can't increase the list range , I can't find value
> (Range name "List") Please help.
>
> Reg
Hello everybody,
I have a problem that I can't increase the list range , I can't find value
(Range name "List") Please help.
Regards
On Thursday, April 25, 2013 12:54:17 PM UTC+5:30, Abhi wrote:
> Please see the attached.
>
> First sheet (List) has the list of items wherein the VBA would searc
Hi,
Can we do this using VBA macro? I understand that excel will struggle while
searching. But is it possible? If yes, could anyone help me out? Thanks
On Wed, Apr 24, 2013 at 2:45 PM, Kanwaljit Singh wrote:
> Hello Sir,
>
> What I understand that is
> --You are using a Validation List
> --You
Hello Sir,
What I understand that is
--You are using a Validation List
--You want that When you start typing in the cell, the entries in
validation list start reducing to those matching the words, like a
wild-card search.
It that is true, I don't think there is any Excel Add-in for such purpose.
Mathan wrote:
>
> From: Mathan
> Subject: Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)
> To: excel-macros@googlegroups.com
> Date: Sunday, April 21, 2013, 9:17 PM
>
> Hi Experts, Any updates on this ? Your help is much appreciated.. Thanks
>
>
>
> On S
e which will replace off into Office
>> Supplies.
>>
>> Just go to file->option->proofing->autocorrect, type off in replace box
>> and office Supplies in with box.
>>
>> --- On *Sun, 4/21/13, Mathan * wrote:
>>
>>
>> From: Mathan
>
ice Supplies in with box.
>
> --- On *Sun, 4/21/13, Mathan * wrote:
>
>
> From: Mathan
>
> Subject: Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)
> To: excel-macros@googlegroups.com
> Date: Sunday, April 21, 2013, 9:17 PM
>
>
> Hi Experts,
Mathan wrote:
>
> From: Mathan
> Subject: Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)
> To: excel-macros@googlegroups.com
> Date: Sunday, April 21, 2013, 9:17 PM
>
> Hi Experts, Any updates on this ? Your help is much appreciated.. Thanks
>
>
>
> On S
you can use auto corrrect feature which will replace off into Office Supplies.
Just go to file->option->proofing->autocorrect, type off in replace box and
office Supplies in with box.
--- On Sun, 4/21/13, Mathan wrote:
From: Mathan
Subject: Re: $$Excel-Macros$$ Excel Add-in (that ena
: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)
Hi, thanks for your reply but my requirement is different. Auto
complete should work even the words are in different column or
different sheet. And it's not work with Alt+down arrow. Thanks
On 21/04/2013, xlstime wrote:
> H
Hi, thanks for your reply but my requirement is different. Auto
complete should work even the words are in different column or
different sheet. And it's not work with Alt+down arrow. Thanks
On 21/04/2013, xlstime wrote:
> Hi Mathan,
>
> You can use "Pick from drop-down list"
>
> just press Alt+d
Hi Mathan,
You can use "Pick from drop-down list"
just press Alt+down arrow
.
Enjoy
Team XLS
On Sun, Apr 21, 2013 at 9:17 PM, Mathan wrote:
> Hi Experts, Any updates on this ? Your help is much appreciated.. Thanks
>
>
> On Sat, Apr 13, 2013 at 12:32 AM, Mathan w
Hi Experts, Any updates on this ? Your help is much appreciated.. Thanks
On Sat, Apr 13, 2013 at 12:32 AM, Mathan wrote:
> Hello Experts,
>
> I am looking for an excel add-in that will enable Autocomplete from any
> column or Sheet within a workbook
>
> For example, lets say i have a sheet call
Hello Experts,
I am looking for an excel add-in that will enable Autocomplete from any
column or Sheet within a workbook
For example, lets say i have a sheet called "Accounts" where I have the
following:
A1 - Office Supplies
A2 - Marketing
A3 - Auto Expense
A4 - Payroll
If I go to *A5* and sta
17 matches
Mail list logo
