+ Reply to Thread
Results 1 to 3 of 3

Concatenate Strings with Do Loop with dynamic column and files

  1. #1
    Registered User
    Join Date
    01-08-2017
    Location
    Barcelona
    MS-Off Ver
    Office 2019
    Posts
    82

    Concatenate Strings with Do Loop with dynamic column and files

    Hi everyone

    I try to get some work done but for some reason I don't achieved. It barely works but not obtain the result I want.

    I want the macro to get the data form different sheets (I define which at the Asign page) and show the data of prices at Diary. I need to do this way because the sheet data will decrease and increase (always with the same structure) and I want to actualice diary easy. I make with an array and a Loop in each column in Asign

    I put the code and a Test file with some sheets with data and with a macro for the B column on Asign, The idea is make one Madrofor each column my boss define at Asign. In a fantastic world I get at diary concatenate the name of each product I put at the deferents sheets at B1 concatenate and easy to read. Instead of that I get false.
    Please Login or Register  to view this content.
    Any suggestion will be appreciated
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Concatenate Strings with Do Loop with dynamic column and files

    Maybe you could explain what the code is trying to do, and possibly show the end result in your example.

  3. #3
    Registered User
    Join Date
    01-08-2017
    Location
    Barcelona
    MS-Off Ver
    Office 2019
    Posts
    82

    Re: Concatenate Strings with Do Loop with dynamic column and files

    Hi, sorry for the delay to answer, I just arrived home now.

    I have one sheet model to input the data with some columns with price and datas. When you mark with a code the day implies that some discount are applied to this product / day. We may have a lot of products and prices.
    Also you have a summary sheet who takes the data from the sheets. At assign sheet you indicates the sheets where data are for this type of product and price. But the estructure of summary sheet is not exactly to the data, it have two columns for price, to show the two types of discounts.
    At the example I use a code in all the cells to check the function of formulas, but normally not the days are marked with codes.

    So I want to concatenate all the sheets I indicate at Assign column for each product, showing the name of product (value B1) and in order to drag the formula for the two columns i use two references for select cells (variables x, y, z, i). To concatenate the values I use and R1C1 formula and use a loop for each sheet name (I store at Data) and for all the file (using temporal variables to store the concatenate data and not delete it with the interactions).

    Finally, for clarify, I want to get at Diary two first columns the concatenate values of same cell from the diferents sheets I indicate at Asign and only if they have some value cell (Code) I use to separe the different discounts.

    I make like that to create a dynamic and easy way to actualise the sheet raw data dynamically for my boss who drives crazy with the code and he can not use it.

    I hope I explain myself, if you have questions don't hesitate to ask. 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. Concatenate strings from column with each strings from other column
    By iwian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2017, 03:26 PM
  2. How to concatenate two strings from two different .dat based text files using VBA
    By mahendra.asapu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-04-2015, 06:25 PM
  3. Concatenate Strings to specified column until last row
    By mvneema in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 03-26-2014, 04:37 PM
  4. [SOLVED] Loop through strings stop when strings change and start looping in the next column...?
    By Prexcel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-18-2013, 03:31 AM
  5. Replies: 1
    Last Post: 12-20-2012, 04:18 PM
  6. [SOLVED] loop to match if shorter strings appears in longer strings
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2012, 08:07 PM
  7. Replies: 2
    Last Post: 04-12-2010, 12:35 PM

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