Dear Wilbur,
You can use a macro to make this happen. The macro should be written in
selection_change event of worksheet, so whenever the cursor move to A2..it
will go back to A1 address of worksheet.
Attached is the solution in macro enabled workbook for your reference.
Please let us know if any
Dude, This forum is to help genuine & real life problems of excel and macros
users.
Your test appears to be quite simple and it was made to test your
capability. You will not be able to learn if we will solve it.
First try at your end and if you find any problems in specific question,
just let us
Hi guys,
I am doing some financials of a small company with less than 50 transaction
per year. Well it's very small and I don't think I have to buy a fully
functioning accounting software, it will not be worth it. I am therefore
turning for your help in this regard. Is there someone who has deve
Dear Atul,
Use Rank formula for ranking of data. Attached is the solution for you.
Let us know if further help is required.
Best regards,
Ayush Jain
Group Owner
On Tue, Jan 26, 2010 at 10:00 AM, Atul wrote:
> Hi,
>
> Following is the list of financial Institution with interest rates. I
> need
Hi,
Following is the list of financial Institution with interest rates. I
need to assign Rank to the interest rate for specific Fin. Inst the
highest rate being rank 1, any multiple occurrences should be assighed
the same rank.
Financial Interest RANK
Institution Rate
A 1.25
B
Hi
I have a worksheet that contains hundred of chart sheets (each chart
in a sheet). Each chart has a title. I want to create a toc based on
each chart title using vba but I don't know how. I manage to create a
toc using sheet names but I want to use the chart titles instead. Any
help is appreciate
I have a scale that inputs data into excel via rskey, a keyboard
emulator that comes with the scale. No problems getting the data into
excel from the scale, however, a carriage return (enter) is sent after
the weight is entered into field A1. This sends the cursor to A2
after entering the weight
Hi Paul,
I've installed the add-in, but when I select Control Panel, I get an
error message "Cannot open key"
I'm using XL2007
Regards - Ramesh
On Jan 24, 12:34 pm, Dave Bonallack wrote:
> Hi Paul,
> I've installed it on my own laptop at home. I am the only user, and don't
> have to log in. How
Hii..
I'm looking for a macro or condition statement which would do
following for me:
If cell A1 is "BUY" then run a macro automatically which will add
current value in cell B1 to cell A3
so everything theres a "BUY" in cell A1..macro will keep addiing B1
values in cell A3
and
If cell A1 is "SE
Great formula - and thank you so much for taking the time to do
so...My format requires that each operating system version is on a new
row instead of a new column, which is what the attached sheet does.
Any idea how to accomplish this? My thought was a macro...Thanks
again!
Steve
On Jan 23, 4:30
hii all
i need to create a excel sheet which could send sms to my mobile based on
the condition in the excel sheet through the google sms channel
a1:a100 cell contains a name
b1:b100 and c1:c100 contains realtime data
if b1>c1,i should get an pop up message *once *in the screen and data(b1)
Hi All,
May I kindly request you to help me out on the below
attached spreadsheet query..
I need it today as i need to submit this tomorrow morg in my class.. please
help me..
Thanks,
Harish
-- Forwarded message --
From: Vinu
Date: Mon, Jan 25, 2010 at 9:48 PM
Subject: xl
To: ha
Hi,
I want to create sheets with details of each pivot field. I've got
following code for it which extracts details of field shown in that
particular cell.
For example, below code extracts details for field item shown in cell
C6 and put it in a separate sheet.
Range("C6").Select
Selection.Sh
Hello,
Please provide me any material to learn VBA codings. Advance thanks to all
the experts for your help. .
Regards,
Shilpa
On Mon, Jan 25, 2010 at 4:39 PM, Shilpa Rao wrote:
> Thankyou Dave, Mahesh Ashish for all your help. Thankyou all members in
> this group..
>
> On Mon, Jan 25, 2010 a
Thankyou Dave, Mahesh Ashish for all your help. Thankyou all members in
this group..
On Mon, Jan 25, 2010 at 6:43 AM, Dave Bonallack
wrote:
> Hi Shilpa,
> If you really want to do this with VBA, use the code below.
>
> Sub VlookupVBA()
> A = 1 'Start Row
> Do Until Cells(A, 1) = ""
>
Hello All,
I came to know yesterday that Excel 2003 has limitation to chart more than
32000 rows/data points.
However, this could be overcome with the creation of two separate
dataseries. I want to know if it is possibleto create an add-in for
implementing the same.
If it is possible, Can someon
Kindly go to tools menu & change in to general format
On 1/25/10, Sachin Shukla wrote:
>
> Dear All,
>
> Please help me on formating of cell:
>
> for example supoose I put the data in cell A1 say 5000
>
> Its automatically converted into date formate insted of number formate.
>
> Please help me
nice one!! shridhar
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Mon, Jan 25, 2010 at 1:26 PM, Sridhar jack wrote:
> Hi,
>
> Please find the attached
>
> Sridhar
> 9884984988
>
> On 1/25/10, steve d wrote:
>>
>> I
right click on a cell sellect Format cell select number tab then click on
number category
& see the result
On Mon, Jan 25, 2010 at 12:45 PM, Sachin Shukla wrote:
> Dear All,
>
> Please help me on formating of cell:
>
> for example supoose I put the data in cell A1 say 5000
>
> Its automaticall
Hi,
Please find the attached
Sridhar
9884984988
On 1/25/10, steve d wrote:
>
> I didn't realize that the formatting would change, while i am at it, i
> would like to search for 1a or 1b or 1c and have it put the corresponding
> location in the appropriate cell. please see attachment.
>
> Thank
20 matches
Mail list logo
