Posts by cowen49

Hi Mumps,

I downloaded both Macro's and run them both, however both cause Excel to crash immediately, see screen shot linked below:

https://www.dropbox.com/s/wwnd…e5/Macro%20Crash.png?dl=0

APO late to the party but the solution works perfectly, I've removed the END row and run the macro a couple of times and it works very efficiently, Thank You.

Hi,

No necessarily but I think across a quarter we will collect around 15,000 lines of data depending on how many blank rows it leaves.

Thanks

Hi mumps,

Sorry I've been out of the business a few days.

I've managed to get the placement correct, the issue seems to be if the source data has a blank row between rows of data then it doesn't copy all of the data over.

See link below:

https://www.dropbox.com/sh/tr9…H5_JFlYWiQ7gXDL70Vta?dl=0

Thanks

Colin

Amazing, just 2 issues I can see.

The first is when there are two sheets it seems to cut off the last row of data on the second file copied across, the second is how would I get the starting depositing position to be B:2 instead of A:1

Great job BTW

Colin

Hi Mumps,
Sorry about the delay, I had to get the go ahead first. I've de-sensitized the data. I've included the data entry book which is store1 and the master Yield Tracker V2 Sheet where the Macro is located.

I couldn't upload due to file size so please try the below DropBox Link.

https://www.dropbox.com/sh/tr9…H5_JFlYWiQ7gXDL70Vta?dl=0

Thanks

Colin

It's copying over all the rows on the data inputting sheet regardless of if they have completed data in them. Also the data is being dropped in with headers, the headers are on row 2 the data begins row 3.

Hi,

Further update on this, it turned out the cells aren't overwriting but rather it's copying all 40,000 rows over rather than just the rows which contain data.

Thanks

Colin

Hi Jolivanes,

Thanks, for this, I have an nasty habit of inconsistency which I had carried over the master sheet. I've rectified this and it's working which is amazing Thank You.

However a couple of bits I've noticed:

-I'm Testing it with 2 sheets currently and the last sheet that is opened and copied is the only data on the destination sheet in the master workbook.

-Also the data is bring dropped in Cell A3 which included the header row. How would I make it so only the entered data is copied across, this is located in cell B3 on the worksheets.

Thanks

Colin

Hi Mumps,

Thank you for the quick reply,

I've tried this and it gives a run time error 9 Subscript out of range.

The line of code highlighted is, Set wsDest = ThisWorkbook.Sheets("DBEntry")

Just another FYI the source files are macro enabled so am I correct in changing the extension in the VBA code to .xlsm.

Thanks

Colin

Hi,

I’m after some assistance creating the correct VBA to do the following:

-I have 14 workbooks all contained within the same folder.
-The folders path will be “C:\Users\cowen\Documents\Yield Tracker V2”
-Within these workbooks is a data entry sheet which is sheet fall but named, “DBEntry”
-The layout of these sheets and the headers are exactly the same for all 14 sites which each have 1 workbook.
I want to be able to copy across the data from the DB entry sheet, this will always be between column B and s however depending on the amount of data entered it may be 20 rows or it may be 200 rows. Once copied I was the information deposited into an Workbook called Yield Tracker V2 Master and within that sheet DB Entry.
I would like all the data to merge rather than each workbook over-right the previous one.

Any help is greatly appreciated Colin