Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Auto insert data to seperate sheets?
Hi,
I have a Excel (2003) workbook consisting on 4 sheets, sheet 1 has 9 columns, sheet 2 has 4 columns, sheet 3 has 2 columns. Sheet 4 is used for new data which will usually stay on this sheet for a few weeks before I manually copy it over to the relevant sheet then manually arrange it. The whole workbook is arranged alphabetically. I would like to be able to insert new data in sheet 4 but at the same time the entered data inserting into another sheet of my choice and in its relative alphabetical row, Is this possible? any help much appreciated many thnx |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Auto insert data to seperate sheets?
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 |
#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 |
Reply |
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 |