Search:

Well, I did it with the background 2-axis method and it looks pretty nice. I also just used the draw line tool to do what I originally requested and it worked just fine. I was worried about the...

Thanks for the quick reply,

You're talking about what was done for method 1, series 1 I'm assuming. For that, I'll have to make three additional data columns that only serve the purpose of being...

Attached you'll find a file with a stacked column chart and the corresponding data. I was asked to add in a couple vertical lines at the tic marks to the left and right of the 15-21 group. One of...

Is there a way to have a workbook open readonly for all users except for a few that I know the user id of?

That worked great, just what I was looking for. Thank you.

Hello,

My team at work all use the same workbook on a network drive and occasionaly make changes/updates. Is there a way to have the workbook make a log (in a dedicated worksheet) of the username...

Perfect, thanks!

Yup, that works. Thank you!

One question with this. This event could be triggered from a button in another sheet. When I hit that button and it executes the 'Sheet1.Unprotect "pw"' line it...

Hello,

I have a worksheet that has a few rows that are hidden and shown by pushing the corresponding buttons. I have formulas within this sheet that I would like to protect, but once I protect...

Works great, thank you!

Hello,

I am making a spreadsheet to help schedule a particular job at work. I am trying to edit the caption of a label to show the names of everyone unavailable for that day.

Right now, I have...

Yup that's it, thanks. Forgot to do that this week.

Take a look at the attached file. At the bottom of sheet1 (row 157) there is a sum. For some reason it isn't working correctly. The format seems fine and it was working fine last week. The only...

Cool, thanks for the info and I hope you have a good holiday season!

Great, thanks.

A couple things:
a) Any ideas how the nonbreaking space got in there? It is highly unlikely that our excel user typed "alt 0160".

/forums/images/smilies/cool.gif How can you...

I was using a vlookup to match names in a couple of spreadsheets and came accross a problem (see attached). What is different between the two names?

multiply by 100?

Maybe an advanced filter that copies the wanted data to a new location. Then do your lookups based on that new location. It would be nice to have a button that would refresh the advanced filter if...

yup, Sorry about that confusion. That is what the formula should yield for November.

I was looking at the results it gave me and wasn't able to figure out what my current (incorrect) forumula was...

Well each person owes a share of the total money paid and each person paid a portion of the total money paid. I'd like that information sorted by month for each party involved.

If you look at the...

Hi,

I'm working on a spreadsheet to help figure out expenses between myself and my roommates (see attached). I used an array formula for the "Paid" report and it worked beautifully. However, I'm...

When I want to save a picture (animated gif) from internet explorer, it won't let save as a gif. It only lets me choose bitmap. After I reformatted last year it was back to normal (letting me save...

Thanks guys

As I use the number pad a lot when entering data, I use the arrow key to move to the next cell to the right. When I'm ready for the next line, however, hitting the enter key will not start me in the...

Thanks for the reply, but I followed those instructions and it didn't work. Anything else that is worth a try?