Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

modifying code copy data from userform to the next columns

0

hello 

after searching   long  time  I' v found  this  subject   and  the  file  is for  MR. Variatus  

https://www.teachexcel.com/talk/5189/insert-a-new-row-before-total-each-category-based-on-selected-combobox

he  achieved  this  project  excellantly   actually  I'm new in vba  so  I   hope  from him  or  anybody  help  to  mod  the  code ,   I added two textbox  on userform   PUR and SELL to   add the  values  what  I want  if  I add a new brand  the code  works  insert a new  and  fill the  data but  what  i  miss to be  add values  to  the next empty column every  month add three column   and  if  I  add the  values  to  brand has already existed  it  should not  insert  a new row and  fill it  just  add  the  values  to  the  next empty  columns  because it's existed  I add some  comments inside  the  file  if  it's not  clear  please inform me

thanks in advance 

Answer
Discuss

Discussion

Hello Hasson,
Welcome back.
This forum is called "TeachExcel". The idea is, someone asks a question and he gets a smart answer, many people will want to learn from it. Your post has no question, only a task descripton. You don't want an answer, only get the job  done. I think this thread isn't good for the forum because no one will learn anything from it.
Sorry.
Variatus (rep: 4889) Mar 16, '21 at 6:29 am
thanks  but  my  request  has  Idea   it's  very  important  to  add  the  values and  copy  data  differently  it  copy  to  the  next column  not as  usual copy  to  the  next row  and   I've  found  it  doesn't  logical  to add  the  brands  without  any  value   if   you  search   to  take  advantage  and teach  from this  forum  the others members  as  you say  will find  in  my  request  any  way  thank  you  for  the  feedback  and  i hope  accept  my  view 
by the  way  this  the  first   post  I  issue  , may be  I misunderstood  the  restrict constrains  in  this  forum   how  should  issue  the  post 
my  apologies!
Hasson (rep: 30) Mar 16, '21 at 3:19 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login