Pages

Search

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...

Excel Help Forum - Excel Programming / VBA / Macros: Problem with sumif

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Problem with sumif
I have a problem with the following code Code: --------- strFile = ThisWorkbook.Sheets("abc").Range("A1").Value 'where in range A1 i have the path of the workbook If strFile = "" Then strFile = SelectFile("A1") If strFile = False Then GoTo finish Set BasisRPT =...

Excel Help Forum - Excel General: Mail Merge: The merge results are not aligned properly

Feed2Mail notification - new post on Excel Help Forum - Excel General
Mail Merge: The merge results are not aligned properly
I hope someone can help please. I have created an excel spreadsheet as my data source (and a word document as the main document) so that I can create an enquiry response for guests seeking holiday accommodation. I simply enter the required dates, number of people (and dogs) that are coming...

Excel IT Pro Discussions Forum: Conditional formatting - Between 2 dates

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Conditional formatting - Between 2 dates

I want to return a specific color in a project plan. In column E I have the starting date and in column F I have the end date and starting from column H I have the specific dates.

My first task in the project is on row 5 and on row 2 I have the dates written so the first date is specified in cell H2.

On row 5, the first task I want to check for the start and the end date and I want the sheet to automatically put  a specific color in all the cells between those two dates.

I need some sort of in between formula :)

/Fredrik

/Freddie

Subscribe to: Posts (Atom)