|
|
Excel external data import query by
Craig
I have a query that imports data from an Access database, this works fine but when I import the data the headings are imported too, how do I import the data...
|
|
1 |
426 |
|
|
Last day of the Month??? by
ExcelDummie
I am creating a timesheet and i have inserted the first day of the month with a combo box to a linked cell A7 then in the rest of the column i add 1 to A7 then...
|
|
1 |
163 |
|
|
|
|
3 |
140 |
|
|
Conditional cell color. by
geza
I have used conditional formatting before in order to change the shading of a cell based on the cell value. However, I would like to do the same except have...
|
July 2nd, 2004 02:39 AM
by geza
|
3 |
217 |
|
|
Database trouble -- please, please help by
Ginger Hoffman
For the past six weeks we've been entering data for a very
large survey. We used Excel with data validation codes to
perform this function -- every field has...
|
|
7 |
319 |
|
|
|
|
11 |
245 |
|
|
Run conditional macros by
Ander
Hi,
I wonder if there is a way to run macros conditionally (using the IF
function).
For example, if the value of cell A1 is "up" run the macro "go up" and
if...
|
|
4 |
147 |
|
|
Run-time error '1004' by
Dkline
If I open any Excel file by double-clicking on the file in Windows Explorer
when Excel is NOT already running, I get a Microsoft Visual Basic error:
"Run-time...
|
|
1 |
190 |
|
|
Can't find the link!! by
AdamM
I am on a network and have problems with some files that have been
crashing. All I do is open the file and press Ctrl C (Copy) and excel
closes on me. Error...
|
|
1 |
253 |
|
|
|
|
1 |
370 |
|
|
I really need help with this one by
Lee
All of a sudden, I could no longer open my excel
spreadsheet. I get the message "The File may be read-
only, or you may be trying to access a read...
|
|
4 |
168 |
|
|
Combo box dates 36646??? by
ExcelDummie
Im using a combo box that uses a date list
Problem One how do i change the format so it actually displays the dates in the list and not the excel codes for the...
|
|
1 |
177 |
|
|
|
|
2 |
453 |
|
|
Removing automatic links by
Joey
Hi all
I cut columns from one work book and pasted it in another. Now when I
open it, a prompt states that it has automatic links and to either
click yes or...
|
|
3 |
201 |
|
|
sorting numbers by
gregork
On Sheet 1- Column A, I have a list of order numbers. The same order number
can be listed many times. On Sheet 2 -Column A, I want to I want to copy all
of the...
|
July 2nd, 2004 12:07 AM
by JohnT
|
8 |
238 |
|
|
Commenting on comments by
Hari
Hi,
I have a sheet in which some of the cells are protected and some are left
unlocked so that those cells could be edited.
I have some comments in the...
|
|
8 |
604 |
|
|
Restore button by
George Randall
I have a client with an Excel 97 problem. When she clicks
the Restore Window button, the window appears to
minimize. Left clicking the icon on the task bar...
|
|
3 |
652 |
|
|
assigning macro to a button by
Kelly
all the help says right click on the button and select assign macro. When I right click on a button that is not an option. I am using office 2003. has this...
|
|
2 |
456 |
|
|
Wrap text cuts off on print by
Circe
User has a cell with alot of text in it.
User is wrapping text
Text is cut off when printed
Office XP, Excel2002
Are there additional text functions to try to...
|
|
2 |
548 |
|
|
Hyper lInks by
vallury
Hello All!
I do have one excel spreadsheet with text like www.yahoo.com
www.excelforum.com and so on.
Is there a way that I select all the cells and make...
|
|
2 |
486 |