Posts by Rajat28

    Hi,
    This is a complex one.
    I have an excel file containing supplier responses, names and codes.
    Like any cases pending against you? Yes or No.

    I want the data to be pasted in a word doc against specific headers. The word doc is of Terms and Conditions. For each supplier, the format of doc will be same. But the responses may differ. I want to populate the responses from excel sheet.
    Can anyone help!

    Thanks in advance.

    Hi everyone,I wrote the following code. When I am running the code step by step, it is properly running. But when I am running it as a whole it is not giving me desired result.Please help.


    Hi everyone,


    I wrote the following code. I am running a query through power query. Selecting the data. Copying it as values. And then Selecting the blank cells and trying to delete the the entire row.

    Bit I am getting the error on the last line of code. "Selection.EntireRow.delete"

    Error - Delete method of Range has failed.


    Following is the code:-


    Code
    1. Sub delete()
    2. Selection.CurrentRegion.Select
    3. Selection.Copy
    4. Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    5. :=False, Transpose:=False
    6. Application.CutCopyMode = False
    7. Selection.SpecialCells(xlCellTypeBlanks).Select
    8. Selection.EntireRow.delete
    9. End Sub


    Please help.

    Hello folks. Need some help regarding the following.


    I have a "Summary" worksheeet in my master workbook- "Supplier EWS - P&C" . I have multiple workbooks in a folder. Each workbook is of same format and has 3 sheets. I want to copy specific cells from my "Financial - Summary" worksheet of each workbook into my "Summary" sheet of master workbook.


    I want B8 to get copied to A2, C8 to get copied to B2, I8 to get copied to C2, I12 to get copied to D2.


    And this should be repeated for all the workbooks in folder. So, lets say for next workbook, B8 should get copied to A3, C8 should get copied to B3 and so on.


    Please help.

    Hi,
    I have a workbook containing multiple named sheets. I want to copy 3 of these sheets (predetermined) into a new workbook. The name of the workbook should be a reference cell in one of these worksheets. I have written the code for opening a new workbook. Can someone help me for copying these sheets? The sheets should be pasted as paste special.



    Sub NewWb()
    Dim Aname As String
    Aname = ActiveWorkbook.Sheets("Financial - Summary").Range("C8").Value
    Workbooks.Add
    ActiveWorkbook.SaveAs Filename:="C:\Users\rajat.shrivastava\Desktop\Database - Supplier EWS - P&C\Output Folder" & Aname
    End Sub



    Thanks in advance.

    Hi,


    I have the following code. But its not saving the workbook with the pre-defined name that I want it to.


    Sub NewWb()
    Dim Aname As String
    Aname = ActiveWorkbook.Sheets("Financial - Summary").Range("C8").Value
    Workbooks.Add
    ActiveWorkbook.SaveAs Filename:=("C:\Users\rajat.shrivastava\Desktop\Database - Supplier EWS - P&C\Output Folder\ Aname")
    End Sub


    I want the name of the workbook to be that cell value that I referred to. Instead it is saving it as Aname.


    Please help.

    I have a folder consisting of financial statements of multiple companies in a standard template. I have a master template in a different workbook in which I copy data from 1 company, the ratios get calculated and financial analysis is done. I want to automate the process. I want that I should select the name of the company from drop down menu, and the values should automatically get extracted from that company file into my master template.
    Any help would be great.

    I have a workbook containing 2 sheets. Sheet 1 has 3 columns - Name , Postal Code & Address. Sheet 2 has 2 columns - Name and Postal Code. I want to paste address from sheet 1 to sheet 2 if name and postal code in both the sheets meet. So it is basically a Vlookup if multiple criteria are met. I want to use VBA programming for it. I am new to VBA. Please help. Thanks in advance

    Hello,


    I want some help with VBA code.I have few workbooks and each workbook has multiple sheets. I want to move the data from the different workbooks into one master file. The files are in different location & all have the same headers.
    I want to be able to copy the data & paste into the master sheet. Folders have multiple files. Also the header in each file is same. So I don't want the header to get copied.


    Please help me out here.
    Thank you for the help.