I have...
="WCSS " &1
which reads as...
WCSS 1
now I need it to continue down the column, adding 1 each time, ie...
WCSS 1
WCSS 2
WCSS 3
etc etc
Thanks for the help
I have...
="WCSS " &1
which reads as...
WCSS 1
now I need it to continue down the column, adding 1 each time, ie...
WCSS 1
WCSS 2
WCSS 3
etc etc
Thanks for the help
If it's in Row 1, try ="WCCS "&Row() and drag down.
If it starts in Row 2, ="WCCS "&Row()-1, etc.
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
(in essence you have the same answer in both)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Perfect! Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks