| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying info from one sheet to another
From Mr. Ogilvy and Mr. deBruin, I have
worksheets("Sheet1").Cells.Cop worksheets("Sheet2").Range("A1").Pastespecial paste:=xlFormula I'm having a little trouble with where to put it and how to put it there. I already have code on both sheets to color the cells based on text value. Do I add these two lines at the bottom of the existing code and if so which sheet do I add it to Thanks in advance for any help Erik |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying info from worksheet to worksheet if info matches | Excel Worksheet Functions | |||
| Copying cell info from one sheet to another in the same wkbk | Excel Discussion (Misc queries) | |||
| How do I compare info in on sheet to info in another? | Excel Discussion (Misc queries) | |||
| Opening Multiple files and Copying the info all to one other sheet | Excel Discussion (Misc queries) | |||
| transfering info from one sheet to another based on info being transferred | Excel Programming | |||
![Erik[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
