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
I need to unprotect sheet so I cn sve it but need a password? by scout ron
I was working on my scouts accounts file which previously I have no problems with then on completion of some addittions I asked it to be saved.BUT it kept...
May 28th, 2010 03:05 PM
by Gord Dibben Go to last post
1 312
stop changing of format by DCZH
I want Excel to stop changing my set word wrap funtionality from off to on when copying or deleting data in a workbook. I will copy data from one sheet to...
May 28th, 2010 03:01 PM
by DCZH Go to last post
0 332
lookup with IF criteria by cv8497
I am needing to look up data from a seperate report in which the VLOOKUP formula will not work as there are multiple instances of the lookup value in such. ...
May 28th, 2010 02:39 PM
by cv8497 Go to last post
2 299
INDIRECT by Andrew Mackenzie
I would be grateful for any halp with this. I am trying to reference a cell in a different workbook using the INDIRECT function but I am returning #REF. This...
May 28th, 2010 12:42 PM
by Tom-S[_2_] Go to last post
3 336
Backup Excel file by Hema
I want to take backup of a file every time. I am using - save as - tools - general option - always create back up. The backup file is in the same location...
May 28th, 2010 12:26 PM
by Dave Peterson Go to last post
1 306
Make iteration default for a specific file by bnmohan via OfficeKB.com
Hi! I have an excel file that needs iteration. However, it appears the setting saved with the file is sort of global: If it is opened with a fresh instance of...
May 28th, 2010 12:24 PM
by Dave Peterson Go to last post
1 376
How do I write to a closed work book as a "register" by Kiwifella
Hi there all you Gurus out there! I have created a macro to create a unique invoice number in a work book, but for my specific purpose, each time I create a...
May 28th, 2010 12:20 PM
by Dave Peterson Go to last post
1 359
Can I import text file of cash flow to excel file then use formula by Bumpa
What I want to achieve is to scan in a cash flow (save to PDF) then copy to an excel spreadsheet and have it recognise the value of the numbers so I can use...
May 28th, 2010 12:13 PM
by Dave Peterson Go to last post
1 313
Sumproduct with multiple date criteria by StonyfieldRob
Having a tough time with this one. Sheet 1 Column A = Start Date, Column B = End Date, Column C = Quantity. Sheet 2 Row A = Start Date, Row B = End Date. I...
May 28th, 2010 11:24 AM
by Tom-S[_2_] Go to last post
1 359
Cond. Formatting, Mod(Row) and cell conditions by Jacob Skaria
Select ColA:G and try the below CF formula..Make sure the active cell of your selection is in Row1 =AND(MOD(ROW(),2),COUNTA($A1:$G1)) -- Jacob (MVP -...
May 28th, 2010 10:53 AM
by wynand Go to last post
1 319
Combine 2 worksheet change events by nobbyknownowt[_10_]
I have a worksheet that I want to place 2 worksheet change events on. i know that I cannot do this and that I have to combine them into one. I just cannot get...
May 28th, 2010 10:49 AM
by nobbyknownowt[_10_] Go to last post
0 315
how do i watermark an excel spreadsheet? by rsl
office 2000, would like to have watermark behind text in spreadsheet, to appear centre page, almost full size of page.
May 28th, 2010 08:05 AM
by L. Howard Kittle Go to last post
2 369
Excel fromula: Adding numbers from list to achieve a target by BillD
I'm not sure if this is possible in Excel but I'd sure love if I could get this to work. I have a column of weights (different sizes). Each weight is labeled...
May 28th, 2010 07:55 AM
by BillD Go to last post
4 335
how to combine several files, all with same columns, into one shee by Landa
Let say there is 3 excel files. Each file has one sheet and the same columns, e.g. column A: product name column B: description Column C: Price How can I...
(Multi-page thread 1 2 3)
May 28th, 2010 06:19 AM
by Faisal Ijaz Go to last post
28 1,365
Center All Pictures in Excel Cells by Finny[_3_]
Please help. Right now I have a UDF that I found online that lets me insert a picture into a cell by referencing the exact location on my hard drive where the...
May 28th, 2010 05:27 AM
by Jim Cone[_2_] Go to last post
1 668
Help writing a formula by WA
I have a huge database that I need to create numbering for each line like this example: AK-233 (2 letter state, a dash, and 1-4 digit number), but the number...
May 28th, 2010 03:59 AM
by Ms-Exl-Learner Go to last post
3 310
How do I calculate a persons age from birth dates by Rod Bishop
Wanting a formula to calculate a persons age from birth to today's date
May 28th, 2010 03:12 AM
by Fred Smith[_4_] Go to last post
1 324
Date Formatting by Tommy
I receive data everyday with the dates in the following format - 1/12/2025 (dd/mm/year), however I'm trying to format it to the following format-...
May 28th, 2010 03:10 AM
by Fred Smith[_4_] Go to last post
1 335
sum of timesheet by nidabland
Let's say A1: 9 am A2: 12 pm A3: 12:30 pm A4: 3 pm I need the total in A5 to calculate how many hours worked, but also...
May 28th, 2010 03:07 AM
by Fred Smith[_4_] Go to last post
2 254
Where it is possible to download MSN MoneyCentral stock quotes by Philippe
I have a new pc for 4 weeks and I would like download MSN MoneyCentral stock quotes for Excel 2007 under Windows 7. Do you have an idea where it is possible...
May 28th, 2010 03:04 AM
by Fred Smith[_4_] Go to last post
1 317
Post New Thread


Display Options
Showing threads 341 to 360 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 11:22 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.