Solved

code Moficatio

Posted on 2016-08-25
3
44 Views
Last Modified: 2016-08-25
I had this question after viewing Code Modification.
Hi Experts,

need little change in existing code -----Module SingleToPost - Sub Cash - which post entries to sheet Cash & Sheet LogFile ...i need bit changes when it  post to Sheet LogFile....in present scenario it over past cash entries in LogFile need to post new entries in last available rows.

See Attached

Thanks
Portfolio-V06.xlsm
0
Comment
Question by:itjockey
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 500 total points
ID: 41770921
Do you mean you want to paste them in the first empty row available on LogFile instead of pasting always in A2?
If this is the case try this.....

With WS.Rows(1)
   .AutoFilter field:=4, Criteria1:="Cash"
   If WS.Range("A1:A" & MaxRow).SpecialCells(xlCellTypeVisible).Cells.Count > 1 Then
      WS.Range("A2:H" & MaxRow).SpecialCells(xlCellTypeVisible).Copy WSL.Range("A" & Rows.Count).End(3)(2)
   End If
   .AutoFilter
End With

Open in new window

0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 41770925
Thanks
0
 
LVL 28

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41770931
You're welcome.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an Add-On procedure to be used in conjunction with the code provided in Reducing EE Email Clutter using Outlook (http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/A_3146-Outlook-Processing-EE-emails-on-Receive.…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now