destination

Hi, Hope you are all well. You will see below two images which represent 2 separate workbooks. The first is the Source workbook and the second is the Destination workbook. What I need help in doing is producing VBA code that will copy the relevant information from the Source workbook into the...

Dear all, Good day! I want to copy and paste data automatically, using INDEX and ROW functions. Source sheet contains data of purchase orders and destination sheet is mix of Purchase and Sale orders. Source Sheet <tbody> A B 1 P.Order # Date 2 P1 3 P1 4 P2 5 P3 </tbody>...

Hi, I am looking for help in creating a loop for excel file attached. In the file there is a source sheet and a destination sheet. On the destination sheet there are cells highlighted in yellow that need to be filled by data from the source sheet. For example, in row e column 1 of the...

Excel 2016. I have cells in a book linked to another book. Seems the destination book isn't keeping up.When I open the book, do I need to answer "yes" to the question "do you want to update links?". Or better, how do I get that to just happen automatically? Other thing is, if the destination...

Hi, Experts Thanks in advance for your respond I need a VBA code to perform the below task Active workbook1 .xlsm - to random selective range of cells with Live formula to Copy Paste Value to WB2 on Cell: C19 and save it as new file .xlxs (file name VALUE AT CELL C20 and date DD-MM-YYYY)...

I Have a workbook that links to several workbooks in sub-folders When I open up the source workbook #ref appears in the destination workbook. How can I prevent this from happening ?

Hi All I hope to receive as much guidance and help as possible on this platform :) https://drive.google.com/drive/folders/0B9pqW92R9U4xLWkxek1zTGFZLUk?usp=sharing I have attached the data and destination images and would just like so help with formulas to: 1. In destination enter user name...

Hi guys, I have two workbooks (different files) that I need to feed information from one to another. The source has different funds (European Growth Portfolio, etc.) listed horizontally and products (Ultra 75/75 Series, etc.) listed vertically. The intersections contain add if they need to be...

Hi, I'm putting together some workbooks for my company and looking into how to use VBA to send out work to another workbook. I already have the code to copy and paste the code into a specified workbook (by destination), but i'm looking for a way to have a selectable drop down menu and by...

Hi Could you please help me with the scenario below? My source folder is called "Source\Files\" It also has shortcuts folder that is shortcuts of the all original files say "Source\Shortcuts\". These shortcuts point to files in "Source\Files" folder. ---- I need to create a backup of this...

Column B and C are formatted as percentage: Column D is formatted as currency. In cell B10, I autosum B1 thru B9. Ctlr +c to D10 then Ctlr+V. I want the results in currency ( the format in the destination cell), not percentage ( the originating cell) Is there a setting I need to change to...

When separating telephone numbers to the appropriate format, I change the destination cells in the spreadsheet to 'text', and also change the destination fields to 'text' in the 'text to columns' wizard. The separated numbers, however, still drop leading zeros. How can I retain the leading zeros...

Hello everyone, I using a VBA code to copy cells from various excel sheets into one master sheet. I have managed to employ VBA to copy single cells, but now I would like to copy a range of cells and transpose them into the master sheet. However, I am not able to adapt the paste special...

I am trying to paste data from one worksheet to another and am not sure as to why it only works when using a standard range. works: Sheets("sheet1").Range("B4:Z10").Copy Destination:=Sheets("sheet2").Range("A1")doesn't work (run time error 1004): Sheets("sheet1").Range(Cells(4, 2), Cells(10...

Hi, I have some code which creates a connection to a folder at a path I specify in a cell, but I'd like to be able to have others use it on the network drive. The issue is that not everyone has the same Drive letter that I have. I've tried the fix I usually use, but it did not work. How...

Hello, I need help with some code. What I have is an extremely simple worksheet. Column A has Stock Tickers, my Code Goes out and grabs the Prices for the Tickers, and I want to put the Price for the Stock in the adjoining Column B of the Worksheet. However, right now the values return fine...

Hi All, Hope you had a good weekend. Have a question about a method of 'Offset' I have a formula that I want to autofill by a certain amount (intRowCount which is an integer) but I'm not sure what method to apply to Offset in order to make it work: Selection.AutoFill Destination:=...