Repeating Lines

[roey]

Hi,

We are about to move into a new building and so have recently completed an audit of our existing equipment and furniture. Now that has been completed, we are needing to compare this with the list of what is required for the new building.

The Audit sheet lists every item, by its item code and its specific ID number i.e. there isnt a qty column as each item is listed seperately down the page.
The Requirements sheet groups the items by their item code and gives an overall qty in the qty column.

We are now needing to compare these and also allocate the Speciific ID's against each item in the Requirements sheet.

Is there an easy way to list out these grouped up items? So, if there is a '6' in the qty column, then it would repeat that line 6 times??

I apologise if this doesnt make much sense. I am finding this hard to explain!

 

[Special-K99]

Take a look at Pivot Tables, may be something what you need there

 

[Weaver]

If you applied the pivot table to the data in the audit sheet, you could count the individual occurences and then compare this with your requirements that way, but to do the opposite and list requirements line by line in order to compare the audit sheet is probably going to require some custom vb code.

 

[roey]

Thank you for the replies. I do think I need to look into VBA for this one. Would anyone know of a macro out there that I could copy and paste into my sheet?