Search:

Type: Posts; User: abdelfattah; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    93

    Re: sum data of multiple sheets

    i ment range a5: a1000 or 2000 when i add data witout specefic noumbers and this is my code but it doesn't work well
    it appers data just the columns of text witout the column of value
    ...
  2. Replies
    2
    Views
    93

    sum data of multiple sheets

    hi, experts

    i have two sheets contain data sheet1 begins from range a5: e and sheet2 begins from a4:g i need code sum data the sheet1 from b5:e with sheet2 from c4:g and the result show in...
  3. Re: print filled data of invoice with ignore the empty cells

    thanks for your replaying but i need code automatically delete the rows empty becuase sometimes a17,a18 ,etc are filling it depends on how many brands in invoice then delete the rest empty rows
  4. Replies
    19
    Views
    235

    Re: Code numbering invoice

    thanks for your efforts
  5. Replies
    19
    Views
    235

    Re: Code numbering invoice

    i appreciate for you effort and i apology for my delaying honestly i don't note your post
  6. print filled data of invoice with ignore the empty cells

    hi, every one i have data in sheet1 begins from a2: f38 the empty data begins from a17:a32 i just would code print the filled data and ignore the empty data if a17:a32=""
  7. Replies
    19
    Views
    235

    Re: Code numbering invoice

    yes now it works thank you so mauch and jmacleary
  8. Replies
    19
    Views
    235

    Re: Code numbering invoice

    now this worked but i have the problem it shows me the next number is 2 not bsjd-002
  9. Replies
    19
    Views
    235

    Re: Code numbering invoice

    it gives me error about ME
  10. Replies
    19
    Views
    235

    Re: Code numbering invoice

    i put the code in

    Private Sub UserForm_Initialize()
    TextBox3.Text = Range("F9").Value

    end sub

    then show me the numbering invoice is 2 not

    <tbody>
  11. Replies
    19
    Views
    235

    Re: Code numbering invoice

    sorry i don't follow your note now the code works perfectly but there is one thing i would show the next number in texrbox3 in userform when i run userform directly
  12. Replies
    19
    Views
    235

    Re: Code numbering invoice

    thanks for your replying but your code give me error run time13
    the error line is: .Value = .Value + 1
  13. Replies
    19
    Views
    235

    Re: Code numbering invoice

    thanks so much the code is worked but i would show the next number in textbox3 in userform directly when i run userform
  14. Replies
    19
    Views
    235

    Code numbering invoice

    hi, expert
    i have userform connect with sheet i would show the next number in textbox3
    the textbox3 connected with range in my sheet f9 i know this code range("f9").value=range("f9").value+1...
  15. Replies
    1
    Views
    105

    sum data of two table in two sheets

    hi, expert
    i have table contains data in sheet1 the range from a1: d6 and the sheet2 the same thing and theyare both contain repeated data what i would code show the data in sheet2 the range...
  16. Re: posting my data from userform to sheet with the same format table

    thanks so much the code is worked
  17. Re: posting my data from userform to sheet with the same format table

    thanks for your replying but you don't understand me your code and mine it works but the problem the format the table in sheet for instance i have color blue in my table in sheet the data...
  18. posting my data from userform to sheet with the same format table

    i have userform contains 3 textbox ans sheet1 contains data 3 columns and have table in sheet1
    here i have code transfer data from userform to sheet1 but my problem every time when i fill...
  19. Re: show the colored value of column in listview

    thanks for your replying but where exactly put the code which event?
  20. show the colored value of column in listview

    hi, everyone

    i have data in sheet1 from range (a:d) , userform contains listview and the column d containes values of colored green and red i would show the colored value of column in list...
  21. code transfer data from sheet1 to sheet2 and delete some rows with condtion

    hi, guys i would help me to code here i have sheet1 from range a2:e91 when i fill data and transfer data to sheet2 i would delete rows which contains cells a =" " then delete also ...
  22. Re: help to correct error code duplicate data

    thanks for everybody try to help me
  23. Re: help to correct error code duplicate data

    thank's so much DanteAmor it's perfectly works code
  24. Re: help to correct error code duplicate data

    thank's MoshiM but, it doesn't work you're change when i run the macro show this error "object required"
  25. Re: help to correct error code duplicate data

    let me more explanation
    i have sheet1 containes data in cells from a2: g100 ok when i fill data i have duplicated data i would transfer the data to sheet2
    SHEET1:
    a b...
Results 1 to 25 of 46
Page 1 of 2 1 2