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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
copy row to different tab by L.S.[_2_]
Creating a SS with 6 tabs(master,A,B,C,D,E) each having 5 columns(doc#,category,date,box,folder). "Category" can have 5 different values, A,B,C,D,E According...
March 1st, 2010 11:41 PM
by Max Go to last post
7 249
Adding a number to itself by RST Engineering
I am making a budget spreadsheet in which I keep each month's expenses in one column and then the annual expenses in another column. For example, the January...
March 1st, 2010 10:46 PM
by Judy Ramirez Go to last post
7 285
open excel file by Rohit
i have problem with a excel file. the file is not to big. its has 5 tabs only. and when i click on to one of the "tabs" the excel gives me a error message as...
March 1st, 2010 07:36 AM
by Stan Brown Go to last post
2 218
Using the "if" function, the "and" function and the "or" function by Superblonde64
I am not sure if or how to use all three in a formula. For example: =if(b2="red", and c3="blue", d6="green") if that makes sense at all.
February 28th, 2010 03:13 AM
by Dave Peterson Go to last post
1 211
How do you start a Macro? by Michael
The thing that I am wondering the most is how to start a macros. Adding on to that question where is the tools menu to start the macros? This version of...
February 27th, 2010 05:55 PM
by Gord Dibben Go to last post
7 532
sumif by Barny[_2_]
I need to add the total in cell H6 if the following condition is met If H60 and A6 contains the word "total" (where A6 can contain alpha and numbers) i.e....
February 27th, 2010 02:41 PM
by Don Guillett[_2_] Go to last post
4 192
Excel 2007 Compatibility Mode by Marsh
I am working in a file, it is in Compatibility Mode. I want to "Convert" it to a full Excel xlsx file. I have done SaveAs|Excel Workbook and it stays in...
February 26th, 2010 06:48 PM
by Gord Dibben Go to last post
1 227
MS Excel 2003 - Advanced Features Add-In by RobinRoot
The Advanced Features Team is pleased to announce the release of the first version of their Add-In for MS Excel 2003. Part of this realease are the following...
February 26th, 2010 03:41 PM
by JLatham Go to last post
4 217
New to Excel - I want to add a few columns across (P and Q)... by JAG
Hello Michael...what if you wanted to do this across multiple columns but skipping over a few? Thanks! "Michael" wrote: Once you have written the first...
February 26th, 2010 02:11 PM
by JAG Go to last post
0 218
New to Excel - I want to add a few columns across (P and Q)... by JAG
"Michael" wrote: Once you have written the first formula in say R1. Click on the little black box in the bottom right corner of R1 and drag it down as...
February 26th, 2010 02:09 PM
by JAG Go to last post
0 172
help with inputting code by Morgan
hi there, i have some code (below) that takes the value of cell U17 every time it changes and then lists it in a column on the 'graphs' sheet for charting...
February 26th, 2010 01:24 AM
by JLatham Go to last post
3 211
How to apply Macro on a same type of format but columns no. r chan by Manmohan Singh
HI, First of all i 'd like to explain what problem i'm facing. See i've data in three Rows and three Columns. I've recorded macro & i applied the same...
February 25th, 2010 11:02 PM
by JLatham Go to last post
1 168
Worksheet printing by tb
Can I set sections in a worksheet? I have a Job Record to keep track of all labor / equipment and materials per Job in worksheets. The problem I am having is...
February 25th, 2010 05:34 PM
by Gord Dibben Go to last post
2 217
Functions by janey
Hi, I am new to Excel 2007 and have done all the 'training' offered on the Microsoft website. I am now interested in learning about the different functions....
February 25th, 2010 04:08 PM
by Bernard Liengme Go to last post
4 196
number by hungayun
the error is :"the number in this cell is formatted as text or preceded by an astrophe", It means we must convert it to number and we can do, but I don't...
February 25th, 2010 03:37 PM
by Gary''s Student Go to last post
1 173
February 25th, 2010 05:38 AM
by Rick Rothstein[_2_] Go to last post
1 169
How does "Search For" By or Subject work? by SVanDee
(This is a question about how to use the Forum; not how to use Excel. I know it doesn't belong here. Please accept my apologies. I can't find any other place...
February 24th, 2010 08:10 PM
by SVanDee Go to last post
4 210
in xcell, how do I select on 1 cell? my cursor selects multiples by Dwigtht L Holobaugh
While this problem doesn't always occur, it causes me problem when for some reason while working in a spreadsheet, it starts pickup up multiple cells...
February 24th, 2010 05:37 PM
by Luke M[_4_] Go to last post
1 206
IF/ISBLANK formula by Missile
When using this formula =IF(ISBLANK(B2,"",VLOOKUP(B2,D2:E20,2,1)) I am getting the #N/A error or incorrect data if the value in cell B2 starts with a 0 eg...
February 24th, 2010 02:54 PM
by Max Go to last post
3 210
one code to do multiple things by Morgan
hi, i have the code below which takes the value in cell U17 everytime it changes, and places it in column A on a sheet called graphs thereby forming a list...
February 24th, 2010 08:09 AM
by Morgan Go to last post
0 269
Post New Thread


Display Options
Showing threads 341 to 360 of 13737
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 05:41 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.