Dear sir/madam,
I have a short question.
I have a list of values and I need to place them in another sheet on the right date.
I my attachment you can see a sample of it.
I need to place the values (column B) of sheet 2, in sheet 1 in column H.
The dates in sheet 1 are in column AZ.
I hope someone can help me.
Last edited by keis386; 08-10-2011 at 08:04 AM.
Firstly, the values in column AZ are not in Date format, you will need to highlight the column then search and replace "-" with "/". Then in Sheet1 cell H4, paste the following formula and copy down:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks