| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Auto insert data to seperate sheets?
OK m8, many thnx for that :)
g2k. "bgeier" wrote in message ... It is possible, but can be rather complex. To do it, you would put your data into sheet 4, then set the criteria to paste to which ever sheet you want. Once the criteria have been set, select the cells you want pasted to the respective sheets, then search for the insertion point and insert. It would have to be done in VBA because of the volitility of the data -- bgeier ------------------------------------------------------------------------ bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822 View this thread: http://www.excelforum.com/showthread...hreadid=545981 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping data updated between 2 sheets... novice needs help. | Excel Discussion (Misc queries) | |||
| Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
| Auto date/time insert when data entered into an adjacent cell | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Threaded Mode
