Pages

Search

Excel Help Forum - Excel General: How to change cell entry over many files

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
How to change cell entry over many files
Hi I have a spreadsheet that I use as a costing template. I have saved that workbook many times as a new file name - ie " save as ". I now have realised that I have made an error in a few cells or I need to add a new cell entry - ie: either spelling, or formula , or format. Is there a way that...

Excel Help Forum - Excel General: Concatenate Help!

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Concatenate Help!
I am trying to concatenate 24 cells of data so that I can combine them into one cell and then paste them into MS Word. I will do some qualitatative anaysis on them once in word. However When I use the concatenate function it cuts off the last few cells. I have also Tried using the & Function....

Excel Help Forum - Excel Charting & Pivots: Moving chart data to other sheet

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Moving chart data to other sheet
Hi guys, I have chart that forum guru Andy Pope helped me with. The 3rd sheet (Data) provides the information of the Y-positions. What I want to do is to be able to remove this data sheet and have all the information be pulled from the first sheet (Stakeholders) so that when filtering it...

Excel Help Forum - Excel General: [SOLVED] Question on blank cell

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 (coupon code ICU65OFF)
[SOLVED] Question on blank cell
Hi, to make a cell empty, we tend to use double quotation formula like: IF(..., ""). This assume that the target cell will have a blank value. But if test it use: =IF(ISBLANK(A1),"true","false") The result is false, which means that "" does not represent a blank cell. There is value there!...

Excel IT Pro Discussions Forum: Xl2007 - XL2010 References

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Xl2007 - XL2010 References

I have an appolication which I have written in Excel 2007 but I also use it on my laptop which has Excel 2010 on it.  I have to access the save files from both PCs.  The application Emails so has a reference to the Microsoft Outlook 12.0 Object Library.

When I open this file in XL2010 it works fine, 'magically' the reference getws changed to Microsoft Outlook 14.0 Object Library.

When re-open the file after it has been saved by XL2010 in XL2007 there is, understandably, a missing reference, to the Microsoft Outlook 14.0 Object Library.  What I have to do in untick the missing references and re-tick Microsoft Outlook 12.0 Object Library.  This is becoming tiresome.

Is there a way, other than I suppose copying the Microsoft Outlook 14.0 Object Library file onto my XL2007 PC, of configuring my application to work both in XL2007 and XL2010 without the reference tweak?

Excel Help Forum - Excel General: Post Rotation

Feed2Mail notification - new post on Excel Help Forum - Excel General
Post Rotation
I am looking for a formula that will rotate each name up one row each month. The problem is that I need it to rotate to the bottom of the list of names, not the bottom of the range of cells. I have 6 slots, and sometimes only 3 names in that area to rotate, or otherwise it would be simple. See...

Excel Help Forum - Excel General: how to break excel file password any software /if any trick

Feed2Mail notification - new post on Excel Help Forum - Excel General
how to break excel file password any software /if any trick
how to break excel file password any software /if any trick