I need some help i need a Macro Code to arrange certain cells and prepare it as a row.
I export the file from SharePoint in Excel Format. The data of the form is in Linear.
The data comes in one row. However I need to transpose and get the Set of Cells in Row By Row.
For Example: J1:R9 is one set then S1:AA1 must come below. Its a pattern of 9 Fields.
Sorry, I tried doing as you had instructed. However, i would like to repeat myself.
InfoPath form is saved in Share Point > I Export the data from SharePoint > Then My The Extracted data is as below.
Staff Name|Company|Designation|In Date|In Time|Out Date|Out Time|Staff Name|Company|Designation|In Date|In Time|Out Date|Out Time
Imran Khan|Company|Designation|Date |07:00 |Date |15:30pmImran Khan|Company|Designation|Date |07:00 |Date |15:30pm
Well initialize a variable, lets call it "rowscount"
Now, set the variable with a value, in this case, it will be the number of empty cells in column "A". We perform that task with the following command:
rowscount = Cells(ThisWorkbook.Worksheets("YOUR_WORKSHEET_NAME").Rows.Count, 1).End(xlUp).Row
Now, loop using the value of rowscount. You do know how to construct a loop, don't you?
Thank you for replying. I am actually new to this Excel and Macro.
It's very challenging for me to do this. I got no friends or anyone in my work place to help me with this macro.
It shall be helpful, if you help me code this with the loop code.
I desperately need this as I got very less time to show case this.
Thank you in advance.
Thanks for replying. I am new to Macros. However let me share how exactly my data is.
Staff Name|Company|Designation|In Date|In Time|Out Date|Out Time|Staff Name|Company|Designation|In Date|In Time|Out Date|Out Time and so on.
Output i want is in another sheet.
Staff Name|Company|Designation|In Date|In Time|Out Date|Out Time
Imran Khan|Company|Designation|Date |07:00 |Date |15:30pm
Imran Khan|Company|Designation|Date |07:00 |Date |15:30pm
Imran Khan|Company|Designation|Date |07:00 |Date |15:30pm