individually

I need to put a pivot table/chart together for data that is in 4 tabs of my excel spreadsheet, however I haven't figured out how to do so. I can do it for each tab individually no problem. any help would be appreciated. Thanks.

Hi, I have an excel sheet with a whole heap of functions in each column, and when I insert a new column I'd like to have the functions automatically populate the new column without having to drag the rows into it individually. Is this possible? Thanks :)

Hi. I'm trying to report on 100 customers. A select 20 I want to list individually every month, these are not necessarily the top 20 but a select 20 and the other 80 I just want a combined total and not to be listed individually. I can get the select 20 without any trouble but I can't find a way...

Hi, Does anyone know a Formula / Function that is similar to CONCATENATE but don't need to individually select values? Thank you.

Hi i am trying to get this piece of code to work and i cant figure out why it isnt working. All the variables are assigned and it works if i only use the one criteria. Can anyone help me to get this to work When i use it it comes back with a 1004 error WTL.Range("WTL").AutoFilter Field:=3...

https://paste.pics/b10ffadd0ed8462a39d6bc8608bf6258

I started the macro below which sorts rows 1-3 individually from smallest to largest. It sorts B1:E1,then B2:E2, and then B3:E3. The code is the same for each row of the worksheet with the exception of three minor changes in the code due to moving to the next row. I need this macro to...

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 have a sheet that i would like to copy and paste a formula across 100 columns, however Sheet 1 (data) has 100, and sheet 2 has 200. The reason for this is Sheet 2 pulls in the data then each Column has an additional column next to this for manual in put or a value. Sheet 1. Column 1 2 3 4...

I am trying to Create a Bubble Chart With the following data I would Like the x-axis to be the top row (Red Numbers) and the y-axis to be the Left side row (Blue Numbers) with the bubble size being the data in the middle. I have been unsuccessful in having Excel Plot this data correctly...

I have this block of cells in my spreadhseet numerous times. <colgroup><col><col></colgroup><tbody> Head Mar Wife Mar </tbody> Is there any way I can replace it with <colgroup><col><col></colgroup><tbody> Head Mar Wife </tbody> Without deleting each one individually?

Hello, Long time viewer of this site, first time poster. I'm not sure if this is possible, but is there a way to combine these two formulas into one? =IFERROR(LEFT(D2,FIND(" ",D2)-1),D2) =IF(LEN(D2)>9,LEFT(D2,LEN(D2)-20),D2) Both work great individually, but I really need to combine them. I...

Need VBA code for Macro - to Run a "Remove Duplicate" for each and every column in the excel sheet (individually) I have 190 Columns - Which have duplicate values in them. Need to remove Duplicate for Each Column individually Eg :

Hello guys and girls, I have a spreadsheet of 59 columns and 3000 rows that I need to do some sorting. The rows are supposed to be groups of 2 and I need to sort this groups of 2 individually based on the first row. Example not sorted yet, Example sorted from smalletst to largest. I...

I have been trying to find a method using VBA that would allow me to have a generic code to use. I have about 20 sheets and each sheet has from 2 to 20 checkboxes (form not activex). How can I make the code without having to do each and everyone individually?

Hello, Would anyone know if it's possible to create a macro copying data from an excel spreadsheet into a SharePoint 2013 list? I have two excel spreadsheets delivered to my email and I would have to manually copy and paste each field individually for sometimes 15 or on rare occasions 200...

I get this error: Run-time error '1004': Method 'PrintOut' of object '_Worksheet' failed When I run this code: Dim printSheet As Worksheet For Each printSheet In ActiveWorkbook.Sheets printSheet.PrintOut Next printSheet And it is driving me crazy. All I want to do is print each...