Pages

Search

Excel Help Forum - Excel General: How to delete rows if column A1 and B1 are equal to A2 and B2

Feed2Mail notification - new post on Excel Help Forum - Excel General
How to delete rows if column A1 and B1 are equal to A2 and B2
Hey guys, How do you automatically delete all rows EXCEPT ONE when for example A1,B1,C1,D1 are equal to A2,B2,C2,D2 AND copy the remaining one to another sheet if column E is greater then 4 999 999.99$? For example: A B C D E 1| 13232 | 250 | 1800...

Excel IT Pro Discussions Forum: Excel cannot access 'Start Menu' error when open Excel 2010

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel cannot access 'Start Menu' error when open Excel 2010

Excel cannot access 'Start Menu'  .  The document may be read-only or encrypted error window when open Excel 2010. Followed by this error window, 'Start menu' cannot be accessed. The file may be corrupted, located on a server that is not responding or read-only.

All other Office 2010 applications open fine without this error.  XLStart is located locally on this Win7 desktop. After selecting "OK" to each of the windows, one can open Excel fine.

Excel Help Forum - Excel Charting & Pivots: [SOLVED] Scaling positive and negative values on primary and secondary axis r...

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
[SOLVED] Scaling positive and negative values on primary and secondary axis respectively
Hello Guys, I have the following data: Katalog Redemption Platform Miles -302351940 -764328242 Bookings 7082 11861 Now when I am trying to plot a graph with Miles on Primary Y axis and Bookings on...

Excel Help Forum - Excel Programming / VBA / Macros: Macro HELP!

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Macro HELP!
Hello all, I'm working on an Excel spreadsheet where I need a serial number to increase by one each time I print the document. For example in cell B6 I have serial number RAIL-0001. I would like to set it up so that the next time I print the number will change to RAIL-0002. Is this possible? Any...

Excel Help Forum - Excel General: VBA Help

Feed2Mail notification - new post on Excel Help Forum - Excel General
VBA Help
I have a Macro set up to update spreadsheets from another shared spreadsheet. When it finds the relevant policy number it updates the comment with a pre-fix of the date i.e. "23/10 Comment updated". The problem I am coming across is that if no new comment has been received after the 23rd it...

Excel IT Pro Discussions Forum: Excel 2010 copy paste on worksheet repeats on another worksheet bug

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel 2010 copy paste on worksheet repeats on another worksheet bug

Hi I have a weird problem in excel 2010.

I have set up a series of pages to print on multiple worksheets.

I'm having a problem when I format one of the worksheets using copy/paste or format painter.

The changes are being replicated in the other worksheets on the same row/column.

Has anyone had a similar experience?

Thanks


Excel Help Forum - Excel Charting & Pivots: Scaling positive and negative values on primary and secondary axis respectively

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Scaling positive and negative values on primary and secondary axis respectively
Hello Guys, I have the following data: Katalog Redemption Platform Miles -302351940 -764328242 Bookings 7082 11861 Now when I am trying to plot a graph with Miles on Primary Y axis and Bookings on...