Search:

Type: Posts; User: promax; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Macro to Map data columns in two sheets and produce data in third sheet

    See my inline comments above
  2. Re: Macro to Map data columns in two sheets and produce data in third sheet

    Dear Oldbrewer,

    Thanks for your help and prompt response, however I have not understood this.
    Note that sheet 1 sheet 2 and sheet 3 are only names I was using. Actually both sheet 1 and sheet 2...
  3. Re: Macro to Map data columns in two sheets and produce data in third sheet

    I have made edits under sheet 3 as also added headers for both sheet 1 and sheet 2. Hope this should make things clearer.
  4. Re: Macro to Map data columns in two sheets and produce data in third sheet

    Many thanks for prompt response.

    This is what I want in sheet 3 - two parts - Part I and Part II

    Part I - information on all items found in Sheet 2:
    SKU ID Product Name ...
  5. Macro to Map data columns in two sheets and produce data in third sheet

    Hi There

    Would be grateful if someone can help develop a macro to solve below problem

    * Sheet 1 is base datafile mapping our master product file with master product file received from our...
  6. Replies
    8
    Views
    36,483

    Re: Run time error 53.. File Not Found

    Dear AlphaFrog, this worked smoothly, many thanks.

    May I ask for one more help - can this be modified in a way where the file path is provided in a box or a placeholder in the excel sheet instead...
  7. Replies
    12
    Views
    47,828

    Re: Macro to rename files

    Yes I did include the complete path of the old file name and also similar path for new file name. eg D:\Test2\oldfilename.jpg and D:\Test2\newfilename.jpg

    One issue is that our old file names have...
  8. Replies
    12
    Views
    47,828

    Re: Macro to rename files

    I tried to use the code originally given by Alluvian. I have mentioned the old and the new file names in column A and B of the excel sheet containing this macro, however I am getting runtime error...
  9. Replies
    8
    Views
    36,483

    Re: Run time error 53.. File Not Found

    I want to use the prog to rename a number of files in a given folder. However, each of the file type is different. I know the new file names along with extension, as also I have the list of old file...
Results 1 to 9 of 9