Posts by ArhamRajput

Hi, I have an issue with command Button trying to change its position but not working. Please share Solution and also share that how we can drag the button with mouse.

Thanks for Helping me out.

I need proper formula to do this activity first i am concatinating then putting Vlookup there will be any single formula which could help in this regard.

mdenino

Waiting for response.

davesexcel

Thanks Dave for the help.

Alright let me clear you with the example please check the formula that i am using to get the result.

Please check tat what i want.

I have three Columns in sheet 1st have Dates 2nd ID's and third Names and same are in other sheet but are shuffle.

And now i want to check with these three columns that which are similar.

Please share solid solution to check similar Name ID's and Dates.

attached below there are two different files please share formula to check and also VBA Code

you should mention that you have edited my post and it is not mentioned in ForumRules Super Moderator can edit the post. I have apologies for cross posting.

Your code is working but each workbook which is being create via VBA code its name starts with NewFolder as listed below.

New FolderShoaib

New FolderHaider

New FolderKhan

New FolderAhmer

Please remove New folder condition from below VBA

Sub CreatWB()
Dim rng As Range
Dim c As Range, sh As Worksheet
Dim wb As Workbook, nWb As Workbook
Dim dr As String

dr = "C:\Users\dmorrison\Desktop\Test2\"
Set wb = ThisWorkbook
Set sh = wb.Sheets(1)
Set nWb = Workbooks.Add

With sh
Set rng = .Range("A1:A" & .Cells(.Rows.Count, "A").End(xlUp).Row)

For Each c In rng.Cells
nWb.SaveAs (dr & c & ".xlsx"), 51
Next c
End With



End Sub

davesexcel

Waiting for response.

is it restricted that one can active just on single helping forum.

I shared that i need to make new workbooks with desired name.

Which duplicates.

Now i have no idea where it was posted but next time i will definitely share link reference.

Your code is working but It is mentioned newfolder with name please see attached file.

Newfolder should be removed just Name should be there

workbooks will be as

Actually i have 60 separate person names and if i create 60 blank workbooks and put each name on that workbook it will take maximum time but i want VBA code to do this.

I have Approx 60+ Names with their number and i want VBA code to put these 60 names into workbooks name numbering wise as

1. Haider

2. Shameer

3. Ali

4. Yasir

5. Ahmer

and so on.

Please share VBA Code.

Yes formulas are in your previous post. But Recently i have added a attachment in which also a formula is required.

that is attachment.

There is not formula in the workbook. I just separate the required details and wants a formula which will do the same.

royUK