Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto copy cell data from source sheet to another wrkbook sheet
I have set up XLS sheet. Within the sheet are multiple columns and rows
which I would like to auto-copy the cell data into a different sheet in a a different workbook. I have attempted Ron de Bruin's "What if the Database sheet is in another workbook" script from his site. However, it did not work and I do not know enough about de-bugging programing. I did follow the Notes that he had and revised it to meet my specifics. Basically what I am trying to do is (examples cell #'s): When I fill in cells C5:C24, F5:F24, C29:C48, etc. in the specific "source" sheet, I would like to auto populate (?) / copy the data in these cells into a separate sheet in a separate workbook. However, where the "title" of each cell in source sheet is vertical as rows, the corresponding "title" to the cell data in dest sheet is set up in column layout. In addition, C5:C24 represents one row of data on the dest. sheet and F5:F24 would be another row below on detination sheet. The dest column sizes do not need to match as long as the data is transfered automatically. What I am trying to do is: I utilize the source sheet for formulas specific to the collection of cells, I then copy/paste special into Word doc. However, when I enter the information, I want to auto create a data base, so I can in the future go into the data base and "pull in" information that I have utilized on prior reports/xls workbook. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
copy data of two cells from Sheet 2 into one cell in Sheet 1 | Excel Worksheet Functions | |||
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. | Excel Programming | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
How to copy a sheet and rename it with the value of two cells from the source sheet? | Excel Programming |