Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy only from a cell with data in it
I have a sheet with data set in a single row. here is what i need hopefully i write it right. example cells a1-z1 aa1-az1 ba1-bz1 not all cells have info but say a1-a5 have info a6 is blank so i nee to check ab6, if it has info i need to copy it, if not i need to go t ba6 to see if it has data, if it does copy it. After i have copied th data i need to start back at the next cell a7 in this example and g thru the cycle again until i get to the end z1 in this case. This inf will be pasted onto another sheet transposed from a row to a column (sa sheet2 , c1 in this case). Thanks for the help Joe -- Joe ----------------------------------------------------------------------- JoeH's Profile: http://www.excelforum.com/member.php...fo&userid=1413 View this thread: http://www.excelforum.com/showthread.php?threadid=26267 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy last cell with data in column E on one sheet to cell on anoth | Excel Worksheet Functions | |||
How do I copy data from main frame computer and keep data in cell | Excel Worksheet Functions | |||
Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
How do I copy data from one cell to the next occurrence of data? | Excel Worksheet Functions |