LinkBack URL
About LinkBacks
Hi! i need for a vba with this condition : if i check x in column B, in column A will be allocate a unique number(for Sheet1.............Sheet6).All sheets will be copy in sheet Master. Thanks
Hi! i need for a vba with this condition : if i check x in column B, in column A will be allocate a unique number(for Sheet1.............Sheet6).All sheets will be copy in sheet Master. Thanks
Not clear
I think it is better to upload sample workbook with some of desired output
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
so if in column B from Sheet1 i will write x, then in column A will be alocate automatically a unique number. All data from A1:Z50 will be copy in Master
Upload sample of your file with some of the expected output
I uploaded a file with a little example
Try this code
Sub Test() Dim ws As Worksheet Dim cel As Range Dim r As Long Application.ScreenUpdating = False For Each ws In Worksheets If ws.Name <> "Master" Then For Each cel In ws.Range("B1:B" & ws.Cells(Rows.Count, 1).End(xlUp).Row) If cel.Value = "x" Then r = r + 1 Sheets("Master").Range("A" & r).Value = cel.Offset(, -1).Value End If Next cel End If Next ws Application.ScreenUpdating = True End Sub
hi! if i put "x" in column B from Sheets1, 2, 3, not happening nothing
hi! please help me! i want to allocate automatically number in column A, in in column B check x for every sheets, excepting Master.
i want to allocate unique number on column A from sheets 1, 2, 3 automatically, and all data copy to master. if in column A from Master is already a number, in sheets 1,2 ,3 this number can't be allocated
nobody can help me?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks