$$Excel-Macros$$ Re: Comparing two excel sheets

2010-07-12 Thread Soni.Rajender
Hi Not getting you, please provide a sample sheet. Regards Rajender Soni On Jul 13, 1:06 am, Al wrote: > Dear All: > > I get excel sheet on monthy basis . and i am trying to provide a > summary of differences(new rows, deleted rows and changed) between the > present excel sheet > and the one i

Re: $$Excel-Macros$$ Online tutorials for macros

2010-07-12 Thread Mr excel
Very useful for learning the basics.thanks for the links On Mon, Jul 12, 2010 at 10:13 AM, Soni.Rajender wrote: > Hi > > Use the below link: > > http://www.familycomputerclub.com/excel/excel2003_macros.html > > the link was already suggested by one of our group member. > > Regards > Rajender Soni

$$Excel-Macros$$ Help with loop to search and copy data

2010-07-12 Thread GrPacker
I am very new to VBA and have pieced together this code that works except for one thing. The code will search for two different criteria through other worksheets and then copy that cell back to a desired "report" worksheet. It works, but only finds and returns the first hit in each of the workshe

$$Excel-Macros$$ Re: Run time error 1004

2010-07-12 Thread larry
Getting rid of the .text and ,value cleared up the run error. However, the activate didn't work as expected. It started writing in the input table which is what I was trying to avoid in the first place. Is this an excel vs vba command issue? What is the easiest way to get the activate to switch.

$$Excel-Macros$$ Comparing two excel sheets

2010-07-12 Thread Al
Dear All: I get excel sheet on monthy basis . and i am trying to provide a summary of differences(new rows, deleted rows and changed) between the present excel sheet and the one i got a month earlier . can this is achieved ..? Thanks in advance Al -- --

$$Excel-Macros$$ Google Translator Using VBA - HELP !!!

2010-07-12 Thread Anish Shrivastava
Hello Experts, Yesterday, while using Google Translator manually I just thought if it can be automated using VBA. Actually what my task includes is to Convert various European language values to Standard English lang. I have values in a single Column (No fixed number of rows/values but it will be

$$Excel-Macros$$ Using Excel to Control Shapes Drawn In A Workbook

2010-07-12 Thread StructEng81
Dear Excel Experts, A former professor of mine had a series of Excel spreadsheets that he used to calculate properties of structural elements. Within these spreadsheets he drew shapes (such as rectangles, circles, triangles, etc..) using Excel's shapes tool. He would then enter in data (suc

Re: $$Excel-Macros$$ Re: excel tutorial book

2010-07-12 Thread Nikhil Shah
Hi Rajendra Soni, Wow Great Help for sending Excel URL Nikhil Shah On Mon, Jul 12, 2010 at 10:04 AM, Soni.Rajender wrote: > Hi > > Please find below the link for MS Excel resources. > > > http://www.google.co.in/search?tbs=bks%3A1&tbo=1&q=ms+excel&btnG=Search+Books > > > Regards > Rajender

Re: $$Excel-Macros$$ Urgent Need help how used macro in excel

2010-07-12 Thread Soni.Rajender
http://www.familycomputerclub.com/excel/excel2003_macros.html On Jul 12, 11:39 am, prabhakar thakur wrote: > Can Help me. > > Thanks, > Prabhakar Thakur > New Delhi > +919953736776 > > On Sun, Jul 11, 2010 at 10:03 PM, prabhakar thakur < > > > > prabhakarthak...@gmail.com> wrote: > > Hi All, > >

$$Excel-Macros$$ Urgent - MS Excel charts

2010-07-12 Thread Rajender Soni
Hi I have product category in column A, Product code in column B, and their prices in Column C, now I want to make a chart showing the products which comes under the price category of 0 to 27, 27-32 and accordingly, pls let me know how to show the same data in chart format, using different colors

$$Excel-Macros$$ Re: how to copy 1 file column to another file column automatically

2010-07-12 Thread George
Hi Ankit, You can run this code and enjoy. Sub Macro1() Columns("A:A").Select Selection.Copy Windows("as.xls").Activate Columns("B:B").Select ActiveSheet.Paste Windows("a.xls").Activate Columns("C:C").Select Application.CutCopyMode = False Selection.Copy W

Re: $$Excel-Macros$$ Urgent Need help how used macro in excel

2010-07-12 Thread prabhakar thakur
Can Help me. Thanks, Prabhakar Thakur New Delhi +919953736776 On Sun, Jul 11, 2010 at 10:03 PM, prabhakar thakur < prabhakarthak...@gmail.com> wrote: > Hi All, > > Please Help me > > On 7/10/10, prabhakar thakur wrote: > > Dear All, > >I have urgent need Help how macro & V