+- Hack Forums (https://hackforums.net)
+-- Forum: Tech (https://hackforums.net/forumdisplay.php?fid=444)
+--- Forum: Coding (https://hackforums.net/forumdisplay.php?fid=151)
+---- Forum: Software Development (https://hackforums.net/forumdisplay.php?fid=118)
+---- Thread: [.NET] Excel copying data went wrong when recording macro (/showthread.php?tid=6061561)
Excel copying data went wrong when recording macro - QU35T - Mar 30, 2020
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.
RE: Excel copying data went wrong when recording macro - Tyler Durden. - Mar 30, 2020
(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!
RE: Excel copying data went wrong when recording macro - QU35T - Mar 30, 2020
(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 😋
RE: Excel copying data went wrong when recording macro - SIM-2848601 - Mar 31, 2020
Send me your current excel file and codes, I'll fix it for you.
RE: Excel copying data went wrong when recording macro - QU35T - Apr 1, 2020
(Mar 31, 2020 02:55 PM)Heisen. Wrote: Send me your current excel file and codes, I'll fix it for you.
Oh god, thank you, PMed you the file.