combined

hi, I am trying to create a chart that contains both a clustered and a stacked bar chart. The stacked bar chart contains balance sheet data of two segments of a company in 2017. I also have the combined data as at 2018 so I want the 2017 and 2018 data to be a clustered bar chart for comparison...

My Data basically looks like the table below... I'm trying to figure out a formula that will look up the letter in Sheet 2 find the corresponding letter in Sheet 1 and then determine the average of the 2017 and 2018 corresponding month. For example For the letter A the formula should return...

Hi all, I need to enhance the formula: =IF(INDEX('Salesforce Combined Data'!$P$3:$P$9999,MATCH($B4,'Salesforce Combined Data'!$C$3:$C$9999, 0))<>"","*","") Right now, it checks if there is a value in a cell on another sheet. If so, instead of showing the actual value, it shows an asterisks...

I would like to be able to pull and combine data using drop down lists..so for example, I want to analyze financial information on my properties all combined as well as individually. So in my drop-down list say I have these to choose from: ABB LLC (combined) Apple Street Gold Street Blue...

I have the following problem with VBA: I have a list of names of persons with a rank (either "1" or "2", see below) and I want to search their number of occurrences in another table and add up the ranks. Person Data: <tbody> Person Rank A 1 B 2 K 2 P 1 U 2 T 1 ... ...

Hello, I have ben using this code to combine all the sheets in one workbook into one sheet then delete the all but the combined one. It has been working fine but I just found out that if there is just a header row it copies the header row into the combined sheet. I don't want any header rows...

Hi all I have been stuck on this for some time now and would appreciate some expert advice... I have column A and B which both have a very simple formula in all the way down to row 500 which simply pulls in the data from another worksheet within the book in this case it is a name. The...

sheet 1 - I have a first name in 1 box and a surname in another. I then combined them using '&' in a formula, with a space, and pasted values so I now have first name space surname - I then tried to lookup that name in Sheet 2, and bring back a value next to it. My issue I get #n/a as the...

Hello all, I have a workbook with around 500 sheets. All sheets look the same, same number of columns, etc. I need a vba to copy the content from all sheets into a new one and paste them one after another. Here is what i managed to do until now... Sub Combine() Worksheets.Add Sheets(1).Name...

Hello: I have the below statement that combines all worksheets into one. Essentially, it combines all into one called "Combined Reports". However, I would like to rewrite the sub so that a sheet called "emailList" is not combined into the report. Any help will be appreciated. Sub...

Hello! I attached an excel workbook with 2 worksheets. The worksheet An 1 implementare includes in the range A72:A87 a set of products (Lapte, Vitei 3 luni etc.), each one of them being manufactured as conventional or organic food. In the worksheet Situatie generala – lei , each product was...

Having issues with this macro ... It's copying the headings which is great, but I need it to automatically copy as much data is on each tab, and then move to the next tab. Any tips? Thanks! Sub CombineAllTabs() Dim J As Integer Dim s As Worksheet On Error Resume Next...

Hi, Really hope someone can help me I have the spreadsheet attached here I want to create a pivot table the same as what I have already created based on the combined TAB (which is just both In & Out Tabs combined to one i'd like to be able to do that without the need to have all the...

All of a sudden the 2nd part of this coede (where I Paste Special the last part) stopped working! The error i'm getting is "Run-time error '1004': PasteSpecial method of Range class failed Any suggestions? Sub Copy_Transpose_Paste_Prices() ' ' Copy & Paste Categories ' Dim Last_Row5 As...

Hi, I have multiple sheets in given workbook and I would like to combine them in one excel sheet. After I combine in one sheet, from the combined sheet I would like to remove the duplicate. I was able to find macros to combined all in one sheet but i was not able to find macro for removing the...

<tbody> Date Group Code Remarks 06/02/2017 1 combined 01/01/2018 1 combined 03/02/2018 1 combined 01/05/2017 2 nope 01/06/2017 2 nope 01/08/2018 3 combined 09/09/2017 3 combined </tbody> hi guys is this possible, if the year of dates within the same group is different i want to...

I have 2 variables/phrases that are needed and trying to combine them to be one string of text dim Variable1 as string dim Combined as string ' set old variable to be value in A1' range ("A1").select activecell.value = Variable1 'Set combined variable....this should be variable 1 and then...

hi Guys, I have data range I need to lookup for: I attached the file so I am looking for unique id as in "Combined Sheet" column A2 I need to produce result in column x,y,z but need to be based on x1 y1 z1 values so its looking for A2 in sheet "Top3FAVData" if x1 =1 for x column and if y1=1...

Hello! I have a Macro (listed below) which works PERFECTLY! It takes multiple worksheets and joins all the data found across all the multiple sheets into 1 Worksheet called "Combined". Unfortunately, I have 1 hidden worksheet called "lists" that I would prefer to keep out of the macro but it...

Hi, I am getting Compilation error in the Sub Sort_Combined_Sheets() Macro code in the highlighted line. Will some one help me in correcting / refining the code Sub club Combined() and Sub Sort_Combined_Sheets() codes please. (First it has to combine and the sort left to right. Sub Combined()...