| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste formula in numerous worksheets
Hi,
Here is the formula:- =VLOOKUP(A1,'[master list.xls]lower'!$B$1:$B$58112,1,FALSE) The problem is I want to paste that formula in every worksheet within the file, sometimes the file may have 50 sheets, next day could be 60 sheets, following could be 54. Is there any work to copy and paste the formula above into cells c1:c5000 in every worksheet available? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run numerous calculations through a single formula | Excel Discussion (Misc queries) | |||
| Displaying numerous charts evenly in various worksheets | Charts and Charting in Excel | |||
| Summarising Numerous Worksheets | Excel Discussion (Misc queries) | |||
| Adding totals from numerous worksheets | Excel Worksheet Functions | |||
| Sum of cell on numerous worksheets in a workbook | Excel Worksheet Functions | |||
![Stuart[_31_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
