Fill text or notepad with info from rows

**ismelloa** · 11-04-2022, 07:07 PM

Capture.JPG
hello guys good afternoon

In my company they're doing a lot of copying and pasting and I'm trying to reduce that.

We have 3 columns for almost 180 employees who need to have authorization or not to sell shares and there is a text where we include the the name, employee number and if they have authorization or not. To speed up I added the vlookup when you type the name, so it brings the employee number and if you have authorization or not.

I would have to copy almost 180 times the text for each employee. Is there a way that excel, or with a macro generate this text already with the values of the columns of each row?

I posted a photo to make it clearer what I meant, if anyone has any ideas or has seen something similar I would appreciate it

**Marc L** · 11-05-2022, 11:22 AM

Hello,

according to your poor picture a VBA demonstration as a beginner starter :

PHP Code:


Sub Demo1() 
    With [A1].CurrentRegion.Rows 
        For R& = 2 To .Count 
            [H6:H8] = Application.Transpose(.Item(R)) 
            ' your other stuff here ' 
        Next 
    End With 
End Sub

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

Fill text or notepad with info from rows

LinkBack

Thread Tools

Rate This Thread

Display

Fill text or notepad with info from rows

Re: Fill text or notepad with info from rows

Thread Information

Users Browsing this Thread

Similar Threads

Sorting a colummns

Fill in info from web link

Auto fill info from one file to another

how do i fill vertical colums with info from horizontal info

[SOLVED] How do I fill info in sheet one and have the same info appear in all sheets that follow

Fill text box with cell info by clicking on a radio button

Fill several comboboxes with same info

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions