Thanks dear
From: DILIPandey [mailto:dilipan...@gmail.com]
Sent: Tuesday, January 14, 2014 11:07 AM
To: excel-macros
Cc: todhavals...@gmail.com
Subject: Re: $$Excel-Macros$$ how to reduce file size
Hi Dhaval,
Unhide all the hidden rows & columns in all the columns and remove extra
for
remove unnecessary formatting , save the file in xlsb (binary format)
Also try this addin
http://www.microsoft.com/en-us/download/details.aspx?id=21649
Regards
Ashish
On Tue, Jan 14, 2014 at 9:14 AM, Dhaval Shah wrote:
> Friends
>
> i have a file with v limited data in file automatic my fil
It's because, for the code to organize the data in ascending order first
reverses the order of characters (see below). And as we can see "K010B" is
less than "K100"
Hi Tom, could you give an idea of the variation of characters as quantity
and characteristics, so I can study the possibilities?
Hello Experts:
Thank you for your time.
I have a large workbook. The first page contains many checkboxes - a few
primary ones, some secondary, others tertiary, etc. The user is to see only
the primary ones, then depending on his selection, specific secondary
checkboxes should appear. If he
It's all working well in the master sheet! except we've reached batch 10
and that batch is going to the top of the list rather than the bottom ie.
*B010K * 001K 002K 003K B004K B005K B006K 007K 008K 009K
do you know why that has happened?
Tom
On Monday, January 13, 2014 1:11:41
Ok thanks for all your help, i'll get in touch if I have any more problems!
Thanks for everything
Tom
On Monday, January 13, 2014 12:20:20 PM UTC, Basole wrote:
> No problem. Since the batch number, the end has the letter "K" the code
> search this number, regardless of the number of characters.
No problem. Since the batch number, the end has the letter "K" the code
search this number, regardless of the number of characters.
The other issue: To use this code in another workbook, you need ->
Press Alt + F11, click on "Module1" and copy the entire code. In another
workbook, do the same thi
Sorry, i should have explained better, the batch number can go up to about
400 over the year, so it needs to be able to order data from 001K all
the way up to 400K (any of the numbers could be B???K or TN???K as well...)
does that help?
Thanks
Tom
On Monday, January 13, 2014 11:05:32 AM UTC, Ba
Sorry I'm not understanding what you mean by "One thing, once the data gets
to 10 or 100 they skip to the top of the column (ie batch 100K or 010K) is
this just what will happen or can it be changed?"
Basole.
Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Yaxley
escreveu:
>
Hi Basole,
I have no idea how you've done that but its saved me a lot of work! One
thing, once the data gets to 10 or 100 they skip to the top of the column
(ie batch 100K or 010K) is this just what will happen or can it be changed?
Also how would i go about copying this into a different workbook
Please see below, anyone able to offer some advice?
On Tuesday, December 24, 2013 10:08:07 AM UTC, Brett Manning wrote:
>
> Hello,
>
> I have created a spreadsheet which looks at various different worksheets
> in the same spreadsheet in order to return the data to one central
> worksheet. I hav
11 matches
Mail list logo
