Excel formula to copy number of rows?

Hi welcome to the forum,

This will be macro work and it's not really that difficult but I've no idea waht your sheet's layout looks like and very important you should always mention the version of Excel you're using because of functionality in the most recent versions which si no longer supported in the older versions (2003 and older)

There are quite a few postings, I don't remeber them on this forum with similar requests but I don't remember the poster's names, you could use and advanced search.

If you attach a sample file I could take a look and make some suggestions

 

your key words are copy cells, copy range you name it.
You need a least a minimum of idea what you want and need before you start asking.

Google is a perfect search engine for this, but don't let the guessing what you need to others, be concise and try to explain as it is, that will make it easier to understand for the ones that are willing to help.

You can't just walk into a mechanic workshop and say it isn't working.

 

Okay, it's clear and I understand what you need / want, you'll have to be a little patient, but I'll be able to write the necessary macro to do this for you.

If you're going to implement it in another file it may need editting but we'll get to that when the time comes, first see if what I can do for you is what you really wanted to achieve.

 

Well, it was easier that I thought.

I've attached the macro enabled version (xlsm) and the macro is in module1

You will need to allow macro's if you want this to work.

Press the keycombination Shift Ctrl K to run the macro or just run if from the macro menu

It will add the number of rows for that person for that decription in sheet 3 and if successfull the values in the input sheet, Sheet1 will be removed to avoid repetion.

For those combinations Name / Description not found the value remains where it is.

I've not added much comments to the vba code but it will work.

The only condition for this macro to run correctly, should you move it to another sheet then you will have to enter the sheets names in the correct places in the macro code:

Search for "Sheet1", "Sheet2" and "Sheet3"
and replace these three values with your sheet names.

You only need to it at the beginning of the macro since I use varaibles to address these sheets.

 

BTW, the macro is built in such a way that you can add columns and rows to Sheet1 (the input sheet).
I did not hardcode the range you have but coded it to allow for expansion.

 

If you stick to the column layout you have now it will work without a problem.
Learning, well just check for VBA tutorials via Google and practice onyour own recorded macros, that's the way I started several years ago

 

Have you tried it?

 

I'll check it, you probably want to keep the cigars for yourself

 

Well, Catherine is not in the database sheet so it doen's work