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 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 278
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 296
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 277
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,131
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 262
Timetable by Jake[_6_]
I have a timetable for a multi day journey train, and I need to calculate the time to each next stop in hh:mm in column G. In column A is the station name,...
August 13th 11 05:17 PM
by Jake[_6_] Go to last post
7 300
Need help with formating cell by Bandit
I have a very simple worksheet with formulas. Here is what I have: ColumnB ColumnC ColumnD Sales Amt Sales Return ...
August 12th 11 06:16 PM
by Vee Sue Go to last post
4 477
Ctrl+Click doesn't select non contiguous cells by Rafeek
When I Ctrl+Click on non-contiguous cells, it doesn't select them. I couldn't find any settings in Excel Options. Please help. Thanks in advance ahmed.
August 12th 11 02:33 PM
by Rafeek Go to last post
0 326
Excel 2007: mouse cant find cell handle to drag/move by Carl Henthorn
I am using Office 2007 sp1, and I find myself not being able to move/drag a cell around inside Excel. Normally I would enter some data in a cell, then find...
August 12th 11 11:13 AM
by sagar aggarwal Go to last post
3 7,475
Formula Quesion by JimS
I have the following formula in cell AR12: {=SUM(INDIRECT("ar"&LARGE((AR14:AR10000<>"")*ROW(14:10000),14)&":ar10000"))} It works exactly as I would like,...
August 11th 11 03:28 PM
by GS[_2_] Go to last post
5 278
Formula to display next Friday from B1 works except on the Friday itself. by StargateFan[_2_]
I found a formula for displaying the next Friday from the user input date in B1. It works great except if the input date is a Friday. I need a spreadsheet...
August 11th 11 09:20 AM
by StargateFan Go to last post
4 394
Copying a range of data without adjusting formulas by Captain Jack Flak
I often have to create several versions of a report that summarizes data in slightly different ways. It is easiest to do this by copying an existing form to...
(Multi-page thread 1 2)
August 11th 11 08:51 AM
by Olivier Beaujean Go to last post
18 994
How smart is excel? by Anthony[_5_]
I do roster assignments for a youth flag football league. The league has grown to over 1500 kids so doing team assignments manually has gotten to be a bit of...
August 10th 11 09:46 PM
by Anthony[_5_] Go to last post
0 230
Reversed Array by [email protected]
Hi - I'm trying to use LINEST to create an automated, rolling multiple regression. In otherwords, rather than use the Analysis Toolpak over and over again to...
(Multi-page thread 1 2)
August 9th 11 08:21 PM
by Travis Go to last post
10 820
how can you calculate trend line formula values for power series by newby
can use LINEST for linear trendlines, LOGEST for Exp. trendlines, but Ican't see how to get values for Power series trendlines. Anybody help
August 9th 11 08:16 PM
by Travis Go to last post
1 2,074
Big Bertha Thing proton by Tony Lance
Big Bertha Thing proton Cosmic Ray Series Possible Real World System Constructs http://www.bigberthathing.com/proton.html Access page JPG 55K...
August 9th 11 05:53 PM
by Tony Lance Go to last post
0 301
excel and searching for a string in a cell where comments have been added by sammy[_2_]
Appreciate if someone can advise how to search for words in the comment section of a cell in a sheet or workbook thanks Sammy
August 7th 11 12:23 PM
by Dave Peterson[_2_] Go to last post
1 237
Possible Indirect query by Fred[_8_]
I have a Validation list that contains a list of worksheets in my workbook. On a front sheet (in E4) I want to use this list to pick a sheet and then have the...
August 4th 11 09:24 PM
by Gord Go to last post
1 385
Excel Macro by Eddie O'Shea
A friend has entered a long list of amounts in a column in Excel 2003. Unfortunately, he entered the figures as set out below and Excel thinks the numbers...
August 4th 11 08:16 PM
by Eddie O'Shea Go to last post
5 311
Excel Signatures by Josh
I know that you can create digital signatures in excel but I have only been able to come across the signatures that are used with the signature line. I was...
August 2nd 11 11:20 AM
by martincrow Go to last post
1 1,512
Post New Thread


Display Options
Showing threads 2001 to 2020 of 146447
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 10:02 PM.


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