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 : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Dynamic pivot table linked to dynamic excel spreadsheets by FErd
Hey, Is it possible to create a dynamic pivot table (dependent) that has a relationship to multiple dynamic excel spreadsheets (source's)? Each (source)...
April 29th, 2010 10:44 PM
by FErd Go to last post
0 210
Keeping the format but update the data by JoeM
I have a report I run everyday. I want to update the data, but keep the column sizes and formatting. Any suggestions? Anybody suggest a good ebook to become...
April 29th, 2010 08:47 PM
by JoeM Go to last post
2 136
Count Text to get a Percentage by Craig
Hi, I have 12 offices and each needs to do a reporting exercise. Part of that exercise is to enter a Yes or No into a column - example would be: 'Have you...
April 29th, 2010 08:00 PM
by Craig Go to last post
4 158
date from sheet name by JBoulton
I'd like to turn a sheet name into a date. Apr28 to 4/28/10 (as a date) and Apr28-30 to Apr28-30 (as text) TIA and thanks for any ideas. Jim
(Multi-page thread 1 2 3)
April 29th, 2010 07:34 PM
by T. Valko Go to last post
21 353
April 29th, 2010 07:18 PM
by Rick Rothstein[_2_] Go to last post
1 138
ActiveX from 2003 in 2007 by Doug
Iave saved a 2003 workbook with activeX controls in 2007 as a xlm. How do I get these controls to work in the newly saved workbook?
April 29th, 2010 07:17 PM
by Doug Go to last post
0 135
SUMIF? or not? by Scott A
Hello, I have 3 columns, the first with a rating of 1-10 in each row, the second is blank and the trird has a description for the rating. When someone picks...
April 29th, 2010 07:12 PM
by JLatham Go to last post
1 146
I want to conditionally format an entire column after 1 year from by JEA[_2_]
I am trying to conditionally format a column to have the text (which are dates) to turn red/bold a year from the date in the cell. I know how to bold/red, I...
April 29th, 2010 06:55 PM
by Luke M[_4_] Go to last post
1 133
Formula issue. by LCdebaca
I am creating a formula to copy data from one cell to another and I always get the $ in my formula. I do not want to copy the same data that is in that...
April 29th, 2010 06:29 PM
by Joe User[_2_] Go to last post
2 103
SUMIF Help by Steve M
I want to sum the values in rows 2 to 100 in column G where the text in columns D or E match the text in a given cell (say F3). I would like to be able to...
April 29th, 2010 06:03 PM
by Ashish Mathur[_2_] Go to last post
3 152
using GETPIVOTDATA feature and need to keep formatting by CTTTTT
I want to copy a value from a pivot table and am combining it with text using the =(C1&" "&(Getpivotdata....)) feature. The values in the pivot table are...
April 29th, 2010 05:42 PM
by Gary Brown[_6_] Go to last post
1 133
Copy is criteria met by Kitten74
I am having trouble finding a function that will copy the data in a given row to another worksheet if one of the columns contains the word Yes. For example...
April 29th, 2010 05:35 PM
by Don Guillett[_2_] Go to last post
3 152
Copy is criteria met by Don Guillett[_2_]
Sub GETDATA() With Sheet2.Range("a1:a200") Set c = .Find(What:="FILE ID #", LookIn:=xlValues, LookAt:=xlPart, _ SearchOrder:=xlByRows,...
April 29th, 2010 05:09 PM
by Kitten74 Go to last post
2 122
Combine an And OR function by Woodi2
I have a little function that i need help with. =IF(AND($B9="Z",AE9=35,J9=1),1000). This function works fine, however I need to add in somehow that J9 could...
April 29th, 2010 05:04 PM
by Joe User[_2_] Go to last post
4 135
Excel Workbook with Multiple worksheets by Carol
I have a workbook with 3 worksheets, 1 main (total inventory), 2 sub worksheets. One of the sub worksheets tracks part #, store # and qty out, the other one...
April 29th, 2010 05:04 PM
by Carol Go to last post
2 154
dates on worksheets by Ann
I want to type the date and day (05/01/2010 Sat) on my 31 sheets. How can I type in the first day of the month and have each successive sheet advance one day...
April 29th, 2010 04:45 PM
by Gord Dibben Go to last post
5 147
colating data from a table - for bespoke report by UKMAN
Hi I have a simple 1000 row table and I am interested in only the data in the columns shown below. Proj Code Name PC01 colin PC01 fred jones
April 29th, 2010 04:25 PM
by UKMAN Go to last post
4 178
Copy is criteria met by Don Guillett[_2_]
Meant for another question -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message...
April 29th, 2010 04:20 PM
by Don Guillett[_2_] Go to last post
0 155
Dragging values down a range using a colum to determine its length by AlexJarvis
Is is possible to write a macro that drags values (or formuals) down a column to the length of an adjacent column, like when you double click on little...
April 29th, 2010 04:15 PM
by Gord Dibben Go to last post
4 142
Is there a function to solve for an unknown in an equation? by WA
For example, the equation is: P*R - (P*G) = D + (D*G) In the worksheet, each cell would have a number associated with a variable and I would like to solve...
April 29th, 2010 04:14 PM
by Bernard Liengme Go to last post
9 351
Post New Thread


Display Options
Showing threads 881 to 900 of 87787
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 04:32 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.