troubleshooting Question
VBA snippet please? To copy various non contiguous Table rows to append to that table.
asked on
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,
GVXkeeping40EE.xlsx
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
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,
GVXkeeping40EE.xlsx
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
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.