Pages

Search

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

Office IT Pro General Discussions Forum: Access 2010 and default database folder

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Access 2010 and default database folder

We are running Office 2010 Professional Plus 32bit on Win 7 Enterprise.

We have a GPO to set the "Default Database Folder" to %HOMESHARE%%HOMEPATH%. When I go to File>New>Create, I receive the error, "%HOMESHARE%%HOMEPATH%\Database1.accdb" isn't accessible. the folder may bylocated in an unavailable location, protected with a password, or the filename contains a / or\. However, when I click on the "Browse" button next to the path, it will take me right to my homeshare\homepath location. The location is a network folder that is used for my home directory, and has all the correct permissions necessary for accessing the share.

Is anyone else having issues using environmental variables for the default database path? 

A+ NET+ Security+ MCDST MCITP

Excel Help Forum - Excel Charting & Pivots: [SOLVED] Can you graph a range?

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
[SOLVED] Can you graph a range?
I realize you can chart an upper and lower limit on the same chart, but is it possible to chart ranges of 3-5, 4-6 and such so that you get one thick line on your graph that covers the listed range. Hopefully I am being clear with my question. Thanks.
Subscribe to: Posts (Atom)