Home Upgrade Search Memberlist Extras Hacker Tools Award Goals Help Wiki Contact

.NET 

Excel copying data went wrong when recording macro

So, I am not familiar with VB at all or Excel, so I'm finding quick help on how to fix this:

https://gyazo.com/1e2aec67bcef11b707e3591b6c4a8178

Here is a GIF (I want to automate our job attendance).

So to describe the bad behavior in this GIF: I created 4 buttons that should copy cells, for Example "Add Construsoft" should copy those 3 Construsoft cells and "Add Timber" should copy 2 Timber cells in that sheet, but a there's a problem because "Add Timber" Macro remembers the same cells, so I what I need is that when "Add Construsoft" button is pressed, "Add Timber" button should count with three more cells inserted. Is there any way you can help me out guys?

https://prnt.sc/rml4zo (CODE)

Thank you very much.
(Mar 30, 2020 03:33 AM)QU35T Wrote:  So, I am not familiar with VB at all or Excel, so I'm finding quick help on how to fix this:

https://gyazo.com/1e2aec67bcef11b707e3591b6c4a8178

Here is a GIF (I want to automate our job attendance).

So to describe the bad behavior in this GIF: I created 4 buttons that should copy cells, for Example "Add Construsoft" should copy those 3 Construsoft cells and "Add Timber" should copy 2 Timber cells in that sheet, but a there's a problem because "Add Timber" Macro remembers the same cells, so I what I need is that when "Add Construsoft" button is pressed, "Add Timber" button should count with three more cells inserted. Is there any way you can help me out guys?

https://prnt.sc/rml4zo (CODE)

Thank you very much.

Damn, I understand your frustration - I work a lot with excel at my job too, and it can be so hard.
Sadly I cannot help you myself, but I will try to contact a friend and see if he can!
sas
(Mar 30, 2020 07:00 AM)Tyler Durden. Wrote:  Damn, I understand your frustration - I work a lot with excel at my job too, and it can be so hard.
Sadly I cannot help you myself, but I will try to contact a friend and see if he can!

That would be great! Thank you so much - hope he can understand of my need, that would be perfect, would tip him if he does 😋
Send me your current excel file and codes, I'll fix it for you.
(Mar 31, 2020 02:55 PM)SIM-2848601 Wrote:  Send me your current excel file and codes, I'll fix it for you.

Oh god, thank you, PMed you the file.


Possibly Related Threads...
Thread / Author Replies Views Last Post
[.NET] by Dio BrandoMar 10, 2022 09:55 AM 4 467 Mar 10, 2022 09:55 AM
Last Post: benio2
[Python] by Luffy-_-Jan 11, 2022 08:14 AM 5 162 Jan 11, 2022 08:14 AM
Last Post: Hackers
[.NET] by jodsteivant55Oct 23, 2020 05:12 AM 5 479 Oct 23, 2020 05:12 AM
Last Post: xZalurex