Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the interest of saving keystrokes and time, I would like to know how data
from a form on one workbook where the data is entered vertically can be automatically posted via pushbutton to another workbook where the data is displayed horizontally. The data from wkbk 1 form needs to be added as a new row in wkbk2 database. The rows and columns are not transposable So, as an example on the wkbk 1 form column B4 = enters a new row in wkbk2 database posts to column F, wkbk 1 form column B5 = the same new row in wkbk2 database posts to column D, wkbk 1 form column B6 = the same new row in wkbk2 database posts to column C, wkbk 1 form column B7 = the same new row in wkbk2 database posts to column E, wkbk 1 form column B8 = the same new row in wkbk2 database posts to column K, etc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT can I use to get data from 2 worksheets in same wkBK | Excel Discussion (Misc queries) | |||
How do you create a pushbutton lookup control | Excel Worksheet Functions | |||
copy and paste data to last used row wkbk | Excel Programming | |||
Move a sheet to last sheet of wkbk | Excel Programming | |||
double click mouse, move to referenced wkbk/cell | Setting up and Configuration of Excel |