Search results for query: *

Greetings, I am trying to understand material resource usage for reusable material. My made up project is brew 3 batches of beer with 100 reusable beer bottles. Each batch needs 50 so when batch one is done the bottles start being emptied at the rate of 10 per week. Obviously batch two can...

I have a macro to open all cells to appropriate height before printing to pdf for leader review (yes they are stuck in paper world). My issue is on inserted projects that tab over.. e.g. different levels of outline. Macro counts characters in cell and divides by width to set row height...

I have a massive current 3000 line program in ms project.. It will expand as we expect upwards of 1000 projects within. We are required to weekly print out the full project (I don't know why, other than told to..) So to have some fun I decided to create a macro to set the columns in specific...

I have done this in the past and cannot remember where I change the url to redirect the submitor to a save landing page vs. the full list of items. I will supply a link that opens directly to the create new "form" (not infopath), then when it is filled out I want to send the person back to the...

I have MS excel 2007 and Adobe acrobat 9. How do I convert the excel to PDF and keep the hyperlinks intact? It worked once but not again.. I could recreate the links in the pdf but that is over 500 (250 one way and 250 back) Any support appreciated

I work a group mailbox with 3 others. Currently we use signatures to reply to basic types of activities and fill in the specifics.. like date change, project number or specific names. I would like to get either the signatures into a shared format so there is one place to update and ensure we...

I need to look for changes in data to show progression through projects. I have a report that I run in BO that basically gives me a current snapshot of all projects and their milestone dates.. I save a copy to excel on a weekly basis and then need to compare for progression / stagnation of...

We are attempting to sum several cells that are not contiguous. There appears to be a limit of 30 cells that can be added up. Is 30 cells the limit? Has anyone seen this happen or are we just lucky?

I am working on a handbook for our organization to use as a training booklet internally as well as a handbook for our clients to understand / interface with us. Between the two documents are several sections that would be appropriate in both. Is there a way to link the documents so an update...

Is there a quick way to compare a "base" spreadsheet against another that was a copy but may have changes? Spreadsheet is too large for stare and compare so I am attempting to query / compare for non equal cells. Once a cell is identified I would know the row and column to review for...

We are in a hair on fire situation, where we do not have our database open to the users yet. Currently they update an excel spreadsheet (6 people with copies) during the day and send it in at night. In a spreadsheet (50 columns by 1500 rows) how can you find the data points that are...