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
Excel formula question - nested VLOOKUP? by brightshadow
So far, I have a VLOOKUP function that searches another sheet and pulls the data from a cell matching a name located in row 4 of the same column, and converts...
June 30th, 2004 10:12 PM
by AlfD Go to last post
4 114
Currency Symbol Problem - Costa Rican Colon by SteveT
When I attempt to format my column of numbers using the format cell, currency feature , I select Spanish Costa Rican Colon which shows in the drop down box as...
June 30th, 2004 09:50 PM
by SteveT Go to last post
0 254
Imported Datasource seems to be caching - need to pull updated dat by KAT
In Excel I imported data from the Oracle db specifically Toad. This datasource gets updated on a daily basis and I need to pull in the latest data each day in...
June 30th, 2004 09:42 PM
by jeff Go to last post
1 161
Format Number by Becky
I have numbers that import into Excel and they come in with the General format. Example: 34350 The number is actually the amount of a check for $343.50 I...
June 30th, 2004 08:37 PM
by Becky Go to last post
2 153
Setting Tab Order by Shawn
I want to control the cells I navigate to when pressing the tab key. I have protected the worksheet and some cells are locked, which are being skipped as I...
June 30th, 2004 07:09 PM
by RagDyer Go to last post
1 106
QUESTIONS ANSWERED by [email protected]
What really causes crop circles? Can a full moon really cause people to act strangely? How does mint make your mouth cool? ALL Questions n More Answered Here ...
June 30th, 2004 07:03 PM
by [email protected] Go to last post
0 184
Automatically Fill In Pirces by Denise
I am wanting to set up a spread sheet to track charges that are lost monthly. I will be entering a product number from charge stickers that are found in the...
June 30th, 2004 06:24 PM
by Arvi Laanemets Go to last post
1 90
Keep my A column visible by webbynet
Hi, I am trying to keep the A column visible while i scroll right through the columns. I need to be able to see column A. I have tried freeze but having some...
June 30th, 2004 05:49 PM
by Gord Dibben Go to last post
3 86
Automatically deleting duplicate rows?? by Ritchie Jones
Hello, I have searched through the help but couldnt find out how you can delete duplicate rows in an Excel spreadsheet without having to manually go through...
June 30th, 2004 05:47 PM
by Gord Dibben Go to last post
3 169
Numbering Add-In by Carolin Devaney
I have a purchase order template I created with Excel 97 which includes an automatic counter field to give each PO its unique ID number. When I try to open...
June 30th, 2004 05:45 PM
by Gord Dibben Go to last post
2 188
How to create a digital certificate... by hermes
so that I can use it to locally sign my office files (word and excel). I do not want to continue to be prompted to enable or disable macros for each of my...
June 30th, 2004 05:16 PM
by routeram Go to last post
8 119
saving worksheets as individual files by Paul Mendez
I have a workbook with over 250 worksheets. I would like to separate the workbook into individual worksheets. What I mean is that I would each worksheet to...
June 30th, 2004 04:06 PM
by Paul Mendez Go to last post
3 135
Deleting a Folder by BillCPA
I want to use a macro to do a backup to CD. I am using .FolderExists, .DeleteFolder, .CreateFolder, and .CopyFolder. The folder I am copying to is on the...
June 30th, 2004 04:01 PM
by BillCPA Go to last post
2 87
Decimal separator from Excel 2000 by freeposte
Hi there I'm running under Windows XP using Excel 200 from the Pack Office 2000. I'm wonder how could I change ciffer decimal separator on Excel 2000. On...
June 30th, 2004 03:49 PM
by Bernard Liengme Go to last post
1 408
2 differenct decimal options for same cell results by cp
I am trying to have the result of one cell show 2 decimals when the result is in liters and no decimals when the result is in fluid ounces. Is there a way...
June 30th, 2004 03:08 PM
by cp Go to last post
9 225
Sorting more than 3 pieces of data?? by StargateFanFromWork
Wow, I've _never_ had this happen before. I have a spreadsheet that has 4 columns, 3 that are often extremely similar. It's the 4th one that has the most...
June 30th, 2004 02:50 PM
by StargateFanFromWork Go to last post
7 86
Pasting a value into multiple cell addresses by hmws
I have a range of cells (a3,c3,e3,a12,c12 etc) containing variable cell references. I would like to be able to go to/lookup a Target Worksheet and enter the...
June 30th, 2004 01:55 PM
by Bernie Deitrick Go to last post
8 94
Multiple sheets sharing variable data by x65140
Sheet1, Column A contains variable data entered. (Red, Blue, Green, Blue, Green, Red, Green Red, Blue) When the data is entered into Sheet1, I want it to...
June 30th, 2004 12:00 PM
by x65140 Go to last post
2 68
How do I calculate cubed roots in Excel. by Gordon Reid
Square Root is calculated using the function SQRT, but there does not appear to be one for cubed root. Many thanks, -- Gordon Reid
June 30th, 2004 12:00 PM
by garfield-n-odie Go to last post
2 118
Formatting entries in userform textbox by RobG
I'm using a userform for enter dates and times into a worksheet. is there a way of formatting the data as it's input like in an Access form? or is there a way...
June 30th, 2004 10:49 AM
by Jamie Collins Go to last post
7 148
Post New Thread


Display Options
Showing threads 138761 to 138780 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 07:51 AM.


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