A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Discussion (Misc queries) Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
How to slove: Circular Reference Warning by Rasoul Khoshravan
I made a wrong step inside my worksheet and got a "Circular Reference Warning" and all relevant cells become "Ref!" I corrected it but now whenever I open same...
August 28th 11 09:44 PM
by FSt1[_2_] Go to last post
1 565
how to calculate divisors of a number by Rasoul Khoshravan
Is there any command or macro to give the divisors of a number in Excel?
August 28th 11 05:02 AM
by Rasoul Khoshravan Go to last post
3 1,045
IP Address Validation? by GD
How do you setup a column to accept an IP address format only, i.e., 999.999.999.999?
August 28th 11 01:42 AM
by Craig Hatmaker Go to last post
8 5,981
Deleting blank rows by Rafeek
In an accounting software generated reports, there are alternate blank rows between rows that contains data. Row1: Data Row2: Blank Row3: Data Row4:...
August 27th 11 03:20 PM
by Gord Go to last post
5 400
Replace weird character by GARY
In some of the cells in my Excel spreadsheet, a small square character is displayed. When I copy and paste it here, it looks like this: " " How do I replace...
August 27th 11 11:43 AM
by Ron Rosenfeld[_2_] Go to last post
3 216
I can't open a file that is "...xls.sda" I have Windows XP by Alan C[_2_]
A client sent me an Excel spreadsheet with password protection. the file is named "...xls.sda" I cannot open it with Excel or any other program. Any...
August 27th 11 09:26 AM
by zhang yang Go to last post
2 466
help with a simple macro by Roger Dodger
Hi, I often have to set up auto filter on the first line, freeze that pane and auto width the columns. It happens so often that I recorded a macro to do it...
August 26th 11 04:26 AM
by Gord Go to last post
2 239
Why still no AUTO SAVE in Excel 2007? by THEGENE7
There seems to be no Auto Save in Excel. The Auto Recovery has not worked for any Excel program under certain conditons. I have lost and lost and lost...
August 23rd 11 01:59 PM
by James Silverton[_3_] Go to last post
8 830
Change to formula to make it go to next weekday (i.e., avoid weekend days)? by StargateFan[_2_]
I have a very specific formula that I need to keep the same. However, I need to make the output come out as a weekday at all times. How can I do this...
August 22nd 11 12:00 PM
by StargateFan Go to last post
6 376
(Please Help) Merge coloms based on equal rows with information by khers
Hi I have a sheet with this information Card# Name Surname 1 A Alast 2 B Blast 3 C Clast 4 D ...
August 22nd 11 11:37 AM
by Pete_UK[_8_] Go to last post
1 278
Unable to Insert Worksheets or Change Tab Names by koper
I worked on a workbook yesterday and added a sheet to it. One of my colleagues came in today she said one of her workbooks would not allow her to modify the...
August 21st 11 04:23 PM
by Gord Go to last post
5 1,872
Weird corruption of hyperlinks by Terry Pinnell[_2_]
I'm using Excel 2000. Somehow the hyperlinks I've created, which used to be OK, have now become oddly 'corrupted'. Take an example, an entry for which the text...
August 20th 11 12:22 PM
by Dave Peterson[_2_] Go to last post
7 313
Combining multiple workbooks by Roger Dodger
Hi All, My work platform only allows for 16 searches per file so have to process 2,3 or 4 searches and save them to CSV. We will call them Nit1, Nit2, Nit3...
August 19th 11 07:32 PM
by trip_to_tokyo[_3_] Go to last post
1 216
stopwatch times by Craig
Excel 2007 cell formating - I need to enter stopwatch testing times in minutes and seconds format. I have tried mm:ss and :ss. With both Excel wants to add...
August 18th 11 07:14 PM
by joeu2004[_2_] Go to last post
9 1,373
Columns not sorting properly. by StargateFan
I'm stumped on this one - I had it happen once before but I don't recall the fix. When I sort either manually or programmatically via a recorded script, by...
August 17th 11 06:22 AM
by StargateFan Go to last post
2 389
How to copy a range of cells and paste into a new workbook in differentcolumns by Mas[_4_]
Hi all, I have created a macro that copies and a number of columns and pastes them in a new workbook in a variety of columns but the macro look...
August 16th 11 02:57 PM
by Gord Go to last post
3 307
Line with length depending on the value of the cell by Subodh
Hi All, I want to get a line in a row of cell, lets say from in Row1. And, if the value in A1 is 1 the line should be in Cell B1 ...
August 16th 11 12:05 AM
by Don Guillett[_2_] Go to last post
3 319
Saving as XML by Gavin Bird
Hi, Building a vba module that exports timecard data from XL to a payroll system using an XML import format. Everything is OK except when the created file is...
August 15th 11 04:20 AM
by Gavin Bird Go to last post
0 296
How to lookup based in the first 3 characters of a cell by Mas[_4_]
Hi all, I would like to know how I can perform a lookup formula to lookup a column based on the first three characters of a cell. i.e. Column A - AA1-0001,...
August 14th 11 12:04 PM
by Dave Peterson[_2_] Go to last post
2 1,154
Importing data from Excel worksheet into Excel template by Mas[_3_]
Hi all, I would like advise on how I can import data from an Excel Worksheet into an Excel Template. For example: Excel Workseet Column A : Date Column B :...
August 14th 11 11:15 AM
by Mas[_4_] Go to last post
2 284
Post New Thread


Display Options
Showing threads 2001 to 2020 of 146459
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.