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
Viewing other worksheets in a main worksheet by Brockwood
Hi guys, I'm currently creating a calendar of events for our training centre. Each month on its own worksheet but with multiple worksheets with the same...
May 16th, 2009 05:33 AM
by TechGuy[_2_] Go to last post
5 234
how to count unique values and show each different one by mmwrites
I have a long column of ZIPS. I need a formula that will tell me which ZIPS I have and how many there are of each.
May 16th, 2009 12:11 AM
by Bernd P Go to last post
4 230
Can only open files from in Excel, not from double clicking on the by Keven
I am unsure how but one of the machines at work can not open an excel file by double clicking on it. The files open fine if you fire up Excel and then click...
May 15th, 2009 11:37 PM
by Ken Wright Go to last post
6 222
Consolidating Excel worksheets by Evil with a K[_2_]
How do you consolidate data from mutiple worksheets of the same workbook into one worksheet?
May 15th, 2009 10:56 PM
by Ron de Bruin Go to last post
1 197
Macro to automatically print & save as PDF by PaulaK
I need some help to write a macro that will automatically print a worksheet & then save it as a PDF document to a specific location on the server. The work...
May 15th, 2009 10:55 PM
by Ron de Bruin Go to last post
1 331
Validate entry based on another cell value by Dearoledad
How do I set up validation of data entry in cell B1 depending on the value entered in cell A1? Valid entries for B1 are - blank if A1 1 or N or E if...
May 15th, 2009 10:47 PM
by T. Valko Go to last post
3 233
2 variable Lookup by andrewevandc
I know how to use vlookup but on only 1 variable. I have a table with two variables, part # and count, and I want to be able to look up a 3rd variable with...
May 15th, 2009 10:36 PM
by T. Valko Go to last post
1 202
range names by Sanford Lefkowitz
I have a large number of range names such as ran1 referring to a1:a200 ran2; referring to b2:b200 down to about ran40 I want to change all of these so they go...
May 15th, 2009 10:13 PM
by Don Guillett Go to last post
1 216
Parse variable length strings by Ray
Hi - I have a data-dump that's used as the source data for a variance report. One of the fields contains a transaction date and the name of the purchaser ......
May 15th, 2009 09:49 PM
by Rick Rothstein[_2_] Go to last post
3 201
For each this, then that and that by wal50
If I drop the "X" part, the below will shade the cells I want. I just can't get the syntax for adding - ActiveCell.Offset(0, 1) = "X". I have tried...
May 15th, 2009 08:51 PM
by wal50 Go to last post
3 207
Fill in cells with an array by dgh
I have a row of numbers that I want to fill into a row only if a variable cell increments by 1. For instance: Array = 200 10 5 6 8 Variables ...
May 15th, 2009 08:42 PM
by dgh Go to last post
0 199
Copy from form to worksheet by Tony
Is it possible to copy information from a query form to the same worksheet?
May 15th, 2009 08:41 PM
by Tony Go to last post
0 191
File Size ? by Ken
Excel2003 ... I have a File approx 122mgs ... I deleted almost half of the old WorkSheets & the File size only dropped by 6mgs ... Does this make...
May 15th, 2009 08:26 PM
by Dave Peterson Go to last post
1 173
Index Match ? by Rugby Al
In my worksheet I rows of values as follows in individual cells ABC 72 30 DEF 67 20 GHI 77 33 JKL 80 12 DEF 77 23 GHI 77 34 ABC 73 31 JKL 81 13 and so on.... ...
May 15th, 2009 08:25 PM
by CLR Go to last post
3 170
Insert text depending on font colour by Tricia
I have a list and was wondering how to do this: I want to insert a certain word at the beginning of the paragraph in each cell that has red font. A...
May 15th, 2009 08:15 PM
by JB Go to last post
2 197
Linking drop down lists to another list by locobo81
I am trying to create drop down lists that are dependent on the selection made from a previous drop down list. For example - My first drop down list contains...
May 15th, 2009 07:39 PM
by JB Go to last post
2 193
Alignment for a cell during an if statement. by kpt
I want the alignment for a cell to be right justified for one result of the if statement, but left justified for the other result. Any ideas?
May 15th, 2009 07:35 PM
by Sheeloo Go to last post
7 204
What is the command to replace a cell's formula with it's value? by sgeer
Without regard to paste special and the F2/F9 approach, why would there not be a function that returns the value of a cell for use in other formulas? The...
May 15th, 2009 07:26 PM
by Bernard Liengme[_2_] Go to last post
1 167
copy and paste 2900 times macro by DLB
I have 11 rows of data that I want to copy and then paste 2900 times in the same spreadsheet. Is there a macro that will perform this function?
May 15th, 2009 07:20 PM
by DLB Go to last post
2 165
clear cells when workbook is opened by Wanna Learn
Hello I want to clear some cells everytime the workbook is opened. the cells are found in a worksheet "Form" this is the code - does not do anything...
May 15th, 2009 06:54 PM
by Don Guillett Go to last post
6 185
Post New Thread


Display Options
Showing threads 20041 to 20060 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 09:02 AM.


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