Question about Microsoft Office Excel 2003 for PC
I'm trying to manage a database I work with easier. I was hoping to use a macro to make things easier but i've not used them before. What i want to do i select all the data in one sheet (minus the headers) and then insert the values (not formula) into another sheet already containing some data. This will create some duplicates and some new and leave some old without duplicates. What i want to do is update all the new duplicated with the 'note' (for a certain colum) of the old one. and then delete the old duplicate leaving the new one with the notes. Also want it to input NEW in the notes colum for rows that arn't duplicates. Hope that all makes sense. Can anyone help?
Go google and type in--- user manual for excel---
there is a pdf version about 900 pages long that explains everything you want to know and do in excel
Posted on Mar 27, 2017
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
You can set a default value in most form items under the properties of that item. Look for "value". You can also do this in code, by setting up a sub routine to set/reset the values on your form. Then just run the sub routine before you open or enter the form.
Private Sub resetForm()
'formname.itemname = value
UserForm1.Label1 = "Hello World"
For the second one you have a couple of options, you can find the bottom on the data and store the row index in a variable, use a loop to find the next empty cell in a row, and store the value or you can use the current region method to select all the cells with data continously touching the selected range. Example below
numberOfRows = Sheet1.Range("A1").CurrentRegion.Rows.Count
Posted on Jul 19, 2008
Tips for a great answer:
May 28, 2012 | Microsoft Word 2010
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
Uses the same basic
XML format as the Excel Workbook, but can store VBA macro code. Users saving
an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in
Excel 4.0) are prompted to use this file format.
The default file
format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro
sheets (.xlm files in Excel 4.0).
Can contain a
VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0).
Workbooks created from this template inherit the VBAProject part or Excel 4.0
macro sheets that exist in the template.
program that runs additional code. Excel add-ins use the Open XML file format
to store data, and they support using VBA projects and Excel 4.0 macro
Feb 21, 2011 | Computers & Internet
Oct 29, 2010 | Computers & Internet
Apr 08, 2010 | Microsoft Office Excel 2007
Jan 14, 2010 | Computers & Internet
Sep 23, 2009 | Microsoft Office Excel 2003 for PC
Aug 18, 2008 | Microsoft Excel for PC
May 06, 2008 | Microsoft Excel for PC
Jan 28, 2008 | Computers & Internet
Jan 26, 2008 | Computers & Internet
Jul 31, 2017 | Microsoft Office Excel 2003 for PC
Apr 13, 2017 | Microsoft Office Excel 2003 for PC
146 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: