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
reading wdb file with excel by JennaLyan
someone e-mailed me a wdb file that was created in Microsoft Works. Can I import or convert it to be displayed in Excel? PLEASE HELP!!! Thank you
June 15th, 2004 07:37 PM
by hglamy Go to last post
2 465
Lookup based on list of names by tojo107
I need to import a file everyday that looks like this, but there are 250 people listed. I want to be able to enter a formula that will look for just my team...
June 15th, 2004 07:30 PM
by Cesar Zapata Go to last post
1 421
automating function change by leeners82
I'm wondering if there is a way to alter a function so that each month, a reference in a function changes. More specifically, in this case, every month the...
June 15th, 2004 07:15 PM
by Frank Kabel Go to last post
3 380
Validation? by seftonbarn
I need some help. For arguments sake my worksheet has only one column. In row 1 is a Y/N field. If the user enters "N" in row 1 I want the cell in row 2 to...
June 15th, 2004 07:14 PM
by Cesar Zapata Go to last post
2 448
Save As using contents of Cell in Name by NickMinUK
Can someone help with code that changes the "save As" file name to a combination of the original File Name + the contents of a cell, and saves file in same...
June 15th, 2004 07:14 PM
by Frank Kabel Go to last post
1 335
Hyperlink by Nick
Does anyone know why I cant insert a hyperlink in a shared worksheet?
June 15th, 2004 07:12 PM
by Frank Kabel Go to last post
1 362
Emergency! Sort Issues by Sam
I sorted a list in excel - - ascending. Now, I need it to go back to its original order. I did not save a copy before doing this, ugh! There does not seem...
June 15th, 2004 06:59 PM
by Tushar Mehta Go to last post
3 364
replace N/A with blank by leeners82
I need to create a vlookup function where the following occur: 1) the function looks for a number in the worksheet and if that cell is blank the cell with the...
June 15th, 2004 06:54 PM
by Tushar Mehta Go to last post
2 349
Solver query by Damien
I'm trying to use the Solver to solve a problem for me, but even though I've set binary constraints on the changing cells (ie I want them to be 1 or 0), the...
June 15th, 2004 06:49 PM
by Tushar Mehta Go to last post
1 344
Excel Spreadsheets by Karen Decker
I have several spreadsheets that are in separate files. (I need them to be in separate files.) If I have the same change to all of the spreadsheets, is there...
June 15th, 2004 06:42 PM
by Frank Kabel Go to last post
1 475
Problem with duplicate entries after sorting by Reems
I have a problem that has stumped me and I was hoping someone could help me out. I have data in rows 2 through 15 with a header row and then blank rows until...
June 15th, 2004 06:08 PM
by Reems Go to last post
1 525
Format will not save! by Fred
Win98SE and WinXP using Excel 2000. I have a CSV file (audit trail from Sage Accts) which will not allow me to change the format in three particular cells. ...
June 15th, 2004 06:02 PM
by Fred Go to last post
2 798
Auto Sum + Conditional Formatting by BenJAMMIN
I would like to take one cell and have it with the Auto Sum feature. Here's the catch: I have applied a simple Conditional Formatting to a number of cells. The...
June 15th, 2004 05:29 PM
by Andy B Go to last post
6 646
align numbers with comma and center within column by AndiB
Thank you both for your assistance. I found that the ???,??0 format worked best for what I needed to accomplish. I really appreciate your taking the time to...
June 15th, 2004 05:18 PM
by AndiB Go to last post
0 564
MIN with a condition by Sarah
I am having no luck writing a formula that will return the MIN value from column B when column A = "Admin". Example data: A B Admin 5 Mktg ...
June 15th, 2004 04:53 PM
by Andy B Go to last post
1 366
generalized macros by vishu
i tried to write a macro for changingthe way the columns are placed on the excel sheet,but i am not able to make it generalized for every sheet is use . Can...
June 15th, 2004 04:27 PM
by Gord Dibben Go to last post
1 381
How to Not Minmize Access Window When I Go to Excel by JB
Hello, I run the same query on a database but with different dates for each run. After each run I key-in the results to an excel spreadsheet. This works fine....
June 15th, 2004 04:10 PM
by JB Go to last post
2 672
hour sum setup by andy
i am currently trying to write an automated wage sheet for my temporary workers. i have finished the sheets and most of the formulas, however i am stuck. if...
June 15th, 2004 04:05 PM
by Andy B Go to last post
1 412
How can I put these 2 VBA codes Together? by rdvance
Sub ClickFirst() With ActiveSheet.Buttons(Application.Caller).TopLeftCell If .Column 8 Then Cells(.Row - 6, .Column - 8).Select End With End Sub Sub...
June 15th, 2004 03:06 PM
by Chip Pearson Go to last post
1 368
Excel Query by Lesley
Hello, I have a list of around 50 values of which around 40 of them make up a specific value. Is there a way that I can find which cells make up this...
June 15th, 2004 02:25 PM
by jeff Go to last post
1 358
Post New Thread


Display Options
Showing threads 139581 to 139600 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 02:22 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.