Dear Jason,
To do this you do not need the macros
Go to edit-> Fill-> Down
That will work
Sanjoy
On Mon, Feb 8, 2010 at 3:24 AM, jason nix wrote:
> I am trying to teach myself how to use the vba. I want to use a copy/paste
> and loop macro for some equations. I already know how to use my f
Dear Imran
Select A3 to A9 Data-> Text to Column-> Delimited-> other-> choose
underscore and that will solve the issue.
Sanjoy
On Sun, Feb 7, 2010 at 10:40 AM, Imran khan wrote:
> Dear Friends,
>
> Please help me for solution of attached file. I am stuck now and need your
> help on this r
1. Start Pivot Table Wizard and select external data source.
2. You can also use DAO to query data from database:
Example procedure is as mentioned below. Remember add reference to DAO in VBA
reference library.
Function GetDBData()
Dim db As Database, rs As Recordset
Set db = OpenDatabase(Curren
Dear All.
I have a multipage control over my spreadsheet. Then I chose to insert
a command button over my multipage control. What happens is that this
button control gets attached to my spreadsheet and not the multipage
control.
I've tried some tricks like Group Objects, but doesn't seem to work.
I am trying to teach myself how to use the vba. I want to use a copy/paste and
loop macro for some equations. I already know how to use my formulas to
automatically calculate but I need help getting info into the right cell. The
basics of it goes like this; I want to get a number to copy to the
Hello everbody .
I need help to create a macro(I just start to use macro).
So I'm looking for a macro that will check in
Sheets("pequenas_granel_1").Range("C13:D13") need to copy it if
Range("G13:J13") has some value, so if Range("G13:J13") has value copy
Range("C13:G13") and Range("G13:J13") to
Hi Gurus,
1. Table shown in the attachment is a HR report needs to be generated every
week.
2. This report basically gives the management Dept wise and Desig wise
headcount
details.
3. The backup data for this report is maintained inAccess 2007.
4. I have more than 100,000 records in the Acces
You are always welcome Vimal...!!
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 2/7/10, vimal barlota wrote:
>
> Thanks a lot . this is exactly wat i wanted . you saved my lot of manua
Thanks a lot . this is exactly wat i wanted . you saved my lot of manual
time . thanks a ton .
Cheers,
Vimal Barlota
On Sun, Feb 7, 2010 at 8:53 PM, Dilip Pandey wrote:
> Dear Vimal,
>
> Attached file has been formulated as per your requirement(s).
> Get back to me in case of any queries.
>
> T
Dear Harpreet,
Some members have given you download link(s) from where your can download
the compatibility pack.
Please revert in case of any challenge(s). Thanks.
Thanks & Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B Com(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
Dear Vimal,
Attached file has been formulated as per your requirement(s).
Get back to me in case of any queries.
Thanks & Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B Com(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 2/7/10, vimal barlota w
Dear Vinu,
Formula is revised as per new scenario. Check the attached file and let me
know in case of any challenge(s).
Thanks & Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B Com(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 2/7/10, Vinu wr
you are always welcome..!!
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B Com(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 2/6/10, Drew Tennenbaum wrote:
>
> Thank you very much Dilip! I appreciate the help.
>
> Drew
>
>
> On Sat, Feb 6
You can download a free copy of Microsoft Office Compatibility Pack for
Word, Excel, and PowerPoint 2007 file formats from
http://office.microsoft.com/en-us/products/ha101686761033.aspx
Tom Jeffries
On Sat, Feb 6, 2010 at 1:19 PM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Hi Dil
Thank you, Ayush. This is exactly what I wanted.
Regards
Yahya
On Sun, Feb 7, 2010 at 1:21 PM, ayush jain wrote:
> Hi Yahya,
>
> Attached is the solution. Use the below code in ThisWorkbook code section.
>
> Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
>
> Di
Hi Yahya,
Attached is the solution. Use the below code in ThisWorkbook code section.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If ws.Range("C1").Value = "0" Then
ws.Visible
Hi
I have a workbook which has a no of worksheets. I want to hide all those
worksheets automatically, when the value of a particular cell (Say C1) in
that worksheet is zero. Can someone help me with the code for it?
Regards
Yahya
--
---
Hi Chandhrabhan,
Your query might be a little misplaced as it is a forum mainly for Excel
users. However I am attaching a few links as pointers that might help you to
easily resolve your query.
http://support.microsoft.com/kb/308459
http://office.microsoft.com/en-us/access/HA010345961033.aspx
htt
Hello Dilip,
Thanks a lot for taking time to answer my query .. i have another question
. hope i am not asking too much..after getting the top ten sales i need to
get their corresponding volume and pid . i can do this by using index and
match formula. but how to find volumes when the sales are s
Hi Group,
I want to seek help regarding CDO Object
I have designed a sheet, which contains User Form, which allows a user to
send an email. It has been programmed to send email through Gmail server.
I am facing the following problem:
1) The variable storing the user name and passwrod supplied b
Thanx Ashish.its work..thanx again
- Umesh Matkar
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ashish koul
Sent: Saturday, February 06, 2010 7:57 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help - consolidate
21 matches
Mail list logo
