Hi Group,
I have to copy a range of cells from anotherworkbook to activeworkbook,
without opening the workbook.
Example: I have the activeworkbook present in
C:\ Temp1\XXX\YYY\Book1.xls
while the other workbook resides at the following
C:\Temp2\XXX\YYY\Book2.xls
I have to copy Contents of
HI,
I HAVE 500 PERSONS NAME IN SHEET1.
LIKE:-BOX
BAT
BALL
BLACK
AXE
IN SHEET2 AND SELECT CELL A1 WHEN I ENTER FIRST LETTER (AVAILABLE IN
SHEET1) LIKE B COLUMN C SHOWS LIST OF AVAILABLE NAMES STARTING
WITH B-LETTER.ITS LIKE GOOGLE
Hi Frnds,
i also have same Query
As mentioned i tried for the B1-A1 but its not working.as it contains
date and time also,one of my frnd has made macro for the same.i wil gv
it to u tomorrow.
On 3/6/10, Ayush jainayus...@gmail.com wrote:
Hi Harpreet,
Simply you can use
Hi, I am currently using the following code, however I want this code
to work continously when ever the numbers in row 1 change (these
numbers change autimatically as they are a live feed referenced from
another program). How can I make this continous?
Sub Bid_Offer_Tracker()
'Highest Bid
Hi Harpreet Gujral
In cell c1 you can use formula like this
=IF(A1-B10,(A1-B1)*-1,A1-B1)
then select in format cell Time - Select hours (should be
37:30:55)
and D1 you have to put some trick to remind you that result will delay or
still have time
==IF(A2-B20,Delay(Hrs),Have
right click on cell click on format cell- choose the custom format - nad
type this [hh]:mm
On Sun, Mar 7, 2010 at 12:42 PM, Harpreet Singh Gujral
harpreetguj...@gmail.com wrote:
Ayush,
I tried your solution, it works to some extent, but it doesnt work if
the date and time in B1, is more by
Where I work we have four computers to share within a group of about
50 people.
To deal with the problem of adware and viruses the IS group runs a
routine each night that wipes the computers clean and resets them to a
default state.
This works good for elimination spyware and such, but it also
Hi David,
I think placing the code in the Worksheet change event would help.
The event would be trigered as and when any cell on the sheet is
changed, and in the event it would revisit all your conditions that
are present in the code. Your code would look something like this.
Private Sub