VBA - Fill data Macro
Hi Guys,
This is my first post and I don't speak english very well.
I have a problem. I need to fill blank spaces with the first code until it changes for another one. My file has more than 130.000 files, thats why I need your help with a Macro or anything usefull
Please see the first picture
Capture.JPG
The idea is to get as a result something like this
Capture2.JPG
Thanks for your time, I hope that I've explained well the idea.
Best regards
Try one of...
Manually...
Fill range with values from cell above
- Highlight range from first cell to last
- Select F5 >> Special >> Blanks >> OK
- Press "=" sign one time then up arrow one time
- Press Ctrl + Enter
- Highlight range >> copy >> paste special as value
With a macro...
Paste code in a Normal module
Please Login or Register to view this content.
- Where to paste code
- Highlight macro to copy >> Ctrl + C >> Open your workbook
- Alt + F11 >> opens the Visual Basic Editor (VBE)
- Ctrl + R >>opens the Project Explorer (if not already open on left side of screen)
- Insert menu >> Module or Alt + I, M >> activates the Insert menu and inserts a Standard Module
- Paste code >> Ctrl + V (right side of screen)
- Alt + Q >> exits VBE and returns to Excel
- Back in Excel >> Alt + F8 >> Macro Dialog Box >> Highlight macro >> Run
HTH
Regards, Jeff
Amazing, Thanks a lot, I did it manually, but I want to try the macro and learn a little bit how it works
You're my new best friend
Again, Thank you
Best regards
You are very welcome and glad it worked out for you.
Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks