destination

Hello I am a starter in VBA. I have one workbook by the name copy.xlsm, it has a data in "Sheet1" from A1:J14. Now i wish to copy this data to different workbooks, whenever required, Therefore I cannot set the destination workbook name beforehand, but the destination worksheet will have...

I have this formula: =VLOOKUP(F7,Schools!A:B,2,FALSE) I would like the destination cell (G7) to appear blank if there is no value in F7. Could you help me to create this formula? :) Thanks Becs

Hello, Im having a weird problem and hopefully someone might be able to help. When triggered my macro copies: Sheet 2 to Sheet Then Sheet 1 to Sheet 2 It has to be in that order. I wrote my Macro, the problem is when I execute it the Macro isn't working but the catch is, VBE is not giving...

Hi all, I’m a basic user but a big fan of pivot tables. I’ve to rush out a report for several thousands of records but struggle to achieve the outcome with pivot. Hence, my SOS reach out to this community. My table has more headers but let me simplify it to a table with 3 columns - Name, Origin...

I am trying to write some VBA to solve a distribution hub to destination resupply problem. I have over 20 potential destination locations but calculate resupply one location at a time. The destination location can be supported from 30 different supply locations. I built a formula that looks up...

Hi, I have a macro which filters the results based on variables and then copies the filtered results and pastes into another destination file. The issue I am having is that when I autoplay this macro (F5) it does not paste all copied/filtered values into the destination sheet, however if I...

I have ref no's in Col G (destination File) and the ref No's in the Source File is in Col A. I also have values in Col H & I in the destination workbook. The values in the source file is in Col J Where the reference numbers on the destination workbook matches the ref number in the source...

I am modifying a macro in Excel 2010 that copies data from one sheet and pastes it in a format that works with a pivot table. The data in the source worksheet is spread out over several rows. The macro pastes the data from numerous columns to single columns. The name of the source worksheet will...

Hi! I've searched the forum and found some really useful stuff (thanks a lot!), however, im still not reaching the goal and even though I think I have most of the formulas I need, I still have some problem with the logic. I am currently working on a windows microsoft office excel standard...

<tbody> A B C D E F G Destination P/V Pup Van Dest. 2 Pup Total Van Total 003 p 1 001 003 v 1 002 004 v 1 003 004 p 1 004 005 p 1 005 009 p 1 006 012 v 1 007 030 v 1 008 </tbody> All Columns go to 500. Column A for Destinations is not set and can...

Hi All I have a macro that allows me to move information from one sheet to another in the same workbook, but i require it to move to a different work book using the following bit of code ' Set source and destination sheets Set src = Sheets("TOUCH SCREEN") Set dst = Sheets("RAW DATA")...

As I was typing the title it seemed very complicated, hopefully below info will clarify it :) Each record has unique Reg# Given the data below, my formula in Destination sheet in cell B1 would return "X" if Packing Rating="Sat." otherwise return blank. Same type of Formula in Destination...

Hi Everyone, I am trying to get a returned count of blank cells for a selection of cells on every row of a spreadsheet and paste the total number of blanks for each row into a cell on another sheet. The destination cells for the totals are (in bold and the order that they appear in the below...

So I need not a single function, which changes the data (or copies) from one cell to the destination, but from the destination to cell too, if I modify that. (so it works in 2 directions instead of 1) I edited a picture so it's easy to understand: https://imgur.com/a/t98U9SS Is this possible?

I have a vlookup combined with an index Function. If I open up the workbook from where the formula looks up the values, I get a #Ref error in the formula in the destination workbook =IFERROR(IF(VLOOKUP($B370&"",'[BR1March.xls]#Ref...

Hi All Been using these boards for years and finally have an issue that I can't seem to find a solution/instructions for so this is my first post. (I'm also not the best at explaining things so please bear with me) OK, so I have a rather large workbook and on one of the sheets is a real-time...

Hi, Writing a macro that lifts specific columns from a source sheet into a destination sheet. Unable to find decent answer online, though may not be asking in way that returns meaningful results. One column is date at start of week (Monday) followed by daily hours in adjacent columns I'd like...

Hello all, Thank you for all your help in advance. I am an intermediate user of excel - no coding background - but pretty good analytically. I am working with 10 production lines with each operator recording data for each shift. 3 shifts in a day. 30 files of data for each day. There is a...

Hello Geniuses, I am stacked here. I need a script that will check my filepath or the destination folder to see if there are files there already. Then display alert. Thanks Kelly

1: I have two folders in desktop named "Today" and "Destination" path is (C:\Users\Work\Desktop\Today) and (C:\Users\Work\Desktop\Destination 2: both the Folders have multiple files with same name eg : Apple.xlsx OR Apple.csv , mango.xlsx OR mango.csv , Sheet names are same as file name. eg...