spreadsheet

I have 2 sheets, one with a list of employee names and numbers the other with a list of errors made (this includes duplicate names/numbers) what I am trying to do is on a 3rd spreadsheet highlight the top 3 employees for each error, as this may change daily depending on how many errors occur...

I need to add the text "ABC" to the end of some worksheet tabs that already have names. It's a couple hundred sheets in the middle of a large spreadsheet, so I cant use code that selects the entire workbook. Thanks

I have a spreadsheet set out with 10 unique text entries in column A (row 2 through 11), and the same values in column C & E. In B, D, & F, I have a corresponding value that I am trying to sum. The easy solution is to put them all in one column, and use a basic sumif, but the spreadsheet needs...

I need to the data on a spreadsheet to someone who probably doesn't have access to XL. It though about printing it out, then scanning it back in as a jpg file but that seems lame. There must be a better way. I looked for an "export" option but only found a "share" option but the receiver...

Hi all Really hoping a genius can help me with a little task... I am using the code below to import data from a separate workbook into my existing workbook. What I'm trying to achieve is for one vba macro button to present the user with 3 separate spreadsheet imports. I.e: The user clicks...

I have a spreadsheet with 115 lines of 10 units of data on each line. 5 different numbers and 5 different letters on each line. I m trying to find out how I write a macro to show me the matched pairs and matched triples on this spreadsheet. My other question is how do I count all the numbers of...

Hi All, I have a monthly spreadsheet that data will be in different columns. I want to sum the cells in two columns based on finding the header (which will always be the same text) and put the summed total in another column at the end of the spreadsheet. Can anyone help me with this please...

I have a spreadsheet that I want to send outside of my organization, so that people can fill it in them return the spreadsheet to me. I'll set up protection to prevent unwanted modifications to the SS. It would look something like this.... 1. I edit a worksheet and get it ready to go out to...

I have a spreadsheet that I customize, then convert to an Adobe form, then send out to people outside my organization to fill out and return to me. We then enter their info back into the master spreadsheet. I save to PDF, then have Adobe convert it to a form. Generally, everything populates...

I have a spreadsheet that I need to add each month sales invoices based on customer. Here is a sample of what my spreadsheet looks like. I would greatly appreciate any help. Thank you in advance!

I want to dynamically copy an unknown number of multiple ranges from one spreadsheet to another. The list of ranges is stored in a table in the "to" spreadsheet with the - ranges from in a list called "list_from" and the - ranges to in a list called "list_to" I want the variable...

Hello- New to VB scripting. Here's what I'm trying do. 1) Prevent the user from saving the spreadsheet, unless the value within a column range is either "YES" or "NO". I'm providing the user with a default value on each of the cells that they must change. If the user tries to save the...

Hi I'm using the following code to save the selection to a new spreadsheet and then save it as import into the same folder as that main spreadsheet. ActiveSheet.Range("$A$1:$AM$216").AutoFilter Field:=27, Criteria1:=Array( _ "1", "2", "3", "4"), Operator:=xlFilterValues...

I have 2 sources: Data (Excel spreadsheet) and item_info (SQL table). They both share a field item_no. I want to join on this field in Data to bring in additional fields from the item_info table into Data. Both fields are data type text. There are no leading or trailing spaces. Join kind is...

Afternoon all!! I have a baseball spreadsheet that has been working up until a couple of days ago. Something weird started happening when the 3rd out happens and it goes to the sub "currinning". I get a Run-time 13 error everytime the Call to currinning happens. No matter what type of out...

I have a bunch of macros that I keep in a personal.xlsb spreadsheet so they are avaialble to all of the workbook I use. When in a macro in personal.xlsb, I refer back to the calling spreadsheet using activeworkbook. That works as long as I only have 1 spreadsheet up but if I am using excel and...

Hello, I have a large, 45 tab spreadsheet which the current code appears to be hanging, or at least is taking a very long time to run (even left overnight to no avail). The spreadsheet consists of the first tab, Location_Summary (an 11,000 list of part numbers) with the subsequent tabs being...

I know it sounds weird...but I have some complicated code that has MANY conditions for when I double click a cell in a range. I want a code that will run the code associated with the double-clicking of the cells automatically without actually double clicking. to sum up (I think): I have an...

Hi, I have fiterd data in one spreadsheet and then I have another spreadsheet which has more data but I want only to see the data from the filtered sheet. For ex. I need the data from column b on spreadsheet 1, which are dfferent codes, to see on spreadsheet 2, which has more codes than...