I have several workbooks that are linked to each other over a different servers, Unfortunately, when I open the Main xls, I am receiving error. See Attached file.
I need to have the links ...
I can't remember how to do this, and I don't have access to ther Name manager add-in where I'm working right now. I need to have the name "BeginList" on every sheet in my workbook.
Thnaks!
John
I have a userform that employees can use to enter information into a spreadsheet. I would like to have a button that would erase the last entry that they made in case they made a mistake in e...
I am working with 2 worksheets within a workbook.
The following relates to SHEET1 of this workbook:
There are over 3,000 records that I am working with.
However, I will show an example of ...
If we have the data as in the code snippet.
How can I get the same calculation result done in D1 as in E1 ?
The macros contained in sheets "current year" and "average year" are sorting from smallest to biggest could i get them to sort largest to smallest?
My workbook is set to the StartUp Prompt of "Don't display the alert, and update links" and it does not work. Consistently asks the user if they want to update. I put the VBA statement as ...
Hi Experts
How can Active X Controls in an Excel worksheet be tabbed through in order?
i have some textboxes and combo boxes.
Thanks
I have a workbook with 100 worksheets. All worksheets have the same template design. Cell A1 of each worksheet says either "A" or "B". I need a macro that would allow me to first print only wo...
Hey Everyone,
I am trying to use the attached code to send an email from an Excel WB. The information for the email is contained in cells A1:E5, but I got type mismatch errors when I tried t...
On one sheet I have a list of about 20k item #'s
AS5300
AS5300-120VOIP-A
AS5300-96VOIP-A
AS5301
On another sheet I have a list of around 20,000 URLs
http://domain.com/products/Cisc...
I imported data from a notepad, and when I insert a filter, it picks up a-s and does not include t-z. I tried a copy and paste special for the column but it still didn't work. Any suggestions?
I have a few specific operations that I need a macro to accomplish and I hope that someone will be able to assist, please.
Description: I have a workbook with 50 worksheets and 4 columns o...
Hi
I have 6 worksheets in a workbook - A,B,C,D,E,F. What I am looking for is VBA code that will insert 6 worksheets, and copy the contents of the first 6 worksheets onto the last 6; so the e...
Hi
I have the following code to delete a selection of worksheets. It works okay, but when I run it a warning sign comes up "Data may exist in the sheet(s) selected for delection. To perma...
Hi,
Check each the colum iselect and run macro to delete all comments in the colum where there is no data present.
Delete all comments in cells where there is no data in the cell.
Regar...
Hi EXperts
I have the following formula and wish to amend it to show both + and - days
formula =DATEDIF(C3,G3,"MD")&" days" at present this only works if C3 > G3 = positive days
need...
Hi Experts
How would amend the following formula to ignore the time difference when the dates are the same and not show it as a difference:
formula =IF(C13=G13,"OK","Different")
say i...
Hi,
I have a txt file of just under 3000 email addresses that are tab delimited.
How do I import these into Excel as ONE COLUMN
Using the general import, they import as one email addr...
Need a vlookup formulae in column F which can seek values under array A1:B4, for matched items under column E
Format would be above and not changed.
In essence, require a vlookup formulae wh...
I've heard that Excel was going to be available online, served up as a web app with a per use charge rather than purchasing and installing the software. Is this happening now or anytime soon?
Webtubbs provided some code for me which was great however I now need to make it use a variable instead but keep getting errors
Webtubbs' original code was
Sub ClearCells()
Dim fnd A...
Hello Experts. I am using this code that I found on the site to add a custom toolbar. Is it possible to have a text label without an onclick event in the toolbar that I could use as a name. ...
I have a cell that I want to display only the text after the identification code. 12345 Other Fruits and Vegetables. I can get the code using the left function in Excel, but how to I extract t...
I have some data in Column A on Sheet 1 which I want to put into a simple list in sheet 2. The data however is in Cell A1, A14, A27, A40.....etc which I then want to transpose to simply fill ...
