troubleshooting Question

VBA snippet please? To copy various non contiguous Table rows to append to that table.

Avatar of Anthony Mellor
Anthony MellorFlag for United Kingdom of Great Britain and Northern Ireland asked on
VBAMicrosoft ExcelMicrosoft Office
9 Comments1 Solution29 ViewsLast Modified:
At the point of insertion, pause and ask for my "ok" or allow me to choose a different insertion point.
Insertion point to be above third row from the bottom, and make it clear what I can change in the code to make that say the 4th or whatever.

Please keep it very simple (that means no abstract thought or variables if at all possible) as I will be copying it into VBA as desired for use and otherwise keeping it outside Excel and i want to be able to understand it.

Maybe I will surrender to VBA for this, we will see

Here is the current file,

The table is in the DATA sheet. 

What you are doing is taking existing transactions and copying them to be re-used for new but similar transactions. This is more of a pain in a structured table than one that is not structured.

Probably apparent I am not right now sure if I want to append or to insert.  Which ever is easier to code is fine.

Anthony Mellor

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros