thanks sir,but can u tell me that how to use in many columns, i means
how can i define column name because i have many columns in that i
have to apply vlookup request,can
u to plz send me the solution in excel file it will be very helpful
for me.one more thing iwant to ask u that i want a macro fo
thanks sir,but can u tell me that how to use in many columns, i means
how can i define column name because i have many columns in that i
have to apply vlookup request,can
u to plz send me the solution in excel file it will be very helpful
for me.one more thing iwant to ask u that i want a macro fo
Please see attached file
Chilexcel
2011/5/9 rajan verma
> HI,
> Please see if it help..
>
>
> On Sun, May 8, 2011 at 4:01 PM, Rajesh K R wrote:
>
>> Hi Experts
>> Is it possible to create two buttons one for forward & other for
>> backward and move to sheets in the order what we used after l
Could you please attach the file or highlight which line you are
facing the error.
On May 6, 11:33 am, "Kabir:-)" wrote:
> Dear Mr. Golden Lance,
>
> When i m copying the code and executing in the new workbook, the following
> error is showing. Kindly help me.
>
> *Compile err
try using
Application.OnTime method
http://www.ozgrid.com/Excel/run-macro-on-time.htm
http://www.cpearson.com/excel/OnTime.aspx
On Mon, May 9, 2011 at 1:17 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Hi All,
>
>
>
> I am having one database which is link to the external data
Yogesh,
I think it is the problem with heading row (field Names).
There are certian convensions which has to be followed while giving
field names in access.
In that case you can review (rename) the column names in such a way
that they will not include
any special characters and lengthy names.
If
Hi
The xlsm file is not open in my computer will u send the code inside it.
Regards
Rajesh Kainikkara
On 5/9/11, rajan verma wrote:
> HI,
> Please see if it help..
>
> On Sun, May 8, 2011 at 4:01 PM, Rajesh K R
> wrote:
>
>> Hi Experts
>> Is it possible to create two buttons one for forward & o
Hello Team,
could you please help me with the below file. explained the problem in the
attached file.
Thanks,
Vinod.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hello team,
Could you please help me for the below scenario:
Need a code to copy paste column data under one column and keep the
same description.
A B C
bangmysore
jan 645 978
feb 645
mar978
it should be realigned like below: no of row
Hi Yogesh,
My guess is that the SQL generated by MS Query for your specific data
connection is wrong. Normally in SQL the '*' is used as an 'ALL' so
that you would have SQL like the following:
SELECT * FROM
Thats the basic select statement. If the syntax is wrong somewhere the
SQL cannot be proc
Please send some cheats for excel
Sent on my BlackBerry® from Vodafone
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Link
Hi All,
I am having one database which is link to the external data (Internet)... I
need the VBA code where the data will automatically refresh after 30 seconds /
15 Seconds, but it should not be a loop it just a macro automatically running
after 15 sec.
Example : My data is refreshed at 11:44
There is no sample data in the attached file.
Regards,
Kishan Reddy, K
On May 8, 5:22 pm, Rajesh K R wrote:
> Hi Experts
>
> I need code to find the cells in column "A" having date above the date
> specified in "C1" then select the entire column and delete it. Then
> loop until all the data abov
I think, it is time you to study error handling procedures.
Example.
ON ERROR GO TO
RESUME
RESUME NEXT
Go Ahead.
Regards,
Kishan Reddy, K
On May 9, 1:15 am, hanumant shinde wrote:
> Hey guys,
>
> its been 2 days but not even single reply. is it too tough or its not at all
> possible.
> i a
sorry for confusing will cut short all the steps . i will send the recorded
code , i have prepared it using Macro recording can anyone please edit that
code will send today end of the day.
Thanks for your help in advance.
Regards,
Prathima
On Mon, May 2, 2011 at 1:49 PM, Mahesh parab wrote:
>
HI,
Please see if it help..
On Sun, May 8, 2011 at 4:01 PM, Rajesh K R wrote:
> Hi Experts
> Is it possible to create two buttons one for forward & other for
> backward and move to sheets in the order what we used after login just
> like we do in a browser.Pls check the attachment
>
> Regards
> R
*Thank you so much. I am very grateful to you.
*
ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
On Sun, May 8, 2011 at 6:59 AM, STDEV(i) wrote:
>
> try to use this UDF (user defined function)
> Function UniqueList(Dat As Range)
>' List of UnSorted Unique Values '
>'
Dear All,
I am attaching an Excel with some hypothetical data.
Please help me to :
- Take out the data by filtering the Managers name and paste it in a New
Work Book.
- Sent it to the respective managers E-Mail ID.
- All the above actions should get done in a button Click.
Awaiting
see if it helps
CODE:
With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _
"ODBC;DSN=PP;UID=ris;PWD=ri;DBQ=PP;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI=F"
_
), Array(";CSR=F;FWC=F;PFC=10;TLO=0;")), Destination:=Range("A1"))
19 matches
Mail list logo
