Excel Report Help Needed

A_Kubiak

New Member
Joined
Apr 14, 2009
Messages
6
Hi there, I could really use some help with this report in Excel. Me and my boss have been trying to get this to work for 3 days now and its come to the point that we are not going to get it unless someone is nice enough to give some advice.

We have a report with 2 different sheets. On sheet one there are 13,000 rows of data and columns A-H are filled with different data. column A is our item id and column G has a date that states when the item was sold last. Well, the date in column G is wrong for about 7800 rows and needs changed.

The second sheet in the file is the 7800 rows with just the item id in column A and the correct date in column B. We are looking for an easy way to replace the rows in the first sheet with the correct information from the rows in the second sheet without manually replacing it line by line.

I almost forgot to add in, that in both sheets, column A with the item ids are the same item ids on both those sheets. So column A on sheet one has 13000 rows and included in those 13000 are the 7800 item ids on sheet 2.

We tried using the VLookup function that is incorporated into excel but had absolutly no luck, mostly because we have never used this function before.

Any suggestions/help/feedback on this matter would be greatly appericiated.

By the way, We are using Excel 2000. I know, its old but it still works
Thank You!<!-- google_ad_section_end -->
 
Last edited:

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

silkfire

Active Member
Joined
Apr 6, 2009
Messages
441
Just copy the lines?

Select them in the second sheet, Ctrl+C and paste them where you need them in the first sheet.
 

sinfulloyolite

Board Regular
Joined
May 8, 2008
Messages
79
After executing the formula, you need to format the cells into Date format to get the exact output.

Thanks,
Prem
 

A_Kubiak

New Member
Joined
Apr 14, 2009
Messages
6

ADVERTISEMENT

thanks for the replies, im going to try that formula now. I cannot copy the lines from sheet 2 into sheet one bc then the lines would be duplicated. Sheet one already has all the lines of sheet 2, its just that sheet one has the wrong dates for the item ids and sheet 2 has the correct dates. im trying to replace the dates on sheet one from the dates on sheet 2 matching on the item ids from both sheets.

I may not have made it clear in my first post, and if thats so i apologize.

Thanks
 

A_Kubiak

New Member
Joined
Apr 14, 2009
Messages
6

ADVERTISEMENT

thank you for the help, it did work. :) i really apreciate it.
 

silkfire

Active Member
Joined
Apr 6, 2009
Messages
441
Are the rows in Sheet 2 consecutive? What I meant was you could replace the faulty dates with the correct ones if all the 7800 rows follow one by one.
 

A_Kubiak

New Member
Joined
Apr 14, 2009
Messages
6
i lied, its not working for me on my sheets. I think it is more human error than anything:confused:.
 

A_Kubiak

New Member
Joined
Apr 14, 2009
Messages
6
File is saved online if anyone would like to take a look at it, i know its asking alot of you guys/girls out there but this is hell for me and driving me insane. plus i think that i am not phrasing the issue correctly so to help me out i figured posting the file online to look at might save me.

File Location:
<CITE>skydrive.live.com</CITE>

Username: A_Kubiak@comcast.net
Pass: aek15234

File is in documents folder, it is the only file in my skydrive to make it easier to locate.

Thank you again
 

Watch MrExcel Video

Forum statistics

Threads
1,123,158
Messages
5,600,054
Members
414,357
Latest member
Gemma_R

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top