| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too Complicated For Me
This is what I want to do: If info in Sheet 1, Column A matches a sheet name, then paste info from Sheet 1, Columb B to B3 of the sheet with the matching name. Can this be done? -- mehare ------------------------------------------------------------------------ mehare's Profile: http://www.excelforum.com/member.php...o&userid=37483 View this thread: http://www.excelforum.com/showthread...hreadid=571844 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Too Complicated For Me
As I read your question, it is a little confusing. You say you want to paste
infor from Sheet 1 COl B(a column) to "B3"(a cell) of the sheet with the same name. Are you wanting to paste cell by cell or by column? Either way, you could set up a macro to do it, but it would require some VBA skill. Or a more simple approach would be to just filter Sheet 1 Col A for each sheet name, and paste the data one sheet at a time. "mehare" wrote: This is what I want to do: If info in Sheet 1, Column A matches a sheet name, then paste info from Sheet 1, Columb B to B3 of the sheet with the matching name. Can this be done? -- mehare ------------------------------------------------------------------------ mehare's Profile: http://www.excelforum.com/member.php...o&userid=37483 View this thread: http://www.excelforum.com/showthread...hreadid=571844 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Too Complicated For Me
when A1=XXX, paste B1 into J2 of Sheet XXX when A2=YYY, paste B2 into J2 of Sheet YYY Sheet XXX and YYY already exist, as do 900 other sheets. I have no VBA skill.  :(-- mehare ------------------------------------------------------------------------ mehare's Profile: http://www.excelforum.com/member.php...o&userid=37483 View this thread: http://www.excelforum.com/showthread...hreadid=571844 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Too Complicated For Me
In J2 of Sheet XXX enter =IF(A1=XXX,B1,"")
In J2 of Sheet YYY enter =IF(A1=YYY,B2,"") "mehare" wrote: when A1=XXX, paste B1 into J2 of Sheet XXX when A2=YYY, paste B2 into J2 of Sheet YYY Sheet XXX and YYY already exist, as do 900 other sheets. I have no VBA skill. :(-- mehare ------------------------------------------------------------------------ mehare's Profile: http://www.excelforum.com/member.php...o&userid=37483 View this thread: http://www.excelforum.com/showthread...hreadid=571844 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Too Complicated For Me
The problem becomes that if A1 doesn't = XXX I want it to check A2 and continue to check down column A to the end of the list. I need it too check the next cell in the column if it doesn't get a "true" response. -- mehare ------------------------------------------------------------------------ mehare's Profile: http://www.excelforum.com/member.php...o&userid=37483 View this thread: http://www.excelforum.com/showthread...hreadid=571844 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Too Complicated For Me
sounds like you need to do a VLOOKUP in column A to populate cell J2 in the remaining sheets. This will only work if column A is sorted alphabetically. otherwise could you do a MATCH within an INDEX to find the data. -- carstowal ------------------------------------------------------------------------ carstowal's Profile: http://www.excelforum.com/member.php...o&userid=37476 View this thread: http://www.excelforum.com/showthread...hreadid=571844 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complicated value lookup | Excel Discussion (Misc queries) | |||
| Complicated Question | Excel Worksheet Functions | |||
| Complicated Stacked Bar Chart? | Charts and Charting in Excel | |||
| Complicated Formula | Excel Discussion (Misc queries) | |||
| How do you create a complicated pivot table graph? | Charts and Charting in Excel | |||
Linear Mode
