Previous Topic Next Topic

Fill Names in Col A

Closed
prkhan56 Posts 1 Registration date Monday February 6, 2012 Status Member Last seen July 25, 2012 - Jul 25, 2012 at 03:47 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 26, 2012 at 06:58 AM
Hello All,
I have the following problem in Excel 2010. My data shows Name 1 to Name 5 followed by Data in Col B to F as described below:

B5 = Name1 - Data from B6 to F800
B801 = Name2 - Data from B802 to F879
B880 = Name3 - Data from B881 to F895
B896 = Name4 - Data from B897 to F905
B906 = Name5 - Data from B907 - F913

I want a macro to repeat the respective names in Col A viz

Name1 to be filled from A6 to A800
Name2 to be filled from A802 to A879
Name3 to be filled from A881 to A895
Name4 to be filled from A897 to A905
Name5 to be filled from A907 to A913

Any help would be appreciated

TIA

Rashid


Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jul 26, 2012 at 06:58 AM
6 to 800 ------795 rows
802-879------78 rows
881-895-------15 rows
899-905-------7rows
907-916-------7rows

there is no great logic. so do it manually
0

Similar discussions

Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses
Copy range data in a column to new column.
anthonyishere -
anthonyishere -

6 responses