I have days in Col A and max days in cell G1
I would like a macro to extract from 1 in A2 up to the maximum in that is Cell G1 in Col A2 onwards
I have attached a sample file
It would be appreciated if someone could assist me
I have days in Col A and max days in cell G1
I would like a macro to extract from 1 in A2 up to the maximum in that is Cell G1 in Col A2 onwards
I have attached a sample file
It would be appreciated if someone could assist me
Last edited by Howardc1001; 01-09-2019 at 01:46 PM.
Sorry Howardc1001,
I am not sure what exactly you want? can you provide some sample of the desired result?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
You can put this formula in cell A2:
=IF(ROWS($1:1)>$G$1,"",ROWS($1:1))
then copy it down as far as you like.
Hope this helps.
Pete
Thanks for the help Pete, formula works perfectly
Glad to hear that - thanks for the rep (and to Arkadi).
If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark this thread as SOLVED.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks