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
what is the best book to learn macros indepth by excel macros
pls help i want to learn excel macros fast to get the job .pls help me
April 19th, 2010 04:26 PM
by Dave Peterson Go to last post
4 261
why are my column headers numbers instead of letters? by tbecks
It seems like overnight my spreadsheets changed from having letters as column headers to having numbers. I'm sure it's something I've done wrong...can...
April 19th, 2010 04:16 PM
by Jim Thomlinson Go to last post
2 246
Add and edit a shape in VBA by Hugo Jorgensen
Hi, I have written code to add a rectangle and a line in VBA. When I run the code it sometimes works fine. If I use F8 to step through the code the code to...
April 19th, 2010 04:15 PM
by Jim Cone[_2_] Go to last post
1 263
Excel cell value equals selected text from Word by sarahphonics
Is it possible to bookmark or link a piece of text in Microsoft Word eg. a title in the word document is 'West Belfast Profile' In Excel, I would like to make...
April 19th, 2010 04:15 PM
by sarahphonics Go to last post
0 208
Excel formula by james
Hi all, looking for help with a formula, I have column G which is money recieved, ideally this should be €40 in each cell, however sometimes it is more or...
April 19th, 2010 03:46 PM
by Eduardo Go to last post
1 179
Pulling Multiple Text Strings in a One Cell by RebLan
Okay....this is what i need help on. These multiple lines in one cell is throwing me off. If i make the multiple lines appear as a single text string in one...
April 19th, 2010 03:41 PM
by RebLan Go to last post
4 271
Editing options disapear when document is changed to compatibility by Me
I have an excel (2007) document with makro content that has been edited by other people. One of them changed the document to a shared document (compatibility...
April 19th, 2010 03:14 PM
by Me Go to last post
4 241
Script to insert Row by Jeremy
How would I write a scrtip to insert a row under the number in A that holds a "NS" or "MT"? I would also like it to copy the row that has "NS" or "MT" in it...
April 19th, 2010 02:39 PM
by Mike H Go to last post
2 190
Excel custom format q by domyrat
There is one problem that needs help from experts. I got data: Cell A1: AA-BB-999-xxxxx-zz-Abcdefghij Klmno 9, PRSTUVW Cell A2: AA-BB-888-zzzzz-zz-Abcdef...
April 19th, 2010 01:11 PM
by domyrat Go to last post
3 194
How to undo overwrites? by undo overwrites
i was typing my data whereby i accidentally overwrite the new file on the existing file name...is there any way to undo that?
April 19th, 2010 12:59 PM
by Eduardo Go to last post
2 178
IFBLANK by mrtintheweb
I have a spreadsheet that has dates in. The spreadsheet needs pre-poulated boxes that are blank but will show dates once data has been input. eg: A B ...
April 19th, 2010 12:26 PM
by Jacob Skaria Go to last post
2 158
Conditioinal Formating Question by Harminder
Hi I'm trying to do a conditional format where as if two values from two different cells equal a number a letter is displayed as apposed to a colour? Thanks...
April 19th, 2010 12:15 PM
by Jacob Skaria Go to last post
2 196
Excel, custom format by domyrat
I have data entered like this : AA-BB-999-xxxxx-zz-Abcdefghij Klmno, PRSTUVW AA-BB-888-zzzzz-zz-Abcdef Ghijk, LMNOPRSTUV When i enter the data in A1, A2...
April 19th, 2010 12:11 PM
by Jacob Skaria Go to last post
5 168
How to arrange data by Amin
Hi i am about eating an inventory database for a small makeup store, however thier product are many in terms of category and group. you have the lip glosses...
April 19th, 2010 09:48 AM
by Amin Go to last post
3 205
Advanced Formula troubles by Eves
I need to do the following calculation: ((1-((1-AE5)*10))*V14) but only when: ((1-((1-AE5)*10))*V14)=0 or =V14*1.5 If greater than or = to V14*1.5 then...
April 19th, 2010 09:41 AM
by Joe User[_2_] Go to last post
3 183
Top row of excel stays even in sorting by willyd
I need a header in the top row of my excel worksheet so that even when I sort the data the top row remains the same.
April 19th, 2010 09:36 AM
by Ms-Exl-Learner Go to last post
1 197
Pivot Table Groupings Fail if 1of the items isn't in the next data by Jerry G
I am Grouping items together in a Pivot Table and everything works fine until I use the next months data. For example, I have different types of earning...
April 19th, 2010 09:18 AM
by Roger Govier[_8_] Go to last post
1 182
Rating by Kareem
please Sir: if i take salary as 1000 $ per month , and this amout increasing annually by 10% it comes 1100$ then 10 % for next year and so on.... how can i...
April 19th, 2010 08:48 AM
by Joe User[_2_] Go to last post
3 174
Countif Formula by Khalid A. Al-Otaibi
A B 1 112233 Expired 2 113344 Valid 3 116655 Valid 4 117799 N/A This Formula is to calculate the number of employee in the column. =COUNTIF(A1:A4,"*").
April 19th, 2010 07:39 AM
by Jacob Skaria Go to last post
1 174
segreating duplicate Trasactions by Radhakant Panigrahi
Hi, can anybody help in the below query i have the below data with me RECEIPT_NUMBER TRX_NUMBER PAYMENT_AMOUNT Comments 9907893007 7000604737 151.06 ...
April 19th, 2010 05:49 AM
by Radhakant Panigrahi Go to last post
4 173
Post New Thread


Display Options
Showing threads 2121 to 2140 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 03:27 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.