Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving data from one spreadsheet to another
I have 2 spreadsheets: SheetA and SheetB. SheetA is a list of names. SheetB
is a list of names with specific data about each name. So SheetB Column A has names, Column B has the age, Column C has the address, Column D has total sales for the month, and Column E has hair color. I need to write a macro that will take the first name in SheetA, find that same name in SheetB, copy the info in Columns B, D, E, and paste that info in Columns B,C,D in SheetA beside the name, move to the next name in SheetA and repeat the process. How can I do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
moving on a spreadsheet with arrows | Excel Discussion (Misc queries) | |||
Matching and Moving Data From One Spreadsheet to Another? | Excel Discussion (Misc queries) | |||
Matching and Moving Data From One Spreadsheet to Another? | Excel Discussion (Misc queries) | |||
Moving Around a Blank Spreadsheet | Excel Worksheet Functions |