made

Hi, May i know how enable vba code to run automatically when i open my workbook? and run the code again when changes is made in one of the cell? I would be so grateful for your help.

Evening all! This may be a far stretch.... I have workbook with 500 tabs. I have made the first tab exactly as it needs to be but now I want to copy that (formulas and all) to the other 499 tabs. Any advice?

Hi My dropdowns have been working fine. Each time a selection is made, a text cell increments plus 1 etc. The problem is PC wide, as no spreadsheet dropdown selection will increment. A few changes were made to the Trust Centre in order to prevent Excel asking any silly questions. Any ideas...

I have a request if anyone can help. I am by no means great at Excel, but I have learn a bit. I can SUM using Index/ Match, but when I get to anything other than a general value in the cell, I get an error. I have made the small list with generic terms for simplicity. Very much appreciated...

Hi! I want to track changes I have made on my worksheet by having a time stamp against each row. I have data from columns C to AX. I would like to have a timestamp in Column AY (only date would also work), if any value changes in any cell between C and AX. I found a couple of VBA codes which...

I am trying to populate a main table using a drop down list whereby each dropdown option extracts data from a table from its respective sheet. All the tables are of the same dimensions. Example: I have 3 populated tables for Types of insurance claim down the y axis (public liability, flood...

I have data that shows the all the store visits made by each person with their timestamps. In Column A I have the Person ID and column B is the timestamp of the visit (e.g. 23/4/2017)<strike></strike> I need a formula that will work out the following in two separate columns: - A person who has...

I have data that shows the all the store visits made by each person with their timestamps and looks like this: I need a formula that will work out the following in two separate columns: - A visitor who has made at least 1 visit in a 6 month period - A visitor who has made 6 or more visits...

Greetings! I'm currently using excel 2016 in the office previous versions had a feature where you can view changes made to cells on a separate sheet. This would issue the user's name, date, time and cell number change but I don't see feature on the worksheet. Would anyone know where I can find it?

This is just an open topic of discussion I've been curious about and would like to hear from the community. I remember when I had just turned 20 and learned excel was more than just a bunch of squares you can punch numbers into. Fast forward 10 years, I finally started diving into macros this...

Hello, I have amount employee makes in C5 and hours worked in D5. I need an if statement to calulate the amount the employee made up to 40 hours only. Thanks

I have lots of data one one spreadsheet, the goal is to make a query formula that will search for all the responses a person made based on a cells critera. EX: Sheet 1 <tbody> Name: Response: X A Y B X C X D Y E Z F </tbody> Sheet 2 <tbody> Query Formula Criteria (name): X A...

Hey, i'm struggling to make a macro which looks up column made out of 5-90rows in another column in exactly same positions. example: column 1: asd asd2 dfd dfd 33h8 reg3 sfd 11d ads6 hef3 fe2 hrt6 rhw4 2f1 fef0 jj column 2: reg3 sdf 11d ads6 In current state that'd find only 1 column made out...

I am looking to get out from all cells the letters I made in buld out from this cell https://www.screencast.com/t/apAeD0FCrE6 <tbody> walgreens.com/store/c/as-seen-on-tv-roll-a-lotion-applicator/ID=prod6095201-product...

Hi All, I have a table with information, to indicate the type of calls being made and each staff name, however using a manual table i can find out who has made calls and who hasnt. Using a Pivot table i can find out who has made calls and have lovely graphs, what i cannot find out, is how do i...

Hi , I am making a format of salary slip using index and match function. i am trying that if i put the month and emp. id the rest data should come automatically to that payslip format. but i have 12 worksheet having 12 month salary on it. and in that i have already made table of the salary made...

I wanted to use the same layout for two projects, and was to lazy to create an entire new worksheet, so I made a copied of the worksheet's whose format and VBA codes I wanted to use. Apart from the colour scheme, I've made no changes to the copied document. The VBA code still works in the...

I use a lot of data entry on my spreadsheet. Is there a way to create a message box that will tell me the entries that I made during the day? I have 3 different cells that would need to be displayed. the first cell ( cell A) is just a description the second cell ( Cell B) is an amount that I...

column A is # of contacts made in a week 18,245 Column B is # of FTE 212 Column C is # of weeks 52 how would you determine # of contacts made per FTE per Week ty

My spreadsheet is showing formulas in some of the cells. I type in a formula and it appears as though it was text even though it starts with=. Also the format of the cell is "General." Actually, there are 600 cells showing the formulas. But while I kept messing with the cells one or two of them...