| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from data sheet
Hi everyone. I have a large data sheet, with the first 6 columns of
data I need. Column 1 of the data sheet is an invoice number. I then have a calculation sheet. In cell A2 of the calculation sheet is an invoice number. Can I have vba scan column A of the data sheet for the invoice number in A2 and return columns 1 thru 6 into the calculation sheet? Thanks!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy data from data sheet
You can, but why wouldn't use use VLOOKUP instead?
-- HTH, Barb Reinhardt "Steve" wrote: Hi everyone. I have a large data sheet, with the first 6 columns of data I need. Column 1 of the data sheet is an invoice number. I then have a calculation sheet. In cell A2 of the calculation sheet is an invoice number. Can I have vba scan column A of the data sheet for the invoice number in A2 and return columns 1 thru 6 into the calculation sheet? Thanks!!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy data from data sheet
Because I have multiple instances of the same invoice number. I need
to copy in every instance of the given invoice number. Thanks! On Mar 24, 3:54*pm, Barb Reinhardt wrote: You can, but why wouldn't use use VLOOKUP instead? -- HTH, Barb Reinhardt "Steve" wrote: Hi everyone. *I have a large data sheet, with the first 6 columns of data I need. *Column 1 of the data sheet is an invoice number. *I then have a calculation sheet. *In cell A2 of the calculation sheet is an invoice number. *Can I have vba scan column A of the data sheet for the invoice number in A2 and return columns 1 thru 6 into the calculation sheet? *Thanks!!!- Hide quoted text - - Show quoted text - |
| Reply |
| 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) | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| Copy data from sheet 1 to sheet 2 based on day/date | Excel Programming | |||
| Data copy from a seperate sheet to data sheet | Excel Programming | |||
![Steve[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
