auto add

I’m part of an employee engagement team. We are sending out games/activities through email monthly and keeping track of participation. Each month the employee participates in, gets a “1”. If they don’t participate, the field is blank (or I can change to 0). At the end of the quarter, the number...

I am trying to make an excel file for my parents so that they have it easier than writing all the info in a book X amount of times. i have A; B; C; D; E; F; G; H; I; J; and L columns and want to automate and duplicate the data in A to G in rows below xn-1 times when there is a number on Hx...

Good Morning. I have two sheets that I am working with essentially a calendar for individuals so I actually have one master sheet and 60 individual sheets. The "individualcal.xls" sheets gets sent to out 60 individual members each year who update their sheets according to their availability...

Hello, I ask for your help. I would like to optimize my everyday work, since now it is devided into many excel files that take long to check them all. I have joined all the excel files into one, and now I need help to set up an automatic output cell that would agree with many conditions. So...

Hello all, thanks in advance. I've tried tons of formulas and combinations but no success. It doesn't matter if I have to add the tab name for each section of the formula or if there's a way to get every tab's names without mention it in the formula. No VBA please (unfortunately). I'm trying...

I have a table of invoices on sheet 1, to which I want to automatically populate the table on sheet 2. However, only the one what have not been paid. So, if a Y appears in column E, that row is not copied over. Sounds simple, probably is, however, its needs to be a "living" table, so when an...

I'd like to create a list on a separate sheet that automatically updates when a table is changed on another sheet in the same workbook. For example, let's say I have a table (table1) on sheet1 that has 1,000 rows of data. I'd like to create a new table (table2) on sheet2 that only pulls...

Hi in VBA I am looking for a script to look down a column and place a word after the last occupied cell e.g below so the word would go in A7 A 1 Help 2 Me 3 Please 4 I 5 Hate 6 VBA 7 8 9 James

Here is what I would like to do. when I type "a" in Column "TICK (a)" on table "InventoryTable" in sheet "Inventory List" It will copy its joining cell in Column "SKU" on table "InventoryTable" in sheet "Inventory List" to another table "InventoryPickList" in another sheet "Inventory Pick List"...

Hi Team, Can anyone assist me with macro code in order to get the required output. I have unique product criteria, the moment I select this product in the below example as Product Z, I need get another 3 (fixed common products) products should populate in the below row wth respective of qtys...

Good Morning, I am new to the forum and looking for help and not sure where to go. If this has been asked previously please do not hesitate to politely direct me to the forum that will help with my issue. I did a search but couldn't find anything. I know there has to be a way to do this...

Hi, I want to add a 'link' cell when a new row is started. THe cell would open a PDF using the phone number as a file name. I have the code to create the reference (written in VBA in MS Access). I just need to auto add the button to open the macro. In Access I just add a field on the on open...