excell

Hello, I have several countifs functions looking at the same data in order to pull totals. The first equation: =COUNTIFS(Data!$O:$O, "5 Pack",Data!$L:$L, "Plastic") Gives me the total of 1000. =COUNTIFS(Data!$O:$O, "5 Pack",Data!$L:$L, "Glass") Gives me the total of 43. The function...

Hello everybody! I'm new on this forum and ended up here searching for solutions to my problem. I was assigned to cleanse an Excell sheet with 13k rows, all these rows are clients informations like name and address and the reason is due to the fact that our employees registered the clients...

Hi I am trying to match 2 lists together to see if same order numbers from COLa exist in COL B I have been battling with this for hours and everytime it looks good I sort by N/A and some of the items in COl A still exist in COL B but it sayd N/A. please see sheet attached any help is...

im doing a workbook with 10 sheets each sheet has a list of names I need to make a summary page that can put all the names that are added or subtracted on a monthly basis please if any one knows how HELP ME :confused::confused::confused::confused:

What is the code for each column, add the totals and display the column total two rows below the last ow of data? And for each row, add the total and display the row total two columns to the right f the last column of data?

Hi there! I'm trying to create a button that saves the information thas is in predifined cells of a Worksheet onto a PDF document on a specific location and resets the value of the cells! I hope I was clear enough explaining it... Thank you!

Hi All, I wonder if anyone can help? I have a workbook with a number of active sheets, I am wanting to be able to create a button that allows the user to upload an image from their computer to a particular cell. I wish to be able to create a fixed size for this image so it crops it...

Hello everybody. For a particular loan, having disbursement date, interest rate, disbursement fee, maturity.... how in excel to calculate the yield on this loan, in ONE formula? I have tried "yield" formula, however - it is for securities, bonds... not for loans granted. IRR will not work for...

Hi Everbody, I have a macro code done in a spreadsheet but i need it to work in a Mac's excell, could somebody help me make it works? There is the code i wrote. Since now, thank you very much!!! '========================== Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _...

Hello, I need to find the same 3-4 symbols or signs in 1 or 2 columns (but as one whole string), and mark them as duplicate in another column, or just mark them with color, or maybe extract that same cells in other column. example: A 1 qw34-5-23789 2 zw34-59asdaz 3...

I'm a new member to the site and need some help with a few things. I am relatively new to excel and thought that this might be a good place to start. I have made a set of pivot tables and want one slicer to control them both, I have tried using the pivot table connections option that is...

I want to use multiple worksheets (one for each month) within a workbook. The Pivot table was set up and worked great with just the one sheet. How do I get it to look in all the sheets? I can use either 2007 or 2010 versions of excel

Hi all, I've got a project where I need to calculate the time passed between an acceptable range. For example E-mail was received at 19:00 and a response was sent at 09:00 The acceptable range is 8am to 6pm so in the scenario it should return 60 mins. Another example is if the email was...

Hi forum, I'm trying to create a workbook that (when done) is able to insert autoshape depending on the variable of a cell. F.x.: if cell sheet!1 A1 == 1 then insert autoshape_1 from Sheet!2 in cell B2 insert into autoshape_1/cell B3 "value from cell A2" if else sheet!1 A1 == 2 insert...

Hi Ladies and Gents, I have been reading through some of the older questions and couldn't put together my answer without asking for help. Basically what I am looking to do is take a serial number and have it increase by one. The problem however is that the number ends with a letter not a...

Hi guys please i need urgent help can anyone help me with a micro that looks a the situation below . You will see that the item code appears against the first line only and is blank where there is a second line. Are you able to write a macro that looks for the blank in column A and then brings...

Morning I need your help please :warning::eeek: I have a spreadsheet full of data, for closed files and open files. These are a mixture of claimed and saved amounts for different insurance companies for files we have closed, as well as open files (so savings tbc, but will soon be changed to...

I have a question about to copy and paste in excel. I wrote a macro so he copy a template, but if he paste, he don't paste the pictures too. So then i uses copypicture, but then i can't insert values in the cells, what code can i use to copy bouth in one time, or another solution? If you need...

This is my code to copypicture a template from a worksheet, and paste them below each other, so they don't overlap. The code with teller is for counting how many templates he need to paste, because for each subject i need a template. But like , i need 3 templates, he is doing everything like it...

Dear All: I need to hide all of the rows in a spreadsheet (15,000 rows) that have a part number that does not start with M or K. I have found lots of simple macros that do something similar but usually not with any sort of textual evaluation. Any help please?