method

I have two questions and wondered if someone might be able to help me with them. 1) Is there a method whereby when I update a pivot table it pushes the update\change to the original worksheet data? 2) Similarly is there a method whereby when a pivot table element is clicked on and then opens...

Hi there, is there an quicker method to perform the following on 'ActiveSheet"? Thank You For Each cell In ActiveSheet.Range("h2:h" & lr) cell.Formula = Replace(cell.Formula, "ACA", "ACA/52") cell.Formula = Replace(cell.Formula, "ACB", "ACB/18") cell.Formula = Replace(cell.Formula, "ACG"...

Hello I need to find a way to search a tab of data for results and then display specific results based on that and I have no idea what method I would use to go about that. I have a sheet that looks like this and on another tab I need a formula to return value of the cell in Row D if certain...

No of units. Price/unit. Method. R/ unit 1. 70. Ship 1 10. 60. Truck. 1.5 100. 50. Road. 2 200. 40. Rail...

Hello Excel Geniuses. Every time I log in I learn how much I don't know about Excel. Thanks to you all. Here's my latest conundrum. I have a workbook template that is populated externally. When this template is opened, VBA code uses takes that data and organizes it, adds formulas, populate...

This is my data: 300, 300, 300, 300, 300, 20300, 20300 Looking at it, I would say the last two values, 20300, are outliers. However, following this method...

Hi Team, I am trying to convert the the number which are in text to number Numbers in few column(C:C and I:I) getting deleted. below are two method getting same result, plz suggest any best method to tackle this task. Sub Convert_TextNumber_Number() Dim ws As Worksheet Set ws =...

Hi, I open two or more workbooks on my computer. I am using the syntax: Call macro_name to call another macro in a module from the same workbook I am in. But sometimes it tries to call from another workbook where not found and throw the error like: Method name of method not found. Any help...

I'm trying to generate a script that locates the last row with a value contained within it and store it in a variable. I then use said variable in a range and then copy the data from an external (closed) workbook. I am able to see that it copies the data correctly, however when it gets down to...

Hi,I want to create different sizes of rectangles with inputs. Then I want to optimally place these dimensions in a specific area (ex: 80cmx160cm). I using method that start with biggest rectangle following firstly go bottom after move left if possible. Actually this method the same with tetris...

Greetings, Not sure what I am missing here...looking to assign an integer value to a column c = Workbooks("Matrix.xls").Worksheet("Paper1").Cells(1, Columns.Count).End(xlToLeft).Column Thanks!

Can someone assist in understanding the Find Method, in particular the following within lastrow LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Thank You

Can anyone help? I am needing to write a code in monte carlo method to solve the integral from 0 to 1 for the function e^-xdx. I am struggling with this project. This code should start with an amount of 10,000 and increase by 5,000 until the difference between the answers is less than 0.001. I...

Hi All, I am wondering, if there is a way to combine columns in a table? For example, if there are 7 table columns across 7 rows, can one merge its "cells" to one column? Please let me know, if there is a method to accomplish this task. Many thanks in advance. R/ Pinaceous

I need a method to convert a jpeg file to bmp through VBA - does anyone know if this is possible?

Hello everyone, I got into discussion with my friend a couple of days ago in regards to Range.Cells and its usage. How I understood this method so far is that, if for example you have Range("A1:C3") and you say Range.Cells(2,2) it would refer to second row second column in my range, which...

Hi everyone, I try to use VBA to close an excel file without saving and without prompt. I've tried many methods below (pasted below) but still cannot do it without the prompt. I figured it was probably because I am in TM1 Perspectives. Can anyone please help me find a solution? Thanks a...

Hi all, The following formula is from one of the bosses spreadsheets. He is a heavy spreadsheet user but his formula skills stop around =a1+b1. He is a huge fan of copy/paste. So needless to say there is a lot of 'fixing' to be done, by yours truly. I am usually able to figure out what he did...

How to transform the code below into VBA Code (or another method)? IF(COUNTIF(Data!$1:$1,A2)=0,0,COUNTIF(Data!$1:$1,B1))+ IF(COUNTIF(Data!$2:$2,A2)=0,0,COUNTIF(Data!$2:$2,B1))+ IF(COUNTIF(Data!$3:$3,A2)=0,0,COUNTIF(Data!$3:$3,B1))+ . . ...

I need to move a series of cells from various sheets to a new "master" sheet. Some are text, some are numbers, some are percents and two are dates. Is there a method or cell attribute assignment that will do this for me? Thanks