added

Hopefully I can make this clear enough. I have a table that is refreshed, appended, and duplicates deleted from a text file and fills data in column A (SKU Number) and B (Quantity Available), and that is working fine. I then added Column C (My Price) and entered my cost of each SKU. If I sort...

Hi All, I hoping for some advice on how to make a team planning board which reduces the employees holiday entitlement when a holiday is added to the board. Please see below picture to get an idea of what I am looking to create :) - the sheet only needs to capture holidays as a reducing value...

Dear All, I created new userform and added combobox. Opened excel sheet and inserted new sheet and changed name to "Materials". In the combobox properties added row source (Materials!A1:A8). I added also some material names to the "Materials" sheet in the column A. For example, A1=Book...

Hi everyone, I promise I have searched the boards, but I just can't figure out how to solve my problem :eeek: It looks like I could use SUMIF, but I just can't get my head around how to do it. Basically I want to sum cells, not the same range, different ones within a column. The difficulty...

I have a VB script that sets up a number of tables and asks for input from the user to identify 3 input files and a date field in the script. The file updates a number of tables via the refresh and then runs through to create the file. I would now like to add a save command that takes the date...

Dear Sir, I have added new Userform1 and added combobox1 + label1 and textbox1 + label1. Then added command button1 (name is submit) (when you click this button it will add info to excel sheet). I want to see combobox1 as filter which including name of material and cost. When I click selected...

Column A has listed items that are Accepted. Column B has listed items that are not Accepted. Column B is fixed set of items, but 1 or 2 new items from time to time may be added or deleted. Column A though is a new updated daily list of items un-checked. My current macro is a Do Until ""...

I'm using the code below to create a master list from a pick list. User put's "x"'s next to any document on the picklist that they want to show up on the master list on the following sheet. The code is working, but the problem is that it is also continues to add multiple instances of the same...

I have a pivot table with multiple subtotals. Off to the right, we added manual adjustment columns not part of the pivot table. Is there a way to automatically insert subtotals (highlighted in yellow bellow) for the manually added columns? I have thousands of rows of data so manually creating...

Hi all, I have an Excel document that I use to showcase upcoming events to other users. I'd like events that I've added recently to pop up in a message box when the document is opened. I have a recently added colum with the date that the event is added followed by a colum with the event details...

Hi everyone, I'm in a bit of a pickle... I've got a VBA script that was working just fine... until I added the following lines: On Error GoTo here find_row = Workbooks("data.xlsm").Application.Match(Workbooks("data.xlsm").Sheets("Data").Cells(1,2), Worksheets("Data5").Range("A:A"),0)...

I added a password to my spreadsheet by going to "Save As", Tools, General Options and added a password to "Password to modify". What I am encountering is when someone opens the file in Read Only, it is locking me out from editing. What I am looking for is when someone opens the file in read...

In Sheet 1 I have columns: Roll Num Name Marks In Sheet 2, I need the same details to appear, but with the records in descending order of Marks. In future, when more records are added in Sheet 1 or any records are modified or deleted, I want the table in Sheet 2 to be automatically updated...

Hello! I hope this post finds you well. I have created an Append Query to append information from one table to another. I wanted to run the same query and noticed that the query would the append all records vs. the added new records. How to I get this query to append only new records, and...

Hi everyone, Here is the idea, I have a column of numbers, let's keep it simple and I will adapt later : let's say the column is 2, 4, 6, 8, 10, ... (2 clients added each time) but at a certain point after X lignes (years) I want to take out the ones added X years ago. That means if X is 10, on...

The goal is to be able to input only one number and have the table populate and be able to dynamically increase or decrease rows with data if Worksheet #2 has data removed or added. In this example, I want to be able to input the account # (we'll say 1) into cell B4. I want the other cells...

Hi, Is there a way I can compare the items in Column B to those in Column A. Then any item in Column A that's not in Column B would be added to the next available row in Column B. Thanks!

Hey, I have a weird problem with summing/adding up. Instead of returning a value, a dash is returned (as if all the values are zero). I've even tried adding the cells individually, and the same happens. All the cells are in the same format (namely accounting). When adding then up individually I...

I was using a sumproduct formula (below) to find numbers in column W to give me an average by month. It was working fine but I added a formula to column B to add the current day when a number is added to column W and now the sumproduct gives me a #value ! error. I tried removing the date...