Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste VBA command - anybody help me?
Question 1: I have this VBA command that copy (from a database) and paste som numbers into (what I would like to be) an table. Right now I past these numbers in row 4, column 2, 3, 4 and 5 (that is B4:E4). M problem is: I need a command that makes Excel look in the database copy data if not blank, and then paste them into the table in row 5, and so on - until there is no more data to copy from the database? I other words, I would like to replicate the command I have, but plac the data in the next available row - and do this until there are n more data in the database. Question 2: Then, I need a command that copy the range name from the database (fo example: Excelforum Inc.), which could be found in row 1, and paste i into column 1 (e.g. "A") in the table? Of course, I want this names t be pasted at the correct row, that means the row that the numbers fro question 1 are pasted into. Kind regards xtia -- xtia ----------------------------------------------------------------------- xtian's Profile: http://www.excelforum.com/member.php...fo&userid=3481 View this thread: http://www.excelforum.com/showthread.php?threadid=54573 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste VBA command - anybody help me?
Hello Xtian, Which database are you using? Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=545739 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste VBA command - anybody help me?
Hello! It is an Excel Workbook - let us call it "Database.xls". -- xtian ------------------------------------------------------------------------ xtian's Profile: http://www.excelforum.com/member.php...o&userid=34816 View this thread: http://www.excelforum.com/showthread...hreadid=545739 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste VBA command - anybody help me?
Hello Xtian, Can you show me an example of how the data are arranged in Database.xls? Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=545739 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste VBA command - anybody help me?
Database.xls (I am not sure, because I do not have the database here right now - it might be the opposite direction -- "A1": Name, "B1" to "E1": Numbers): "A1": Exelforum (name) "A2": 200 "A3": 123 "A4": 34 "A5":1 "B1": name02 "B2": 100 and so on... Therefore I want to copy these numbers until there is no data in the column... "A1" equals cell A1... -- xtian ------------------------------------------------------------------------ xtian's Profile: http://www.excelforum.com/member.php...o&userid=34816 View this thread: http://www.excelforum.com/showthread...hreadid=545739 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions | |||
selection.copy - how to emulate Paste command? | Excel Programming | |||
selection.copy - how emulate Paste command? | Excel Discussion (Misc queries) | |||
I want to combine a "match" command with a copy and paste command. | Excel Programming | |||
copy & paste command button | Excel Programming |