Search for "yes" in a cell, then copy information from other cells to another tab
Expertise level - beginner
Excel 2007
I have a workbook that has several tabs. One tab is my "working" tab. From this tab I want to copy information to "presentation" tab if a cell = "yes". When it copies to "presentation" I need it to look for the next empty row and fill in cells based on the cells in my "working" tab.
i.e. "working" tab: H4=yes, then copy B4, C4, D4, E4, F4, G4 & H1(yes, H1-this will be a constant) to the next empty row in "presentation" tab. The columns will correspond between the "working" tab and "presentation" tab (B4 in "working" tab will go to the B column of "presentation" tab, but in the next empty row.)
I hope this is clear.
Thanks for any help.
newton, just login and edit
newton, just login and edit your post... you can upload the file
In the worksheet that
In the worksheet that contains the YES, setup a DO loop that will select the first cell and then IF that cell = "YES", select it and copy it
Then select the worksheet you want to copy it too and use this code
Range("A1").End(xlDown).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
The Range("a1") is strictly an example range
If you send me the file I will gladly write the code for you
Thanks for the offer - I'd like to take you up on it.
Mjl,
Thanks for the comment back and offer to write the code. Sorry for the delay in getting back to you.
How do I e-mail the file?
have a look at this:
have a look at this: http://excelexperts.com/VBA-Tips-Find-The-Last-Cell
Thanks, but I need more direction
Nick,
Thanks for the link. I reviewed it and understand it a bit. I am a beginner in VBA, so I appreciate your patience.
I really need something that does the transfer automatically and help with the entire process.
Thanks