+ Reply to Thread
Results 1 to 2 of 2

Paste - Offset + Inputbox

  1. #1
    Registered User
    Join Date
    11-02-2021
    Location
    Santa Catarina, Brasil
    MS-Off Ver
    365
    Posts
    1

    Exclamation Paste - Offset + Inputbox

    Hey guys! I hope you are all right.

    I'm trying to make a macro to speed up some of my work, but I ended up crashing... Hope someone can give me some light.

    I want to paste a report (manually) and through some range select (I may be a little stuck tonight, but I believe I've tried everything I know) make use of offset to select the same cells/rows from this pasting in the next empty column and use an inputbox to place something directly beside this pasted data.

    The problem is just selecting the same lines referenced in the collage. I thought of using the selection that remains after the ctrl+v itself as a reference and the offset on top of that, but unfortunately I'm not getting it.

    The report/example is attached.

    I appreciate the attention and sorry, I'm new to English.
    Attached Files Attached Files
    Last edited by Kaneh; 11-02-2021 at 01:40 AM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Paste - Offset + Inputbox

    Holá bem vindo ao Forum,
    There's a section where you can post your question in your own language, Portuguese in your case.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 10-01-2021, 09:14 AM
  2. [SOLVED] Offset to move content with inputbox
    By Sybille in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-21-2019, 04:30 PM
  3. [SOLVED] Use Inputbox to find then select an offset range and print for ALL sheets
    By FuzzyDove in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-23-2015, 02:38 PM
  4. [SOLVED] Copy range and paste using inputbox
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2014, 12:21 AM
  5. [SOLVED] Inputbox ---> Cut Row ---> Paste to next blank row in specified sheet
    By DaDDy ICEPOC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2012, 03:48 AM
  6. Paste multiple ranges by Inputbox and paste it on one slide in powerpoint
    By irfanparbatani in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2012, 10:32 PM
  7. Offset Inputbox function - change cell colour
    By TheLeafs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2011, 08:13 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1