Help me

[gvzin]

How do I get a name as a number in sequence every time I use the "paste" function? example: the first time you use it, it should generate name1, the second name2...

 

[shao66]

How do I get a name as a number in sequence every time I use the "paste" function? example: the first time you use it, it should generate name1, the second name2...

I think...

To generate a name as a number in sequence every time you use the "paste" function, you can create a formula using a combination of text and a cell reference in Excel or Google Sheets. Let's assume you want to start with "name1" in cell A1 and increment the number by 1 each time you paste. In cell A1, you can enter "name1," and in cell A2, you can enter the following formula:

=CONCATENATE("name", (RIGHT(A1, LEN(A1)-4)+1))

When you paste this formula in cell A3, it will automatically generate "name2" based on the value in the previous cell (A2). Each time you paste, the number will increase by 1. You can copy and paste this formula as many times as you need to continue the sequence.

 

[Endercraft]

I think...

To generate a name as a number in sequence every time you use the "paste" function, you can create a formula using a combination of text and a cell reference in Excel or Google Sheets. Let's assume you want to start with "name1" in cell A1 and increment the number by 1 each time you paste. In cell A1, you can enter "name1," and in cell A2, you can enter the following formula:

=CONCATENATE("name", (RIGHT(A1, LEN(A1)-4)+1))

When you paste this formula in cell A3, it will automatically generate "name2" based on the value in the previous cell (A2). Each time you paste, the number will increase by 1. You can copy and paste this formula as many times as you need to continue the sequence.

Will you stop AI generating answers that are not even related to MacroDroid and insert a hidden link inside, I can see it every time.. But thanks for your contribution (kind of) in your quest of getting someone to this website !

 

[gvzin]

I think...

To generate a name as a number in sequence every time you use the "paste" function, you can create a formula using a combination of text and a cell reference in Excel or Google Sheets. Let's assume you want to start with "name1" in cell A1 and increment the number by 1 each time you paste. In cell A1, you can enter "name1," and in cell A2, you can enter the following formula:

=CONCATENATE("name", (RIGHT(A1, LEN(A1)-4)+1))

When you paste this formula in cell A3, it will automatically generate "name2" based on the value in the previous cell (A2). Each time you paste, the number will increase by 1. You can copy and paste this formula as many times as you need to continue the sequence.

Can you help me make the macro to send A1 to the clipboard then A2, A3... I still don't know how to use the functions correctly

 

[shao66]

Can you help me make the macro to send A1 to the clipboard then A2, A3... I still don't know how to use the functions correctly

To create a macro that sends cell values from A1, A2, A3, and so on to the clipboard in Excel, you can use VBA (Visual Basic for Applications). Here's a simplified example:
Sub CopyToClipboard()
Dim i As Integer
Dim cellValue As String

' Loop through rows starting from 1 (A1) and incrementally copy to clipboard
For i = 1 To 3 ' Change '3' to the number of rows you want to copy
cellValue = Cells(i, 1).Value ' Assumes data is in column A, adjust as needed
Clipboard.SetText cellValue ' Copy cell value to clipboard
i = i + 1
Next i
End Sub
This code will copy the values from A1, A2, and A3 to the clipboard. You can change the loop limit in For i = 1 To 3 to copy more rows, and adjust the Cells(i, 1) reference to target a different column if necessary. Run this macro from the VBA editor in Excel.

 

[Dm114]

To create a macro that sends cell values from A1, A2, A3, and so on to the clipboard in Excel, you can use VBA (Visual Basic for Applications). Here's a simplified example:
Sub CopyToClipboard()
Dim i As Integer
Dim cellValue As String

' Loop through rows starting from 1 (A1) and incrementally copy to clipboard
For i = 1 To 3 ' Change '3' to the number of rows you want to copy
cellValue = Cells(i, 1).Value ' Assumes data is in column A, adjust as needed
Clipboard.SetText cellValue ' Copy cell value to clipboard
i = i + 1
Next i
End Sub
This code will copy the values from A1, A2, and A3 to the clipboard. You can change the loop limit in For i = 1 To 3 to copy more rows, and adjust the Cells(i, 1) reference to target a different column if necessary. Run this macro from the VBA editor in Excel.

You are not on the right forum: this one is for MacroDroid, not for VBA, nor Excel!

So please be kind enough not to write about anything else than MacroDroid here.

There are plenty of forums and discussions on the Net about what you were explaining...

 

[Endercraft]

You are not on the right forum: this one is for MacroDroid, not for VBA, nor Excel!

So please be kind enough not to write about anything else than MacroDroid here.

There are plenty of forums and discussions on the Net about what you were explaining...

Nah it's just some ChatGPT bot trying to put spam links but failing.

Some spammers even have a list of their spam posts :

mixed

Sheet1 <a href="https://www.hackerrank.com/challenges/fp-hello-world/forum">https://www.hackerrank.com/challenges/fp-hello-world/forum</a>,<a href="https://www.party.biz/forums/topic/141846/wellcome-our-site/view/post_id/1417954">https://www.party.biz/forums/topic/141846/wellcome-our-site/view/p...

docs.google.com