Search:

Actually I'd think that every professional services firm would need this.

Can someone point me where I can grab a template, or learn more about this? In my case I want to be able to consider forecasted sales from accounting in different ways. We're a consulting company....

I don't care about other people having it, although I want them to be able to see the last data I updated with. I would like to not have to open the other file though. Is there a way?

Thanks,
...

Hi Rory,
Here's the first part of the formula with the filename
=GETPIVOTDATA("Period 13 Actuals ",'C:\[2-Key Strategic Indicators QB Source Data.xlsx]P&L Pivot'!$A$1,

I have a master document that grabs data for it's pivot tables from one external file and grabs data from another file directly. When I load up the master document everything it's referencing from...

The first page is part of the display sheet. The second sheet is data entry. The timeline grey formatting is what I want to show up on the first sheet.

The format of the source will change week to week so we can't manually format the display as it will change. The formatting is manual and up to the person doing the data entry so I can't cond format....

Thanks. that did solve it.

I had tried that as it looked incorrect to me, but then it returned an error.
Tried again this morning and it helped. Also Zeddy's comment helped, although AG and AF are correct ;) I somehow had...

thanks. that worked, except for me the conditional formatting is not 'taking'. seems silly, but I'm getting NO conditional formatting on those cells. I've attached a couple of screen shots in case...

Cool! That works.
Now, how can I bring the formatting with the data in a lookup. I want the result to look just like the source. It has both text and cell formatting.

Thanks for the quick response. The cell is formatted as general. I've tried different formats but no change. And there are many formulas on the page, only this one displays and it only displays since...

Weird. I'd tried that before using the paste icon dropdown and special wasn't there, but with a right click in the cell it is!

Thanks. I was trying to format to wingdings as part of the conditional formatting. That works now. Doesn't do what I wanted it to do yet, but it's enough for now!
Thanks!

I have a formula in a cell that doesn't resolve. It displays like text


=IF(LOOKUP($B4,'Manual Entry Timeline'!$A:$A,'Manual Entry Timeline'!J:J)#"",LOOKUP($B4,'Manual Entry...

Hi Maria,
Well I tried it. I have two problems. (1) I can't get it to display the wingding font you have showing. AAMOF when I chose font they are all grey and I can't choose one. (2) I'm hoping to...

In MS Project I create a dashboard like column that puts a red, yellow or green icon in the cell depending on the status of the task. Can I do this in Excel. I've tried finding some way to use...

Thanks! I'll give them all a try. Not sure why my tests didn't work last night.

Is there a way to do this? I have a sheet that has items matching the column data in the pivot but I cannot seem to get lookup or vlookup to work.

I have an area of a word doc that I'd like to display in Excel. Updating would only happen in word. The data could probably be put in a table and then display in multiple cells in Excel too. Any...

I have two columns of numbers. When the value in one column is equal to the other in the same row I'd like to highlight one. How do I do this?

I have exactly the same problem for years, even after a complete rebuild.
HP Pavillion DV-7 Win7 iTunes/iPhone, no VM
29591

Two more questions.
1. If a customer has a project plan that uses some of our resources can they use our resource pool for our people and their own (of just resources added directly into their...

I'm considering starting to use MSP 2010 more for my business. One thing we currently have to do manually is track all of our consultants across different projects. We don't have project server (and...

one project, 400 tasks with 15 resources, 6 months. excel, project, access, no QB