Hello:
Please refer to attached file.
I have data as shown.
Need VB Code to cut and paste all positive data from column E and paste at its respective row in column F.
In this case highlighed will be moved @ cell F9
Once this is done then select column E and convert all cells to positive number.
Lastly, need formula to be added in cell H2 down to the last row of the data.
Formula in cell H2 = H1+E2+F2 and copy down.
Let me know if you have any questions.
Thanks.
Riz
Something like below?
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Not sure I've understood the requirement fully, but from my interpretation of post#1 perhaps this:
BSBPlease Login or Register to view this content.
Ah, I had missed convert E to positive. Modified code below.
Please Login or Register to view this content.
And I missed the CUT and paste so my amended code is:
We get the same results now at leastPlease Login or Register to view this content.
BSB
Hello CK and Badly:
Works great, thanks a lot.
Last request, need to do search in column C for DEPOSIT ***** and change to DEPOSIT.
Please help get the code for this.
Thanks
Riz
Combining all, something like below. Or you can do Column C separately.
Please Login or Register to view this content.
Hi ! try this ‼
Originally Posted by rizmomin
Like operating manually as a beginner starter :
PHP Code:Sub Demo1()
Dim Rg As Range
With Sheet1.UsedRange.Rows
.Columns(5).AutoFilter 1, ">0"
With .Item("2:" & .Count).Columns
.Item(5).Copy .Item(6)
.Item(5).ClearContents
.AutoFilter
.Item(5).Value2 = .Parent.Evaluate(Replace("IF(#<0,-#,"""")", "#", .Address))
.Item(8).Formula = "=H1+E2+F2"
Set Rg = .Item(3).Find("Deposit *", , xlValues, xlWhole)
Do Until Rg Is Nothing
Rg.Value2 = "Deposit"
Set Rg = .Item(3).FindNext(Rg)
Loop
End With
End With
End Sub
Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !
Last edited by Marc L; 08-09-2018 at 12:34 PM. Reason: mod for deposit …
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks