A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
i just need to make a sheet for Ticket # and name with who sold i. by maryalkire
trying to make a spreadsheet for a simple checklist when passing out our fundraisers. i need the ticket # (from 1-1007) and name with who sold it and at...
November 9th, 2009 11:50 PM
by Gord Dibben Go to last post
2 166
cell to stay same by Pammy
If I enter a 2 in a cell, I want it to always show as a -2. Anytime I type 2, if comes in as -2. Is there a way to do this?
November 9th, 2009 11:41 PM
by Gord Dibben Go to last post
2 164
Importing pdf files to microsoft excel by Laura
Does anyone know how I could import a pdf file into microsoft excel and be able to edit it?
November 9th, 2009 11:08 PM
by Bill Sharpe Go to last post
2 167
Importing Access database into Excel 2007 by confused_student[_2_]
I'm having difficulty with Excel recognizing information from an Access database that's been imported and added to an existing Excel 2007 table. Excel...
November 9th, 2009 11:02 PM
by Bill Sharpe Go to last post
1 139
Deriving winners from a list by Harold
I have an excel worksheet where one column is a list of names and the next column either has the word "winner" or "loser". There is only one "winner", so...
November 9th, 2009 11:00 PM
by John Go to last post
4 143
Turn off prompts by Keith
I have an excel spreadsheet that will run a query on the database, when open. The first time I ran it, a pop up window displayed about enable/disable query,...
November 9th, 2009 10:48 PM
by Sean Timmons Go to last post
1 143
searching for text and returning information by Doug
I have columns A thru G in file 1. In file 2, I want to search column "G" in file 1 and find either El Salvador or EDP_SIGMA(pertains to El Salvador) and...
November 9th, 2009 08:49 PM
by Doug Go to last post
0 132
ToggleButton to Unprotect/Protect all worksheets by Kellascat
I need to create a toggle button that will unprotect and then protect all worksheets, while allowing users to select unlocked cells. I tried cobbling a few...
November 9th, 2009 08:30 PM
by Kellascat Go to last post
0 143
Collating multiple .csv files into a single work book by Mr_Wilf[_2_]
I’m trying to collate three differently formatted .csv files into one workbook. But in order to get the latest data in my master document I still have to...
November 9th, 2009 08:21 PM
by Ron de Bruin Go to last post
9 181
Pulling Data from other excel workbooks? by Frustrated
I need a little help. I need to pull data from one excel workbook (A) and display the data on another excel workbook (B) but i only want to pull the date if...
November 9th, 2009 08:19 PM
by Frustrated Go to last post
5 193
How to store a connection with parameters into a workbook by Tom Edelbrok
Using MS Query and Excel 97 I was able to build a connection to a SQL server, include parameters (ie: for the 'start date' and 'end date'), and save the...
November 9th, 2009 08:16 PM
by Tom Edelbrok Go to last post
0 142
Sharing or Emailing Macro by AJOLSON
I have a macro in Excel that I want to emial or have another user import into their excel spreadsheet. How do I do this?
November 9th, 2009 08:13 PM
by Gord Dibben Go to last post
1 132
relative defined name references? by Gant
I'm trying to copy an excel template that has naming references included. Is there a way to copy the template to a new worksheet within the existing...
November 9th, 2009 08:11 PM
by Gord Dibben Go to last post
1 150
Calculating acruing interest by DRKENNE
I'm looking for a formula (simple I hope) that would calculate interest that's been accruing at an annual rate of 10% on $10,500 that should have been paid...
November 9th, 2009 08:07 PM
by Joe User[_2_] Go to last post
4 160
Formula Question by Matt
I have specific status codes in Text Format in Column B of my workbook. I'm wanting to setup a formula that will calculate the average of one status marked...
November 9th, 2009 08:03 PM
by Bernie Deitrick Go to last post
2 116
lock not working in Excel 07 by vpinnell
Lock works on some cells in my worksheet but not on others. I complete the lock of the cells and protect the worksheet but the lock is not working. The cells...
November 9th, 2009 07:53 PM
by vpinnell Go to last post
0 124
Is there an AVERAGEIF function in excel? by lisab
I'm trying to average the values in one column if another column's value is true. I know there is a sumif and a countif, but couldn not find an averageif....
November 9th, 2009 07:46 PM
by Luke M Go to last post
5 141
How can I attach an explanatory note to a data cell? by Grant
So, I have data cells in an Excel spreadsheet. The row has a heading, like "misc house expenses", but I want to be able to know specifically why I had a...
November 9th, 2009 07:39 PM
by Dave Peterson Go to last post
4 148
Need V-Lookup to Return A Row, Not Just Single Value by PeteT.
I have a spreadsheet with about 50 columns and up to several hundred rows with column A containing the Team Name. I have a simple table setup with each of...
November 9th, 2009 07:36 PM
by Dave Peterson Go to last post
2 126
VBA filter ? by Mike
So I am trying to create a macro that filters a list and paste the filtered results into different tabs for certain groups I am filtering. Some months...
November 9th, 2009 07:28 PM
by Jim Thomlinson Go to last post
1 140
Post New Thread


Display Options
Showing threads 10281 to 10300 of 139764
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 Off
HTML code is Off
Forum Jump


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


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