Hi Friends,
I need to map data from one excel workbook to another excel workbook.
I need to open the source workbook then need to create new workbook
and some cells of data needs to be maped from source workbook to newly
created workbook.
Source workbook has one sheet (Source)
newly created work
Hi Gurus,
In excel sheet Column A contains the strings like the follwing.
ex: 1. "Fwd: A9504X1-1435 effexor - mexico - category"
2. "Re: effexor - taiwan - category B5343x4-1346"
3. "Fwd: Protocol number 2353x1- 4353 taiwan"
4. "Re : A3536x6 - 5325 protocol number"
5. "Pro
n the new sheet has to insert
with data as sheet (sample2).
I am very sorry if you are not understand my english, I quite poor at English.
Please kinldy help me this regard.
Thanks&Regards
Ramesh, Katta
--
--
Hi Friends,
I am Ram, working with an MNC company. My project leader asked me to
design the project documents for VBA. Since I am new to development
project, I don't know how to design the documents. Please let me know
what are we need to prepare.
And also I need code and study documents on A
Dear members,
Please kindly help me with FAQ's on VBA Excel. I am working on excel
so far, now I have a interview with one of the top company on VBA. I
have got little knowledge on macros through our group.
Thanks in advance
Regards
Ramesh
--~--~-~--~~~---~--~
Hi Dear Members,
Name: Ramesh Katta
Tip: Create chart by pressing F11 function key.
We can create a chart quickly without having to use the chart button
on the toolbar by pressing the function key F11 whilst inside a range
of data.
I have attached a workbook for reference just press F11 on data
Dear members,
How to protect range of cells in worksheet. I attached a workbook in
that red colored cells should not allow others to edit.
Please find the attached workbook.
Thanks&Regards
Ramesh
--~--~-~--~~~---~--~~
---
Hi Amitabh
Thank you very much.
Regards
Ramesh
On Fri, Jun 12, 2009 at 1:59 AM, Amitabh Bose wrote:
>
> Hi Ramesh,
>
> I have attached the spreadsheet and solved the second issue with regard to
> the Date() function. and this is on the sheet named 'Date formats'. There
> may be better ways of d
Hi Dave,
I had doubt on large() and date() functions now I got the solution
from Mr. Dilip.
Thanks&Regards
Ramesh
On Fri, Jun 12, 2009 at 5:26 AM, Dave
Bonallack wrote:
> Hi,
> Have a look at the attached and see if it does what you want.
> Regards - Dave.
>
>> Dear members,
>>
>> Please go thr
pandey
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
> On Fri, Jun 12, 2009 at 11:53 AM, Ramesh Katta wrote:
>>
>> Dear members,
>>
>> Pl
Dear members,
Please go through the attached document for questions I asked
Regards
Ramesh
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials
ed in (), or RED).
> So.. semantically, you are using "Format Cells" to
> define a specific "format" to use when the values meet
> a certain "condition", but this is NOT the same as using
> "Conditional Formatting".
>
>
> Conditional Form
Dear member,
I have a question which was asked in interview. The question is how
to apply color to range with using conditional formatting.
For example i have range suppose a1:a20 containing negative and
positive values. I need all negative numbers in red color and
positive numbers in green col
Hi Amithab,
Thank you very much.
Regards
Ramesh
On Thu, Jun 11, 2009 at 7:09 AM, Amitabh Bose wrote:
>
> Hi Ramesh,
>
> Please find the file attached with the vlookup formula.
>
> The basic formula is:
> =VLOOKUP($A3,Sheet1!$B$4:$F$18,4,0)
>
> The ISNA formula is to replace any blank cells whic
Hi Dear members,
I have a doubt on Using vlookup, fill in the values in Sheet "2" by
referring to the values in Sheet "1". I have attached a file for
reference.
Thanks&Regards
Ramesh
--~--~-~--~~~---~--~~
-
e tip but its showing the formule of current cell only not for
> entire work sheet.
> Is there any another way to use this tip Kindly share the same.
>
>
> BR
> MSN
>
>
> On Mon, Jun 8, 2009 at 9:50 AM, Ramesh Katta wrote:
>>
>> Hi all,
>>
>>
Hi all,
Name : Ramesh
Subject : Open a workbook which has formule.
Tip :Use Ctrl+` to see the all formule which are in the sheet.
We use Ctrl+` to see the all used formulas in the current worksheet.
Thanks&Regards
Ramesh K
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> On Behalf Of Ramesh Katta
> Sent: 07 June, 2009 5:25 PM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Doubt on data range
>
> Dear Members,
>
&g
Dear Members,
My question seems to be very simple, please don't laugh at me.
I have 2 columns that are A1 contains Names and B1 contains Sex of
employee. When finding no. of males and females using countif()
function. When I copied the function I am getting range difference.
For ex:
=countif(a
t;
> Dim oRange as Range
> Dim iTotal as Double
>
> iTotal = 0
>
> For Each oRange In Application.Range ("A1:A10")
> iTotal = iTotal + oRange.Value
> Next
>
> MsgBox ("Total Value is : " + iTotal)
>
> Thank you,
> Dev
>
>
> On May
Hi Gurus,
I am Ramesh, new to vba programs. I need a macro to calculate sum for
range of column. The should be displayed with MsgBox.
For example: Column A has numbers 1,2,3,4,5,6,7,8,9,10...
I want to calculate the cells we entered and displayed on MsgBox.
Thanks&Regards
Ra
Hi
For copying files from command prompt. First you have to determine
source and destination of a file.
for ex- D:/ramesh copy myfile.xls E:/naidu
through the above command myfile.xls file copy from d drive to e drive.
Thank you
Ramesh
On Tue, May 5, 2009 at 9:26 PM, yogesh yerawar wrote
22 matches
Mail list logo
