Excel Data Import and Date Verification

[Nandakumar]

I am reaching out to seek your expertise and assistance with a task we are currently facing in Excel.

We have a database stored in an Excel sheet containing customer code, name, amount, and delivery date. In a separate tab, we are using a VLOOKUP formula to capture customer code, name, and delivery date.

Our current challenge lies in the process of importing the database into a sheet named "Data." When we import the data, if there are changes in the delivery date (for example, if the new delivery date is 01-Oct-23 instead of the original 10-Oct-23), Excel automatically replaces the date.

To enhance our tracking process, we would like to identify whether the delivery date has been changed and capture this information in a new column labeled "Revised Delivery Date."

I have attached the Excel sheet for your reference, and we would greatly appreciate your guidance on how to implement a solution for this task.

Thank you in advance for your time and support. Your expertise is invaluable to us, and we look forward to your advice on resolving this matter.

Best regards,

 

[vletm]

Nandakumar​

Something like this ... ?

 

[Nandakumar]

Nandakumar​

Something like this ... ?

Hi Thanks for the workings.

Unfortunately no.We will get customer data every week.Once we paste the data into "data sheet" the delivery date will not be same for the customer as it vary depends upon delivery schedule.
We want to see the change happenned compared to previous import what date has been changed.
Example during first upload delivery date is 01-Oct-2023.After one week during second upload date will be 10-Oct-2023.We want to identify the old date in next column.

Hope it clarifies

 

[vletm]

Nandakumar​

I could only ask ... what?
... Did You try to use it?
... ... Did You notice that ... both dates will be save there?
Could You show few clear samples in that file - what do You have in Your mind?
... above means that there could see - before and after situations!

 

[Nandakumar]

Hi,

Yes.I gone through your file.

Let me explain further with sample.

For example :Given below my data which i received on last week (which is shown in Sheet name "Data"



And output for the above should be as below



In the next week,i will receive data from the customer which will be updated in sheet named "Data" [replace last week data] input will be as below:

And output should be as below which should show old delivery date and revised delivery date:

Customer code​	Customer Name​	Delivery Date​	Revised Delivery date​
10000​	A​	10-Oct-23​	20-Oct-23​

Let me know if you have any queries

Thanks for the understanding.

 

[vletm]

Could You show few clear samples in that file - what do You have in Your mind?
... above means that there could see - before and after situations!

Your Summary-sheet has ONLY one row of data.
... in my version same
- it will look like below (before You've pressed <ENT> after 10000)

Your Data-sheet looks like below:

After You've written 10000 <ENT> and applied new date (01/10/2023) to lower date
as well as pressed <ENT>

New date (01-Oct-23) has updated to Data-sheet and
previous date (10-Oct-23) has saved to Data-sheet.
If there will be more 'new dates' then always previous dates will saved next free cell.


Your sample-file won't let this work as mine.
You've also written [replace last week data]
... which means columns from B to F.

I can understand only and only - what have You written or shown.

 

[Nandakumar]

Could You show few clear samples in that file - what do You have in Your mind?
... above means that there could see - before and after situations!

Your Summary-sheet has ONLY one row of data.
... in my version same
- it will look like below (before You've pressed <ENT> after 10000)
View attachment 86046
Your Data-sheet looks like below:
View attachment 86049
After You've written 10000 <ENT> and applied new date (01/10/2023) to lower date
as well as pressed <ENT>
View attachment 86048
New date (01-Oct-23) has updated to Data-sheet and
previous date (10-Oct-23) has saved to Data-sheet.
If there will be more 'new dates' then always previous dates will saved next free cell.
View attachment 86047

Your sample-file won't let this work as mine.
You've also written [replace last week data]
... which means columns from B to F.

I can understand only and only - what have You written or shown.

I think i explained you in reverse way.The revised delivery date shown flow from new data sheet which i completely replaced from B:F.Given below the output:

 

[vletm]

Nandakumar​

Your original data is as below (from Your original file)


... and from my file:


You have asked next:
if the new delivery date is 01-Oct-23 instead of the original 10-Oct-23

... means as below after new data:
delivery date is 01-Oct-23
and
the original 10-Oct-23 has saved there too.


I avoid to guess - what are You thinking?
or do You do something which way?
( Of course, there will be challenges if Your new data is eg in different order or new data don't match with old data )

 

[vletm]

Nandakumar​

If You have had an idea that ...
... Summary-sheet has more than one row then ...
... ... many things would be different eg something like this kind of pure guess sample

Usage:
# Get Valid data to Data-sheet
# Press Summary-sheet's [ ReFresh From Data ]-button
>> You'll refresh Data
>> You'll see modified cells
>> Older data's row will be saved too ( hidden & gray )
#Notes
## Data-sheet have to have always same layout ( same ... means same )
## This sample do not have any protection.

With [ Show/Hide ]-button, You can see All or 'active' rows.

 

[Nandakumar]

Th

Nandakumar​

If You have had an idea that ...
... Summary-sheet has more than one row then ...
... ... many things would be different eg something like this kind of pure guess sample

Usage:
# Get Valid data to Data-sheet
# Press Summary-sheet's [ ReFresh From Data ]-button
>> You'll refresh Data
>> You'll see modified cells
>> Older data's row will be saved too ( hidden & gray )
#Notes
## Data-sheet have to have always same layout ( same ... means same )
## This sample do not have any protection.

With [ Show/Hide ]-button, You can see All or 'active' rows.

Thank you so much ! Its worked.Can you please help me with removing Show/hide macro as we want to see only active rows.Once again thanks for your help.

 

[vletm]

Nandakumar​

Why do You would like to do so (removing)?
... Cannot You avoid clicking that button?
... ... then You could see only active rows.
... or delete that button ( ... hmm? ... deleting is not a sensible idea at all either )

 

[Nandakumar]

Nandakumar​

Why do You would like to do so (removing)?
... Cannot You avoid clicking that button?
... ... then You could see only active rows.
... or delete that button ( ... hmm? ... deleting is not a sensible idea at all either )

Hi,
Since data is already captured in the revised delivery date,we want to see only active sheets.Thats the reason i want to delete it.

 

[vletm]

Nandakumar​

... as I wrote delete that button