Hi
I have a spread sheet with 500 lines - where half of them have to be with one number and the other half with another.
but unfortunatly is is every other that needs a different number.
At the moment the whole row is called 00000000000105770. I need every other to be 00000000000105750.
How do I do that?
Hi,
- Pop 00000000000105770 in B1, 00000000000105750 in B2.
- Select B1:B2 and Copy.
- Select B3:B500 and Paste.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
or this:
=TEXT(105750+20*MOD(ROW(A1),2), "00000000000000000")
Sorry forgot to say that every 1. line has a totally different text.
I think i might need a macro that can do it....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks