Hi,
Im looking for a marco that looks up a cell and based on that cell it copies data to another cell.
So in the attached, the looks at the date (column B) and copies the data from column C then, that it looks for the date in row 1 and pasted the copied data below.
Is there a way to do this?
if it's roughly as easy as it looks - all the dates are properly sorted and you're literally just taking strings from rows and moving them to columns you could do it like this:
where you just need to manipulate Range("C8:C13") and Cells(2,i+4) to map to your actual input range and your desired output range...
Please Login or Register to view this content.
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Hi thank you for your reply, the dates in column b will also be in a random order. This is what im having trouble with.
Is there a simple way around this?
how about this:
Formula:
Please Login or Register to view this content.
?
Last edited by simarui; 03-11-2015 at 10:10 AM.
Maybe:
Please Login or Register to view this content.
Hi John, that works a beaut. Can i ask if i was to have data in say col D or and E next to a name, could i copy that data over as well?
Or a range like c8 to e14
Try:
Please Login or Register to view this content.
Not sure I understand?Originally Posted by namluke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks