Try Ms-Access.
Put your data in a table and try the report wizard, which will guide
you.
If you still want the report in excel itself, it can be done using VBA
coding.
Send a sample file so that best approach can be decided based upon the
quantity of data and compelxity of the report.
Regards,
Hi all,
I'm trying to build an Excel solution that would do the following:
- User select a given spreadsheet/worksheet/column(sample below),
where file location may vary and exchange rate column will vary (based
on Month)
- Allows target selection:
User selects target spreadsheet(s)
Dear Noorian,
I am quite thrilled when found the logo of your *CompareWorksheetsAdd-in.xla
*different
from the usual one. I have been trying to change logo of single file without
success.
Can you guide how can i put different logo for a couple of files in a folder
to separate them by logo? Say
*Hi,*
*
*
*Please attach some Data in Excel...*
*
*
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Fri, Sep 9, 2011 at 2:04 AM, Jose Costa zakk.co...@gmail.com wrote:
Hi all,
I'm trying to build an Excel solution that would do
Hi ,
See Below links if Helps...
http://databases.about.com/od/tutorials/l/aareports1.htm
http://office.microsoft.com/en-us/access-help/create-a-simple-report-HA001230739.aspx
http://www.databasedev.co.uk/reports.html
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile
Hi Group,
I have one excel sheet with 2000 records. i want to split those records.
those 2000 records should copy into moresheets
for ex:
main sheet -- 2000 records;
sheet1 -- 1 to 200
sheet2 -- 201 to 400
sheet3 -- 401 to 600
.
.
.
sheet10 -- 1801 to 2000
thanks in advance
regards,
Hi All,
I have a spreadsheet that contains some test results that go across
multiple columns on each row. Now these results are unique to a serial
number, however can be tested on multiple dates i.e. after software
updates etc. Therefore need to be on seperate rows. See example below:
Ser No
thank you all very muchh
On Fri, Sep 9, 2011 at 10:51 AM, Venkat CV venkat1@gmail.com wrote:
Hi Bheema,
See below image and Try Data Validation and use custom and formula as *
=COUNTIF(C:C,C1)=1*
[image: image.png]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in
Hi!
I keep four excel workbooks in a folder and need to change logo of
each file separately to distinguish them by logo. The logo change in
Excel applies to all files. I need to have each file a different logo.
Please guide how to pick up logos?
Mahess
--
hello venkat ji,
the links which you have provided are seems very useful for me. but the
forums are closed registrations and replies for queries. If possible, is
there any other forum which provide sample examples with crystal reports
with VBA Excel
On Fri, Sep 9, 2011 at 10:54 AM, Venkat CV
Thank you Daniel
On Fri, Sep 9, 2011 at 2:56 PM, Daniel dcolarde...@free.fr wrote:
Hi,
** **
See attached file.
** **
Regards.
** **
Daniel
** **
*De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
*De la part de* Kal xcel
*Envoyé :*
Hi Group,
I have a form which has a Close button and a Code assgined to it as below:
Private Sub cmdClose_Click()
MsgBox Do you want to Save the details, vbYesNoCancel
Unload Me
End Sub
But What i need is when i Click on OK button on the form should close or
if i click on No the Form should not
Hi,
Look Attached...
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Fri, Sep 9, 2011 at 4:43 PM, Mr Excellent suryaprasad...@gmail.comwrote:
Hi Group,
I have a form which has a Close button and a Code assgined to it as below:
You should use:
Dim Result
Result = MsgBox(Do you want to Save the Details,vbYesNoCancel)
if (Result = vbYes) then Unload Me
or you could use something like:
select case Result
case vbYes
' Enter code to process when option is to Save Details
case vbNo
' Enter code to
Dear Surya,
use simple...for excel sheet..
**
*Private Sub cmdClose_Click()
ActiveWorkbook.Close True*
*End Sub*
for userform..
*Private *Sub* CommandButton1_Click()
If MsgBox(Do you want to Save the details, vbQuestion + vbOKCancel) =
vbYes Then
End If
Unload Me
End Sub*
--
Thanks
Hi Venkat,
Thanks for your quick reply.
I'm new to the group and couldn't find any option to attach files.
Jose
On Sep 9, 3:15 am, Venkat CV venkat1@gmail.com wrote:
*Hi,*
*
*
*Please attach some Data in Excel...*
*
*
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile
Hi Jose,
Just go to your Gmail and Compose Mail and send it to *
excel-macros@googlegroups.com * and it will Automatically Reach Group.. You
can attach your file in Gmail itself..
On Fri, Sep 9, 2011 at 6:15 PM, Jose Costa zakk.co...@gmail.com wrote:
Hi Venkat,
Thanks for your quick
Hi Andy
change For k = 3 To 7 if u have more than 7 cols in ur data
try the below code
Sub tests()
Dim i As Long
j = 1
For i = 2 To Sheets(1).Range(a65356).End(xlUp).Row
For k = 3 To 7
Sheets(2).Cells(j, 1).Value = Sheets(1).Cells(i, 1).Value
Sheets(2).Cells(j, 2).Value =
On 7 Sep., ShayneH wrote:
Is there a way to expose an array that is enclosed by a variant?
Basically I have one function that returns a variant type which needs
to be passed to another procedure that requires the parameter to be
typed as a byte array.
eg:
Function UsuallyReturnsAnArray()
Sub breaksheet_data()
For i = 1 To 2000
Sheets(1).Rows(i : i + 199).Copy
Sheets.Add After:=Sheets(Sheets.Count)
Cells(1, 1).Select
ActiveSheet.Paste
i = i + 200
Next
End Sub
On Fri, Sep 9, 2011 at 12:47 PM, naresh v naresh.veerabo...@gmail.comwrote:
Hi Group,
I have one excel
If you do it that way, you're going to skip some rows:
first loop:
i = 1, selects 1 to 200
i = i + 200 = 201
second loop: INCREMENTS i
i = 201, for loop increments to 202, selects 202 to 401
i = i + 200 = 402
loop increments 402 to 403,
selects 403-602
what you SHOULD use for the loop is:
Great!!! But Result not.
On Fri, Sep 9, 2011 at 10:39 AM, Venkat CV venkat1@gmail.com wrote:
Hi Varun,
See if Helps Attached...
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71
*
On Thu, Sep 8,
Venkat Ji...
Google Baba Ki Jai
http://msdn.microsoft.com/en-us/library/ezk76t25%28v=vs.71%29.aspx
On Fri, Sep 9, 2011 at 10:47 AM, Venkat CV venkat1@gmail.com wrote:
Dear All,
Find attached some Examples With Loops...in VBA it will useful
*Best Regards,*
*Venkat *
I am using a form to enter data and then from the textbox complete
data in an excel spreadsheet. This is my code
ActiveCell.Value = Date
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = FrmApplications.TextBox1.Value
ActiveCell.Offset(0, 1).Select
Activecell.Value = Date works
Hi
Try
ActiveCell.Value = Format(FrmApplications.TextBox1.Value,dd/mm/)
Thanks
Mahesh
On Fri, Sep 9, 2011 at 10:26 PM, Brian brianfosterbl...@gmail.com wrote:
I am using a form to enter data and then from the textbox complete
data in an excel spreadsheet. This is my code
How is the date entered into the textbox?
perhaps Excel isn't recognizing the value as an actual date...
Try this:]
if (isdate(frmApplications.TextBox1.Value)) then
ActiveCell.Value = Format(frmApplications.TextBox1.Value)) , dd/mm/)
end if
I'm suspecting that the value in the textbox
I would like to know whether its possible to move sheets from one
workbook to another without the formulas on the sheets moved being
changed?
For example I want to move two sheets from one workbook to another.
One of those sheets populates info from the other sheet that is being
moved with it.
IF??? I understand just copypaste valuescopy .
-Original Message-
From: bom
Sent: Friday, September 09, 2011 2:24 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Moving Sheets
I would like to know whether its possible to move sheets from one
workbook to another without
If crystal reports can be used for excel vba, which version is compatible ?
On Sat, Sep 10, 2011 at 9:55 AM, Shankar Bheema shankar.n...@gmail.comwrote:
I am attaching excel which is having VBA code for Userform. Pls press
Alt+F11 after opening the excelsheet.
I also attached a word
29 matches
Mail list logo