Hope you all safe and good in these Covid times.
I have a task ahead of me and I am thinking that maybe there is a better way to code this.
I have two workbooks. Source and target. I need to pull out values from the source and paste it to the target,
It is not a block per say, but...
I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2).
Currently, I have just set the fields in my "Order form" sheet = the...
I cant seem to fix this one... but its been a while since i do this.
i am trying to:
1. Ask user to select two files to open via a prompt.
2. Clear the data in the "AP Template" file (file 1)
3. Copy Data from "HL Data Sheet" workbook (file 2)
4. Paste into predefined cell in file 1...
I am working on an item, where I need to compare 2 excel sheet ranges, Say File1 Sheet1& File2 Sheet1
I am invoking File2 Sheet1 by File.Open
Copying the respective range from file 1 & file 2 into Rng1 & Rng2
I am concatenating column values for each row in Rng1 & Rng2 & putting...