Search results for query: *

I am matching data in cells on different worksheets in the same workbook. When the data matches I copy some data from sheet 1 to sheet 2. If they do not match I insert a string where the data would have gone on sheet 2. In many cases there will be multiple records with the same unmatchable data...

I am trying to create my first query using MS Query. I can not understand the instructions in Excel Helpnor can I find an explaination of this error. Can someone tell do 1, do 2, do 3, etc. or point me to simple non-Microsoft speak instructions for using MS Query.

My Do loop will stop at a row as it is iterating through an Excel worksheet for no apparent reason. There is nothing unusual about the row where processing stops. If I delete the row and restart the processing the code will go pass the point where it stopped. It will eventually reach another...

I am trying to define where data copied from one worksheet should be placed on another. I am able to set all other variables except this one. The variable is dimensioned only in the sub where it is located. As I F8 through the sub I get a Runtime error 1004;: Method ‘Range of Object’_Global...

I am trying to define where data copied from one worksheet should be placed on another. I am able to set all other variables except this one. The variable is dimensioned only in the sub where it is located. As I F8 through the sub I get a Runtime error 1004;: Method ‘Range of Object’_Global...

I have two worksheets populated with data from different sources. They contain a common data element and the does not occur more than once in each table. There may be omissions. I compare the elements and when they match I copy some data from the first spreadsheet to the second. When they don’t...

I have to create a lot of budget spreadsheets with three levels of subtotals. The final products cannot have the buttons in the left margin that allow you to expand and contract levels. Is there a way to remove these buttons either with code or some other way?

I am trying to loop through a worksheet and calculate four (4) percentages. At the end of each loop I need to move to the next row and do the same calculations for the new row and so on. I assume that if the myRange is assigned a new value (for the next range) no changes to the functions that do...

I have a 5-page tabbed Access form. Except for one, all the controls on the form are bound to fields in the table that the form is associated with. Currently when a record is saved, all the fields on all the tabs are cleared. To reduce the user’s data entry I would like to have all the data on...