summary of data

  1. M

    Combining lines from several files within folder via IF or similar

    Hi. I have a need to make a script, that opens and looks through all files within a selected folder. In each file, it should look for a certain IF sentence. If the cell in the line of the specific file = TRUE, it should copy these lines to a new file. The idea is to add and collect all the...
  2. S

    Is it possible to FORCE a pivot table to keep old data?

    I have read a number of posts about changing the "retain items deleted from the data source" setting. This may work well for getting rid of the old data, but it setting it to Automatic or Max does not seem to FORCE the pivot table to keep old data. I am looking for a non-macro...
  3. I

    Summary Report

    Hi, I have a multi sheets tab in a workbook as you can see the name of sheets . i want when i click on the sheet name of any one the data show me of that sheet . than i can sort out by Last name as showing " Braaf "... Many Thanks A Column <tbody> Sheets Name HV-Agewell beg...
  4. Z

    Need a summary of work by dates and counts of the date entries

    Hi, I need help with excel. I have database of my daily work tasks which includes different dates in one column and in the other columns I have other datas that are mostly in text. Now I need an excel code/function that can provide a "summary of tasks" that I did by each date listed and a...
  5. M

    Exec Summary creation

    I have a spread sheet of vacant billets that is primarily organized by offices/sub-offices and then organized by statuses. I have been requested, to provide an executive summary for all of the sub-offices that shows the status of each vacant billet by status and by sub-office (See Below). So...
  6. T

    VBA to Create Summary Sheet

    Hello. I'm looking to create a VBA code that will loop through every worksheet within my workbook (except for the summary sheet) and search for a text string. Once this string is found, I would like the code to grab the 5 cell rows to the right of the looked up cell and paste special this...
  7. F

    Pivot Table: Count number of column values within each unique sub_class expressed by class

    Hi Mr. Excel, I need some Excel Pivot Table help, I'm not quite sure how to express this question in technically appropriate language so I've create the below illustration. Considering the below table, is there an elegant way to count (not sum) using a pivot table, the number of seeded foods...
  8. A

    Need help on multi-level pivot summry

    Hi all, I need help on a survey table that is of following format. Sr# contains 318 rows and there are 30 columns named 1 through 30. I want to create a summary using 'pivot table' that helps me in identifying how many questions have an answer 'a', 'b', 'c', 'd', and '0'. Would appreciate a...
  9. M

    Creating an evolving table of averages from a growing list

    I have an ever-growing master list of values and a table to summarize the list using sumif and averageif functions. I am hoping that there is a way to make the summary table update as the master list grows longer without going back into the function and expanding the cells that the sumif and...
  10. M

    Macro for copying cells from multiple workbooks

    I am new to this forum and I would be very thankful if anyone can help me out. I need a code that will copy certain cells from all sheets of all files in a folder and then list/paste them down in another master/summary sheet. All workbooks in the folder have multiple sheets and in each sheet the...
  11. M

    Creating a summary sheet based on other sheets

    I have excel file in which each sheet will be filled by a different clients (Client1, Client 2, Client 3.. Client n). Each sheet will have two columns "Description" and "Quantity". Client will add the descriptions and quantity.Apart from the sheets filled by clients, the file will also have a...
  12. L

    Summary Box Macro? For inventory system.

    I keep a simple inventory system at work. A row is added for each new unit of inventory. A summary box is used to calculate current inventory and total units processed. Is it possible to set a macro that will auto calculate the summary box when new rows/inventory is added? Currently I drag the...
  13. L

    summarize monthly dates with categories and totals

    Hello all. I have a spreadsheet with three columns. Date, Amount, Category I have dates ranging from January 1, 2011 to May 31, 2011. I have to create a summary by month for each category and the total. Eg, Jan - Travel - $230.00 Feb - Entertain - $600.00 etc. How do I do this?
  14. M

    Help with Query, either VBA or Regular

    Hello again. I am working right now on generating a report but I am unsure of how to do it. Essentially, I am wanting to cycle through a query that I have already built to find the names of the reps (varies as to the amount) and then show the record info associated with that rep. That much I can...
  15. A

    Super Hard Problem.......i think

    This is kinda complicated and im not sure if it's an excel or VBA question but here goes! I work at a home care company and we are redoing out client care plan form which is composed of many check boxes for tasks the caregiver needs to do in the home. PROBLEM: I am trying to create a report...
  16. F

    Summary sheet from data in other sheets

    Wondering if anyone can help me create a formula, command and/or macro for this problem... I have several sheets within one excel document - each has several columns of data pertaining to customers. Particularly, I would like to list all the customers (multiple duplicate listings) from three...
  17. J

    Need help ASAP,pivot table or best option for data summary

    Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have a spreadsheet containing loads of data which I add to daily. I need to summarize the data in a few ways, and keep running totals. I need to be able to count how many items were entered by day...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top