Programming

Comparing two worksheets
I need to compare two worksheets to derive the accurals of purchas orders and invoices. I can find the lines and copy them if they are actually in just one of the worksheest. My problem is that I am searching for invoice numbers whiere the same number can appear more than once on both worksheets and in some ins... 27 Apr 2010 06:33

is it possible to run code written inside a cell
Is it possible to run code written inside a cell, for example, cell A1 I wrote MsgBox "Hi i am David" When I run the code it has show the message Hi i am David or else order written in A1 any help appreciated in advance. thanks ... 27 Apr 2010 05:26

Combination to Two formulas with the Help of AND / OR / IF Functio
Copy paste the below and apply to the cell.... =IF(D7="V Top 9702045619",AccountWiseReport!K5-F7+I7-J7+K7-G7-H7, IF(D7="V Top 9702043906",AccountWiseReport!K40-F7+I7-J7+K7-G7-H7,"")) -- Jacob (MVP - Excel) "Akash" wrote: Hi, This is Akash Maheshwari, a frequent user of your group. I had querry... 27 Apr 2010 03:14

Combination to Two formulas with the Help of AND / OR / IF Functions
Hi, This is Akash Maheshwari, a frequent user of your group. I had querry which i m not able to break through since last few days: I have two Formulas: =IF(D7="V Top 9702045619",AccountWiseReport!K5-F7+I7-J7+K7-G7-H7) =IF(D7="V Top 9702043906",AccountWiseReport!K40-F7+I7-J7+K7-G7-H7) What i want is if i sel... 27 Apr 2010 02:09

Search multiple columns
I was try to get the rows that matches below criteria, to sheet 'Search' 'Test' in column F of Sheet 'Data' and 'Final' in column J of Sheet 'Data' and date less than 3 months which should be taken from column I Sheet 'Data' Can anyone help me on this please..? ... 27 Apr 2010 01:04

Combo Box question
I have a list of dates that has several of the same date, however they are in chronological order, named DateList. A combo box in a userform displays these with the UserForm_Initialize event: For each c in Range("DateList") If c <> c.Offset(-1, 0) Then Me.cBoxDates.AddItem Format(c, "m/d/yyyy") En... 27 Apr 2010 14:30

moved macros to new book, now not working
I thought I posted this problem last night, but I can't find it anywhere. My apologies if I've posted it twice. I moved some macros to a new workbook, so they could be shared amongst multiple workbooks. In order to run the code in the new location, I changed the worksheet_activate sub in the originating sheet ... 26 Apr 2010 21:45

Worksheets and Events
I have a workbook that has multiple worksheets - all sharing the same code in the workbook, worksheets, module, and class module. When I process events on the first worksheet everthing works correctly. When I move to the other worksheets, everything works fine. When I move back to the first worksheet again... 26 Apr 2010 23:58

Print all open files
I have a macro that opens selected files. I would like to add a macro to print them also, but I need to look at them before printing. Basically I need a way to change to next workbook. Is there a command for that or a loop that prints and closes? ... 26 Apr 2010 18:22

Autofilter question
I have an autofilter with a column of data that includes operators such as > and <. For example, one of the records would read "> 60 days past due" How would I go about coding the criteria to show the records that display "> 60 days past due"? Thanks, Chad ... 27 Apr 2010 12:12