copy formula across multiple sheets

Results 1 - 10 of about 964 for copy formula across multiple sheets

Copying formulas to multiple worksheets

Forum - Excel

Best answer: mmikey45, Good morning. Suppose your sheets have the name: Plan1 Plan2 Plan3...Plan31 You want sum an A10 cell about all sheets. Try to do: At SUMMARY, any cell:...
Excel - Apply a function to all sheets

How-To - Excel

I have an Excel file consisting of hundreds of sheets. I would like to apply a function (count, for example) to all cells in E3, how can this be done quickly? A simple solution is to select all...
Copy formulas across workbook

Forum - Office Software

Best answer: Alternatively, just paste it in with the links and do a find replace. Paste the link information into find, and replace with "". Replace all. Worked good for me....
Excel Macro: Copy formulas across worksheets

Forum - Excel

Best answer: Ok try this This macro needs to goto to the destination workbook. Destination workbook will open the source workbook. You need to correct the path of the source workbook. The macro...
Copy formulas from one sheet to another all at once

Forum - Excel

Is it possible to copy formulas from one sheet to another all at once? I have a worksheet that I would like to use as a template and I'm having to copy each of the cells formulas one by one....
Auto-populate info. from master sheet to multiple sheets

Forum - Excel

Best answer: Hi Kvil, I think you are in need of the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Columns("Q")) Is Nothing Then Exit Sub...
Lookup across whole workbook (multiple sheets)

How-To - Excel

I would need your help with my problem in MS Excel. Description: 1. I have an excel workbook containing multiple sheets (ca. 15-20) 2. Each of the sheets contains several records of the products...
Excel - Change date automatically

How-To - Excel

Issue Solution Note that I am using this formula on my work sheet: =IF(OR(A1=1, A1=2, A1=3), TODAY(),"") The problem is that when I open my sheet the next day all the entry dates change to today,...
Excel - Transposing data from one sheet to another

How-To - Excel

Does someone can tell me how to make transpose data between two Excel sheets? I want to bind data: from a column to a row in another sheet. Consider that the data to be copied are on Sheet1! B2:H2...
Prepare Grades from Marks on Excel

How-To - Excel

Mathematical and logical operations can be performed on a Microsoft Excel workbook with the help of formulas. One of the most common uses of Excel is to compare rows of data by using an IF...