| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching column "A" then Moving Right
I am looking for a Macro that will... Starting in "sheet1" take a varying number from a fixed cell referenc ("F6") Copy cells ("A1:A5") - in sheet1 search for the contents of ("F6") in ("Sheet2") column ("A:A") Move right to the first empty cell at the end of the relevent row, the paste the contents of cells (A1:A5) that were copied from ("sheet1") Can anyone help with this? Regards, Marcu -- Tomp ----------------------------------------------------------------------- Tompy's Profile: http://www.excelforum.com/member.php...fo&userid=1473 View this thread: http://www.excelforum.com/showthread.php?threadid=27692 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| Moving "sort by column" | Excel Discussion (Misc queries) | |||
| Moving between "row" and "range" formats in VBA | Excel Programming | |||
![Tompy[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
