Solved Looking up and copying multiple rows

October 8, 2012 at 15:12:56
Specs: Windows 7

I have an Excel 2010 spread sheet which contains records of sales going back several years. Occasionally I need to produce a report of 1 week's or 1 month's worth of sales to a printable template within the same file but on a different work sheet. Because there can be multiple sales on the same date I can't use the vlookup function, so I have been resorting to copying and pasting. Is there an alternative function that can identify the number of rows that need to be copied and then transfer them?



See More: Looking up and copying multiple rows

Report •

October 8, 2012 at 16:32:38
If the dates are all in one column, some VBA could be written to copy the rows to a new sheet.

We would need to know some more about the layout of the sheet before we could offer any code.

Please click on the following line before posting any example data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

October 8, 2012 at 17:25:43
✔ Best Answer

Thanks for your quick response, however I've managed to figure out a solution without the necessity for coding. By adding some hidden columns before the date column, I've been able to generate a unique code for each entry. Then on the destination sheet I've been able to use a formula to pick up the codes using "vlookup" and "iferror" to avoid those sneaky #N/As, but thanks anyway.


Report •

Related Solutions

Ask Question