summary

Hi The code below works with only one condition in the IF statement (the first one - Summary sheet). However, when I add the other two sheet names that should NOT be cleared, it doesn't work? Do I need to change something in the IF statement? Thanks in advance. Code that works: Sub...

I have this code below to where I select a name in cell I4, and then click run in cell f4, and this filters to that name in each pivot table on the page. This always worked before but all of a sudden stopped working? Also, is there a way I can write this to where if you just select another...

Hello, I have 35 tabs that are updated daily. I want a summary worksheet that will combine everything that is on the 35 tabs. Info can be updated on these 35 tabs at anytime and would like the summary worksheet to reflect the changes made on any of the 35 tabs. Each tab has the exact same...

Hello all, i was kindly helped with a vba code today, which worked great, but i've come across another issue. i have a summary sheet with a list of suppliers, which all have their own tabs. i wanted the suppliers in the summary sheet to match the colour of the sheet tabs. my problem is when...

Hi All, I have a summary sheet with all my suppliers on it. is there a way I can colour the supplier names in the summary sheet with colour of their tabs. thanks in advance.

Hi, I'm wondering if anyone can help me with the below? I have 2 files (Client X & Client B). They are saved in the following folder: I:\Content & Creative\Design Admin\_Revenue Additionally, I have my summary file (which does not yet have a macro - but this is where I'm wanting the macro to...

Hi I'm using excel 2016 i would like to create a weekly summary sheet totaling data from each daily worksheet, but only if they have worked during the week So i have a workbook with tabs Sun-Sat the unique personnel number its in column A2 down (the unique number is not always in the same row...

I am BRAND NEW to VBA coding and have tried to figure out how to write what should be a simple code with zero success. I'd like to attach the workbook, but I don't have privileges in this forum. Summary of goal: I have one tab called "Instructions TM1" and another tab called "Ops and ADS...

Hi Vba champs, 1 Need help for macro which should consolidate n number of Input files(all saved in "Input" folder) in 1 summary file 2.Each Input file has same format/ 2 tabs - 1-Input Details 2. Summary. Need each tab in Input file to consolidate(copy as values/No format copy) separately in 2...

Hi there, If I have a static table that I want to create a summary from. For e.g. A B C 1 Andy M 23 2 Mary F 46 3 Mike M 17 4 Beck F 35 5 Tom M 29 Column A is static, so I want to create a summary table below it with only entries in column B that match 'M' which also includes column A, B &...

HI All, I need help in writing a macro which will run in all sub folders. I have more than 75 folders in which it contains 8 excel workbooks each. one of the work book named " Summary" has the name in cell A1. I need a macro which will insert one column before column A in all workbook and...

I'm trying to design a sheet that generates a standardized summary of the results of an assessment. I've begun making formulas to do this. However, I would prefer the summary generate as formatted paragraphs, rather than as single lines as it does when written as formulas. Here's an example of...

I have an excel doc with several worksheets 1 summary sheet The rest are all different addresses, the address in each sheet is in cell B2 I would like a formula in the summary sheet the give the address in cell B2 and be able to drag the formula down to give the addresses for each different...

Hello, I hope you can help - my VBA skills are extremely lacking, but I don't think what I'm trying to achieve is actually too difficult. I'm trying to copy rows from multiple sheets to one summary sheet based on whether the row shows 'completed' in a certain cell or not. I have a workbook...

Hi, I have a workbook that is meant to track travel costs across various departments. it has 11 department spreadsheets and one summary sheet. My issue is finding either a macro or function that will transfer the individual travel cost entries on the various sheets, to a single cost cell on the...

Hi all, i need some pointers on a formula im trying to use. I have a workbook with multiple tabs and a summary tab. on the summary tab from A2 - A10, i have the corresponding sheet names. on B2 - I 2 i am using =INDIRECT("'"&$A2&"'!"&"O3") to pull data from the referenced sheet name in A2. My...

Hi all- I’m really struggling with the last step of my variance reporting for my company. I have a workbook with 30 or so sheets. Each section of business has 3 sheets. One of these sheets has been formatted to highlight certain variances that need explanation. I want to create a summary sheet...

Hello, I am hoping someone can help me with my dilemma, I don't even know where to begin coding this one. I have a Workbook with 6 Sheets: TRACKER, FY19 SUMMARY, FY20 SUMMARY, FY21 SUMMARY, FY22 SUMMARY, FY23SUMMARY, and FY24 SUMMARY. I need to move a portion of a row of data from the...

Hi there, I'm hoping some excel genius can help me with this query I have, I tried to ask using formula but I don't think it can be done, could someone assist with the VBA code please? ; On the attached sheet I have 2 tabs, 'Fee Summary' that houses the info & 'Fee Changes' where I want the...

I am running Excel 365 on Windows 10. I recently created a workbook that has a summary page for about 100 sheets. Each sheet has a link to this summary page. I hid all rows at the bottom of the summary page for aesthetic purposes, and noticed that it increased the size of my file by about 2mb...