BarryL
Well-known Member
- Joined
- Jan 20, 2014
- Messages
- 1,436
- Office Version
- 2019
- Platform
- Windows
- MacOS
Hi All,
I'm building a macro that will delete and format a spreadsheet. It's a read only so every month new info will be pasted in and the macro will be run through a button and it will format it and delete any info thats not needed. The problem I'm having is that in column A there is a fund name lets say AAA on line 3 then column B and C are filled with codes of equities and names of equities respectively but on line 50 a new fund starts and again on 98 and so on. Every month the funds are different sizes and what I am trying to do is make column A equal to the correct fund. example:
<TBODY>
</TBODY>
What i want the macro to do is fill in column A (among other things) like this:
How do i achieve this with a formula without overwriting the other funds?is there a formula i can you for the whole of column A that can pull in the write fund the whole way down the page?
Thanks for your time.
<TBODY>
</TBODY>
I'm building a macro that will delete and format a spreadsheet. It's a read only so every month new info will be pasted in and the macro will be run through a button and it will format it and delete any info thats not needed. The problem I'm having is that in column A there is a fund name lets say AAA on line 3 then column B and C are filled with codes of equities and names of equities respectively but on line 50 a new fund starts and again on 98 and so on. Every month the funds are different sizes and what I am trying to do is make column A equal to the correct fund. example:
AAA | Equity code | Name of equity |
Equity code | Name of equity | |
Equity code | Name of equity | |
Equity code | Name of equity |
<TBODY>
</TBODY>
What i want the macro to do is fill in column A (among other things) like this:
How do i achieve this with a formula without overwriting the other funds?is there a formula i can you for the whole of column A that can pull in the write fund the whole way down the page?
Thanks for your time.
AAA | Equity Code | Name Of Equity |
AAA | Equity Code | Name Of Equity |
AAA | Equity Code | Name Of Equity |
<TBODY>
</TBODY>