Search results

I have large spreadsheet with many rows and columns... Each row is a product. the columns adjacent list., column 1:location, column2:# products in stock . column3:cost of product... Im trying to find the average product cost which is gathered from all the locations total spanning all locations...

Hello Chaos is back... It's Been awhile. Looking for best approach. I have Specific Names (Job Titles) that are listed in 1st column one. There are adjacent columns providing Names of 20 Locations (Site 1-20) with # of positions, and Annual Salary of position for dept within site (so they...

I have a master report and it pulls from various sources. When it updates it will of course change the total value. I need my report to automatically capture what the prior value was and place it into a prior total value cell right next to the updated new value. (I have this set-up on a...

Generated daily in excel format... Source Report: Column B1-B3 (* general office supplies or * apparel or * training) Source Report: Column C1-C3 (provides the dollar amount spent) The Main report is in excel format... Main Report: Column A1-A3 = Defined Name (general office supplies or...

I have five Columns and 5,000 rows of data from a source report... Need Search Columns(1)need to find all COMM and search column (2)Accounting Number (1011000010 and 1011000012 and 1011000100 and 1011000500) So there's letter's and numbers that will be searched through... Each row has a...

I have a consolidated report that has links to many source reports, which provide the data. When the source reports have additional information added, which must be manually added with there new rows shouldn't the new data and rows automatically populate on the consolidated report it rolls...

I have just completed the bulk of my lengthy consolidated report assignement. Each report has links back to the source information. I have zipped everything together, and moved it to another work station. I first open all the source reports then opened the consolidated reports.... Of course the...

I am trying to the type of data entred into a cell: The entry can only be a combination of 1, 2, 3, 4. (The 1, 2, 3, 4 specifies quarters). Example they could enter 1, 2 or 1,4 or 1,2,3,4 or 1,3,4...get the idea.. At first I tried lists but, the list became long with all the combination...

My spreadsheet report is separated in sections... I have what looks like headers (Taking up two rows) that provide details on what is in each column. It seems as though when I accept my updates since these all the cells are linked to outside reports the titles at the beginning of each of the...

I have a main report that will be linked to another tracking orders report for a link data pull into the main report (all departments dumps data into when ever a new request is made. I know it would be nice if they had a database, but I am not as lucky... My report has specific verbage that I...

I have a report that is linked to cell from many department reports. On the department report there is a section per category: column E with projected total dollar amount ($20,000.00)for the entire year and colmn F has projected quarters (1,2,3,4) the projected totals would be used. The...