One more question...
Well, as I was looking back on the other post I made in here I realise that it was worded wrong so I decided to simplify my question to see i anyone around here can help me out. So I've brought it down to tryin to figure out how to make one macro. See, I'm trying to make a marc that basically says, "if this cell is the same as this cell(text btw) then copy this and paste it here". My overall goal is to make th spread sheet copy match info from a wrestling match and paste it int the proper row on a spread sheet with each individual's scores. I other words I want the thing to paste it in the right row without m having to make a button for each row(50 of 'em). Any help would b appreciated. Thanks, Ryan: ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
One more question...
So yuo want to compare two cells - in the same row
presumeably? - and when they match copy the value of another cell to another table. Do this for each of say 50 rows. The destination table...the "right row" is a bit loose. What's the criteria? It helps if you describe more accurately what you mean. For instance, you may have a table of results with say the team name in column A and the competor in B with the result of the match in C You have a separate results table where you want the match results copied to where the lookup values match the team in A If you could think about what it is you need more precisely, then you'll get a more precise answer. -----Original Message----- Well, as I was looking back on the other post I made in here I realised that it was worded wrong so I decided to simplify my question to see if anyone around here can help me out. So I've brought it down to trying to figure out how to make one macro. See, I'm trying to make a marco that basically says, "if this cell is the same as this cell(text btw), then copy this and paste it here". My overall goal is to make the spread sheet copy match info from a wrestling match and paste it into the proper row on a spread sheet with each individual's scores. In other words I want the thing to paste it in the right row without me having to make a button for each row(50 of 'em). Any help would be appreciated. Thanks, Ryan:D ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ . |
All times are GMT +1. The time now is 03:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com