Dear Group members,
In attached excel file, I have a little vba code.
It gets data from Column B in Sheet2 to Column D in Sheet1 if Column D in
Sheet2 equals Column A in Sheet1.
The only problem occurs when the Items of Column D in Sheet2 are not unique.
You can see there three 15-May-09. So it
Hi All,
I want some tool or any idea that how we can change or correct the spelling
which we write in excel (i wanted like word that if u write some uncorrect
word or wrong word ,ms word automatically uderline that word in Red gives
us option when u right click for auto correct, related words
What does paracept and ceizg mean?
Thank you.
From: tinu...@baja.hu
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Sum
Date: Tue, 5 May 2009 23:37:57 +0200
Brilliant!
From:
excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of
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
Hi for spelling check u can use F7 funciton key.
select the data and press F7 key it will cheque for spelling.
Regards
On Tue, May 5, 2009 at 11:41 PM, maulik desai mauliksde...@gmail.comwrote:
Hi All,
I want some tool or any idea that how we can change or correct the spelling
which we
If you are using Excel 2003 you shoul access Insert Name Define then
you cal select varGroupSize and edit it.
If you´re using 2007 just goto Formulas Name manager
then you cal select varGroupSize and edit it.
Regards!
2009/5/5 Michael Fowler blank.appa...@gmail.com
Thanks. My data is
Hi Maulik,
Just press key F7 after completion of sentence - which is similarly for word
where you can replace or spell check.
Cheers
Surya
On Wed, May 6, 2009 at 12:11 PM, maulik desai mauliksde...@gmail.comwrote:
Hi All,
I want some tool or any idea that how we can change or correct the
I need help in writing this macro
if the cell content is empty fill it with Red
if cell content contains Y then fill it with Yellow
if no Y and any content then fill it with Green
thanks...its urgent
--~--~-~--~~~---~--~~
more tips on Command line:
start a new Excel session:
call C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE
Q:\Summit\Prod\Excel\test.xls
start a workbook in existing Excel session
call Q:\Summit\Prod\Excel\test.xls
But any one knows how to save or close or other manipulation on Excel
Hi Yu,
Please use
=INDIRECT(B1C1)
Please let me know if it helps.
Regards,
Andy
On Wed, May 6, 2009 at 9:34 PM, Yu vincent2...@gmail.com wrote:
Hi dear all,
For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1
has. Now B1 has valueA, and C1 has value 1, I want D1 has
Use and operator as:
WHERE table.Cal LIKE 2009%
AND table.Cal = 'Jan1'
I hope that solves the issue.
On Wed, May 6, 2009 at 8:13 PM, Yu vincent2...@gmail.com wrote:
Hi Dear members,
I need to extract some data from Database. For instance, I have
such an column in a table. I
Instead of vba use conditional formatting, would be better.
if u need help in conditional formatting for ur query then lemme know.
On Wed, May 6, 2009 at 5:04 PM, xxx lavanyaredd...@gmail.com wrote:
I need help in writing this macro
if the cell content is empty fill it with Red
if cell
You will need to use the indirect formula, which converts an addres to
a reference
=indirect(b1 c1)
Regards!
Fabio L. Lemos
cel.: 8122-1206
Em 06/05/2009, às 11:34, Yu vincent2...@gmail.com escreveu:
Hi dear all,
For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1
pls help me.
On Sat, May 2, 2009 at 9:46 AM, jayendra gaurav
jayendra.gau...@gmail.comwrote:
Dear all
Pls help me for below point.in attached file
1. When chage the calender year the data reamins same on that day. 2.
Required daily task( TO DO) to be cary forward next day if not
Hi,
I need to hide a worksheet on closing the workbook.
I have tried doing this using Workbook_BeforeClose and also
Workbook_Open but these have not consistently perfomed this task.
When using Workbook_BeforeClose and closing the workbook using the
workbook x (not the excel x) the first time I
Thanks to all
On May 6, 7:19 pm, Harmeet Singh harmeet.hew...@gmail.com wrote:
Instead of vba use conditional formatting, would be better.
if u need help in conditional formatting for ur query then lemme know.
On Wed, May 6, 2009 at 5:04 PM, xxx lavanyaredd...@gmail.com wrote:
I need help
Plz help me to crack the password for MS - Word.
Thanks and regards,
Kamal Gulati
On Mon, May 4, 2009 at 10:27 PM, Praveen Khunte praveen.khu...@gmail.comwrote:
Install Ultimate Add-in attached along with the mail. Explore the options,
I m sure you can break passwords of excel *worksheet*
You can use SUMIF function.
2009/5/6 Samir Agayev saga...@gmail.com
Dear Group members,
In attached excel file, I have a little vba code.
It gets data from Column B in Sheet2 to Column D in Sheet1 if Column D in
Sheet2 equals Column A in Sheet1.
The only problem occurs when the Items of
Good. Glad to help.
Date: Wed, 6 May 2009 05:22:51 -0700
Subject: $$Excel-Macros$$ Re: VBA code to search a column for a string
From: dsrmccl...@gmail.com
To: excel-macros@googlegroups.com
Dave,
Thanks. With a little bit of tweaking that's just what I needed!
Doug
On May 5,
WHERE table.Cal LIKE 2009%
OR table.Cal = 'Jan1'
On Wed, May 6, 2009 at 10:17 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
Use and operator as:
WHERE table.Cal LIKE 2009%
AND table.Cal = 'Jan1'
I hope that solves the issue.
On Wed, May 6, 2009 at 8:13 PM, Yu
SQL Server has a windows based system easy to do there putting selection
creteria
On Wed, May 6, 2009 at 8:13 PM, Yu vincent2...@gmail.com wrote:
Hi Dear members,
I need to extract some data from Database. For instance, I have
such an column in a table. I wanna extract Jan1 ,Feb2 and
You can use the following code (slightly changed from original).
Sub RedemptionsUSD()
Dim ModelCash As Worksheet
Dim CashFlow As Worksheet
Set ModelCash = Workbooks(Model.xls).Worksheets(1)
Set CashFlow = Workbooks(Model.xls).Worksheets(2)
Dim j As Integer
Dim c As
22 matches
Mail list logo