If then statement Excell 2000
What would the proper sequence be to prform the following:
IF A2=A3, THEN copy C2 to C3, D2 to D3, E2 to E3, H2 to H3. Is this possable? Thanks much |
If then statement Excell 2000
You have a reply to your post in .misc
holy dog wrote: What would the proper sequence be to prform the following: IF A2=A3, THEN copy C2 to C3, D2 to D3, E2 to E3, H2 to H3. Is this possable? Thanks much -- Dave Peterson |
If then statement Excell 2000
I have a mcro that will do the same function, but now have this issue:
need this macro to automactically fill in down a colum, but to skip any cells with data in it. After it skips the cell with data it will use that cell for the new data until it hits and skips another cell with diferent data and repeats using new data. ' ' Macro5 Macro ' Macro recorded 12/16/2005 by Fairview ' ' Keyboard Shortcut: Ctrl+a ' ActiveCell.Offset(-1, 0).Range("A1").Select Selection.AutoFill Destination:=ActiveCell.Range("A1:A2"), Type:= _ xlFillDefault ActiveCell.Range("A1:A2").Select ActiveCell.Offset(1, 0).Range("A1").Select End Sub any ideas? thanks much "holy dog" wrote: What would the proper sequence be to prform the following: IF A2=A3, THEN copy C2 to C3, D2 to D3, E2 to E3, H2 to H3. Is this possable? Thanks much |
All times are GMT +1. The time now is 11:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com