destination

I have two folders on my "desktop" : Folder 1 named : "Today" and Folder 2 named : "Destination" In folder named "Destination" I have multiple files : A.xlsx, B.xlsx, C.xlsx with same headers. In folder 1 have the latest sale data and I want to combine the latest data with the destination...

Hi I'm am trying to run this down below, but I get error its basically replacing an existing sheet and want to see if there is anyway around this. Error message Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns that the source workbook. To...

I am using the following code in a procedure which is accomplishing what I need, but I was wondering if when the AutoFilter pastes the visible rows to another destination (In a tab I call Clipboard), it paste values. Is there a way to modify the code to make the paste special, with formulas? I...

i manage to copy from 1 row of source path folder to destination ( B2 to C2) but i has trouble to write the code to continue loop copying from 2nd row & so on until empty cell value can anyone help me to fix the code? i need its can loop continue fro ( B3:until end, to C3 until end) below is the...

Hi all, Source sheet is Input sheet & Employee master. Destination sheet is FL master. I have recorded a macro name “Accrual”, but the issues with I am stuck are, Macro is not starting from the next to end row of destination or whichever cell we want. Data set in source system changes...

I am stuck on a formula and hoping someone can point me in the right direction. I am creating a field on a training matrix and want to look at putting formulas in a couple of cells. If the original cell says O/S in want the destination cell to say O/S If there is a date in the same original...

Morning All, I have a forumla that copy a line from one tab and then pastes it to a different tab within the same workbook then saves the file. But i wondered if its possible for the formula to paste the data to a totally different work book and then save that file ? I have copied a watered...

Greetings, I am having trouble with the last line. I would like to use a variable "a" to define the last row in the Destination range but am receiving an error. a = Cells(Rows.Count, "A").End(xlUp).Row Range("J2:BC2").Select Selection.AutoFill Destination:=Range("Cells(2...

Hi All, I have some coding that allows me to copy data from one sheet to another, but i want the same coding to look at Cell M4 and display a Message box if Cell M4 contains the wording "Select Variant" Is this possible and where would it need to be within the coding (shown below sorry for...

Hello, I am looking for some help copying from a source file to a destination file. sourcePath = Sheet1.Cells(121, 9).Value Source Cell: (121, 9): "C:\Desktop\Proc_9UL_RB_10\MCD_9UL_RB_10" DestinationPath = Sheet1.Cells(110, 13).Value Destination Cell(110,13)...

I am trying to use a ctrl + shift + down arrow dynamic range but am unsure how to embed it in my current macro that has something along the lines of Selection.autofill Destination: =Range(“J2:J330”) please help

Good afternoon, I have the following code: Sub copypasteworkbook() Dim x As Workbook Dim y As Workbook Dim vals as Variant '## Open both workbooks first: Set x = Workbooks.Open(" path to copying book ") Set y = Workbooks.Open(" path to destination book ") 'Store the value in a variable...

Is it possible to automatically Identify Destination of workbook - and Update the fullpath and name of workbook in Cell A1.

First time posting here.... would like to take this opportunity to say that you guys rock and visiting this site has provided more excel answers than I care to count right now. Keep up the good work! So here's my scenario. I have a table.. and I have another table. We'll call them "Source"...

Hello Experts - I have below code which transfers the file (Gross Contribution Report) inside the subfolder (and override the same file inside this subfolder). However, nothing is happening whenever i'm running below code. Can someone help me understand what's wrong. For visualization purposes...

I have a table with column B (folder name) and column C (file name) as the criteria. Tables D to G are imported data say,"H2:K5", from other closed excel files saved in different folders. I have a hundred of these files that are updated from time to time and I need to gather it all at once. Any...

Hi I just tied to use Data-->Text-to-column. I have a column and I want to covert text to column using "space" as a delimiter. I tried to change the destination to a different Sheet; but excel did not accept that. I can only chose a destination cell inside the same sheet? Is that the case with...

Hello. I have a workbook that uses a web import with parameters and it works just fine, however I have rearranged the workbook and need the destination location of the imported data to be in a different location. The only options I see are for either editing the parameters or editing the data...

I have a long column of populated data that contains both numbers and letters (source). On a separate sheet, I have another column with the same information in a different order (destination). In the source column, the first character is missing from several entries. I need a method using...

hi I have 2 Excel files. 1 Source and 2nd Destination. There are some columns in Source file like <tbody> Sr No Name Address Contact no 1 Abc xxxx 123 2 Xyz xxxx 345 3 Mno xxxx 567 </tbody> and in Destination there are below fields <tbody> <tbody> A1 Sr No A2 Name A3 Address A4...