copying data from one workbook to another workbook using date as citeria

**narsing18** · 07-24-2017, 04:10 AM

Hi,

i am trying to copy data from one workbook to anther workbook between two date range.

if i have data in source.xlsm , i have created two date fields in excel with button . i select dates as starting date and end date and click of a button the date in source workbook should copy to destination.xlsm workbook. i am tryng something below but its not working.

Please Login or Register  to view this content.

**sintek** · 07-24-2017, 10:55 AM

Hi narsing18

Difficult without sample uploads of your files....
This is the jist of it...However untested...
Do not like the activesheet.paste method so need more information to improve...

Please Login or Register  to view this content.

**narsing18** · 07-25-2017, 02:21 AM

@sintek ,

First Thanks for the reply.

i am getting error sort method of range class failed

Please Login or Register  to view this content.

**sintek** · 07-25-2017, 02:46 AM

As I said....

Difficult without sample uploads of your files....

**narsing18** · 07-25-2017, 03:01 AM

Please find attachments here TTM_form is the source file and database is the destination file

**sintek** · 07-25-2017, 06:35 AM

Are you sure you uploaded the correct file....TTM_Form!!!!

**narsing18** · 07-25-2017, 06:48 AM

Yes that is correct file only..in TTM_Form i want to copy "Data Sheet" sheet to data_base workbook if its hidden you can un-hide using password "extn@123"

there is a button in the main screen as admin

**sintek** · 07-25-2017, 06:56 AM

K got it.... I seriously would suggest Your clock in table to have date separate from time , else you will have to create a dummy column with date only for filter purposes.

Edited...
I put in an extra column F for date only. Format column as date... and place this formula and copy down...

Formula:

Please Login or Register  to view this content.

This now works....

Please Login or Register  to view this content.

**narsing18** · 07-25-2017, 09:06 AM

I have small doubt before testing

Please Login or Register  to view this content.

you have mentioned workbook name as "Logintime" where workbook name is "Data_base" and sheet name is "Logintime"

or we can directly mention sheet name in the path

Thanks..

**sintek** · 07-25-2017, 09:58 AM

This is your code from Post 1

Please Login or Register  to view this content.

I used that code for testing purposes...
can't help you if you do not give the exact information...take some time to think about what you want to do and come back with the names of:
1. the workbook that actually houses the code.....
2. The workbook & worksheet that has to be opened, filtered and copied from
3.The workbook & worksheet that has to be opened, renamed and copied to.......
Edited:

The above code refers to a file called Logintime.xlsm stored in Folder called Data_base

**narsing18** · 07-26-2017, 03:32 AM

Sorry its my mistake...as i attached two files i thought it might be clear..now i will explain step by step to avoid further confusion.
1. i have two file TTM_Form.xlsm (source) and data_base.xlsm (destination)
2. in TTM_Form( source ) i have sheet called "data sheet"
3. in data_base (destination) i have sheet called "Logintime" in the same workbook i have sheet called "workform" where the dates have to been mentioned.

now i want "data sheet" (TTM_Form, "source") to be copied to "logintime"(data_base, "destination") sheet

4. and when ever it copies to destination sheet "logintime" it should clear the sheet if there is any data and then copy.

hope you got it now

**sintek** · 07-26-2017, 03:45 AM

Perfect, thank you for your explanation. I've got the code sorted except for one minor detail...
Your original code renames the active sheet which is Logintime to the current date.... is this your requirement?

Herewith code without renaming logintime...Just change your path...And remember to put in a helper column with date as suggested in Post8...As Per upload.

Please Login or Register  to view this content.

**narsing18** · 07-26-2017, 05:50 AM

Hi Sintek.....that's perfect ...its working as expected..thanks for your time and correcting my mistakes..

**sintek** · 07-26-2017, 06:13 AM

Pleasure...Glad we got it sorted..thanks for rep +

**narsing18** · 07-28-2017, 09:12 AM

Hi Sintek...i have small problem with workbook "data_base" ..its not related to copying but if u can help me i will be very thankful...after copying the data to "Logintime" sheet the formula in column "D" should show

Please Login or Register  to view this content.

like this but its populating as

Please Login or Register  to view this content.

and not getting the proper results ...can you please let me know how to avoid it.

**sintek** · 07-28-2017, 01:06 PM

Try changing this.....Untested

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**narsing18** · 07-31-2017, 05:10 AM

Hi Sintek ...after change the vlues are showing as below

Please Login or Register  to view this content.

date and time values are changed to numerical values and difference is also not correct

copying data from one workbook to another workbook using date as citeria

LinkBack

Thread Tools

Rate This Thread

Display

copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Re: copying data from one workbook to another workbook using date as citeria

Thread Information

Users Browsing this Thread

Similar Threads

Copying data from one workbook to other based on date criteria

Random rows being overwritten on 'data store' workbook after copying from input workbook

Random rows being overwritten on 'data store' workbook after copying from input workbook

copying data from a recently opened workbook to the workbook where the form is present

[SOLVED] Copying data from a closed workbook into an open workbook ignoring excel filter?

Filtering in another workbook, copying filtered data and pasting in source workbook

loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions