Hello Experts,
Happy Easter to you all.
I have the data that is spread over 2 rows (maximum 3 rows) and would like it merged into 1. As you can witness from the attached file, each contr...
I am using a wireless hp keyboard. The problem is with Excel 2003 I can 't use:
F4 to repeat the previous function
F2 to edit the cell.
How can I turn on these options on my keyboa...
User is getting information in this format information are in one column and space (2 or 3 row) between each set of information
And can be up to 50-60 sets of data
A
1
5 I am calli...
Excel Question
I have a list that I want to be able to compare to another list and then be able to highlight cells or differentiate somehow the data that is in list 1 but not in list 2.
...
I am experiencing a problem printing Excel 2003 spreadsheets in color on a networked Brother MFC9420CN color laser printer. If I choose more than 1 copy, copy 2 and on do not print the color ...
I have a list of numbers in column A. I have a list of numbers in column B. I want column B to look at column A. If a number in column B is found in column A, then it is deleted. The rest of t...
Hello,
I have an excel table in a worksheet named "Domestic&Foreign" with customer accounts and their purchase amounts. Customer accounts are on column F, purchase amounts are on column Q.
...
I have a macro that copies and pastespecial into Word, and I believe that my macro is missing something. I want the pastespecial function to keep the formatting and colored cells setup in Exc...
All I need to do is Truncate or Delete all the rows in an Access table which needs to be executed in an Excel MACRO. PLEASE HELP!!
I have formulas in the following range of cells in Excel: 1A:1K.
How do I make it so that if a formula does not exist in a cell in the above range cell 1L will display. "Formula Missing"
I have a workbook that is scheduled to run using MS Scheduled tasks. The code is inside this Workbook open and the file has digital signatures so no pop ups come up.
My problem is when I wan...
Last year, I managed to add a combo box to sheet1 in cell D2 with the items read from three cells as shown below:
[Blank] <-- entered to cell A101
Yes <-- ente...
I want to do a vlookup. However, in column A of worksheet 'gross & net sales' are numbers stored as texts rather than numbers. In order for the vlookup to work, I would have to convert colum...
I used excel alot. I sometimes find myself with 4 or more excel speadsheets open. When this happens all I see on the taskbar buttons is "Microsoft Excel" since the filename is off the viewab...
Hello experts! I am not new to VBA but I am a novice in Excel VBA programming. I am looking for VBA coding that will look for words that are from one (1) to five (5) characters long in a strin...
How might I use some VBA method to let the user select a directory and capture the selected directory path?
Any way to show/hide a command button?
When I "Save As" in Excel and Word 2007, the Windows Installer screen pops up and flickers really fast and then disappears. I am running Office 07 SP1. What could cause that to happen?
This a...
When opening Excel 2003, I get a message stating that it is reconfiguring, please wait. Does anyone know how to get rid of this?
Hello all,
I'm running a Perl script to generate a table of data and then outputting it over the web as a .csv file. On most PC's this causes Ms-Excel to be launched and auto-parse the fil...
I would like to send a text message to a cell phone from excel. The I would be notified by cell phone text when the value in a cell exceeds a certain level. I am using excel 2003
Hello,
Please help me check 4 consecutive cells in one column whether they are blank and have the same content so I can concatenate the contents of their adjacent cells in one cell , in a t...
Requirement 1:
I have developed an Excel Add-in.Whenever I install the addin in the excel workbook a toolbar is opened.
The code to open the toolBar is written in WorkBook_Open() method of w...
I've got an Issue Log at my small office, and would like to recieve an email when someone posts something into the log. I've currently got the Log set-up as an MS Excel file. This will only be...
the valude in i10 is a date value it will be either a 1 or a 16. what I need to do is clear all of the cells from e14 to r24 to blank without removing the formulas in the cells when i change ...
