destination

Hello everyone, I have multiple destination workbooks each one with a list of 100 symbols (one symbol per cell) in column A starting from cell A25. I have also file "Source.csv" with a list of 2000+ symbols in column B starting from B2. To copy and paste all 2000+ symbols in the column of a...

Hello there! Can you guys please help me with my problem. i know this is very easy but to be like novice in excel, I don't know how to formulate below. Please help. Replies is very much appreciated. Result : Sum the quantity based on Type, month and destination. Thank you in advance...

Hi all, Please note that I am trying to copy data from a workbook to another workbook. What I am trying to achieve is that the data gets pasted to the last cell of the destination workbook. For that I had found a code in the web that does it, however, the source and destination excel files are...

here is a brief of what i'm trying to achieve: The rows in the source table highlighted in red are already present in the destination table, so i DONT want to copy them over to the destination table. However, if a single cell in any of those rows didn't match the corrosponing field in the...

My team inherited a pivot that does this. Workbook uses multiple SQL statements to populate multiple pivots on multiple tabs. The pivots are linked using slicercache. The "controlling" pivot has a larger list than the destination pivot. On the original/unmodified workbook, when the...

I can get :- ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False to work. But setting the active cell is not straightforward. Workbooks("myBook").activate always works but Cells(1, 1).select (and Cells(1, 1).activate) sometimes work but are both unreliable. Can...

Hi, I am trying to create new reference number and add the last empty cell of Column M: How can i fix this code at destination range?? A2018-01 A2018-02 D2018-03 A2018-04 A2018-05 A2018-06 A2018-07 D2018-08 D2018-09 A2018-10 A2018-11 A2018-12 empty cell here (for instance) i tried to run...

Dear MVP's,Any one can help me on macro. I need to cut the data from source file's A column to destination file A column. Repeat the same step to all the file with in a folder, other than source file.If first destination file having data 7 rows, then cut data from A2 to A8 cells from source...

Hello all, I am working on building an excel file that canbe used by our administrators to check students in and out of their dorms tolocal venues. I am using Excel 2013 for this doc. I have the skeleton built andI’m working with three worksheets. The first is the “Logging Procedures” sheet...

Hi, i want to copy specific cells from sheet 5 of workbook1 to sheet1 of workbook into specific cells only, without opening a destination workbook. i am trying like this but i don't know, y its not working well for multiple values Dim srcWB As Workbook Dim destWB As Workbook '...

I have two drop-down list boxes with multiple options to choose from in each box. Doing the math, there will end up being 300+ outcomes in the destination cell. I thought about doing IF AND statements and I'm pretty sure excel won't allow for that to happen. I have tables with all of the...

I am attempting to insert a formula function from one sheet to another. I have inserted the formula into the destination sheet. It’s works fine for the first cell. When I drop the formula down the column the dollarised amounts used in the formula spreadsheets ‘scatters’ . What I mean is when...

See image below -- should be self-explanatory. I have a table of several thousand rows and I need to copy data ONLY for rows where the value in column E is "x" over to another sheet. I can't screw with anything to the right of column E on either Sheet 1 (source) or Sheet 2 (destination)...

Hi I want to copy the selected cells to another part of the sheet by selecting the destination range as well. right now I can only use the destination as a cell/range as it is shown in the code below. I wonder if the destination range can be selected as well (by using the mouse). I tried to...

Hi all, new member with limited VBA knowledge I'm afraid. I have below code which works fine however I would like to expand this to do the following: In column Q I have a drop down list with 3 options (say A, B and C) and if this cell is not populated, I want a message displayed to the user to...

Hey guys:confused: How can I change the Destination: to the first blank cell in Column A? Instead of "$A$1"

I have this formula: =IFERROR(VLOOKUP($A20,'[Sep2018-VersionB.xlsx]Newsletters'!$B$3:$BZ$200,COLUMN()+14,FALSE),"") it works perfect if the cell being looked at has a value. If it doesn't, I'd like the destination cell to display 0. How do I modify my formula to produce that result? Thanks...

I'm getting a: "Method 'Range' of object_'Worksheet' failed" error message on the following code. it works up to the .Copy portion but I'm definitely doing something wrong with the Destination. Any help would be appreciated! Private Sub CommandButton1_Click() Dim mySheetW As Worksheet...

Hi, I was originally using some VBA code and Google's API system to calculate distance between Post Codes, it looked like this: Function G_DISTANCE(Origin As String, Destination As String) As DoubleDim myRequest As XMLHTTP60 Dim myDomDoc As DOMDocument60 Dim distanceNode As IXMLDOMNode...

Hi I'm looking for vba code to open a closed workbook and copy data from a tab (Audit) to destination workbook (Tab called "QA") with formats but removing the formulae (paste special) I would appreciate any guidance Many thanks