I want to separate name and id from ColA to ColB as name and ColC as ID's please share formula. Name / Primary - ID / Secondary - ID...
Posts by ArhamRajput
-
-
Please share an formula for this also same situation.
-
Thankyou so Much
-
I was looking for any formula or VBA code to separate Name and DOB from raw data please help.
-
Here is exact screenshot
-
Yeah it is working file but first sheet format is not apply on new sheet which applies on last rows after completing the data.
-
Can you please edit the given Code if this is possible i would be really thankful.
-
Thankyou for help
-
Yeah i want to copy all the data which is available in sheet.
-
Using below code to copy data from other workbooks in current sheet and below code is not copying used range please add used.range code in below VBA.
Sub FirstRows() Dim wbSrc As Workbook, shtSrc As Worksheet, wbDest As Workbook, shtDest As Worksheet, rngDest As Range Dim fso As New FileSystemObject, fFolder As Folder, fFile As File, strFolder As String, iRows As Integer strFolder = "Z:\Updated CDI Work\New folder" iRows = 3 'Change the number of rows you want here Set wbDest = ThisWorkbook Set shtDest = wbDest.Sheets("Sheet1") Set rngDest = shtDest.Range("A1") Set fFolder = fso.GetFolder(strFolder) For Each fFile In fFolder.Files Set wbSrc = Workbooks.Open(fFile.Path, False, True) Set shtSrc = wbSrc.Sheets("Sheet1") shtSrc.Range("A5").Resize(iRows, 1).EntireRow.Copy 'Change the "A1" reference to the starting row required rngDest.Resize(iRows, shtSrc.Columns.Count).PasteSpecial xlPasteValues rngDest.Resize(iRows, shtSrc.Columns.Count).PasteSpecial xlPasteFormats Application.CutCopyMode = False wbSrc.Close False Set rngDest = rngDest.Offset(iRows, 0) Next End Sub -
-
Yeah whenever i need to add more members then have to do laborious work again.
-
There is no other solution with VBA except given
-
Probably you have attached wrong sheet.
-
Actually i have made this sheet you can check the attached file but it took long time while copy pasting and entering date weekday formula.
-
I was looking to find VBA that could help me with attached format.
I have 15 person which productivity is being noted on this sheet and want to run this sheet via VBA code till the last week of year which would be end on Saturday as last day and sunday will be start of the week.
In attached sheet i created an example of Week 1 and want to mention week2, week3 4,5 and so on till last week of year with weekdays and dates as mentioned in sheet and with same format please help in this regard.
-
thank you for your kind support it is working well.
-
-
Yeah actually i was looking for VBA but right now situation is that after applying VBA it should adjust Column C "Complete Name" with Col C "First Name" and Col D "Last Name" I hope you will understand.
I dont want same format ahead but to adjust picture is attached below
-
Thanks Carim.