Hi,
I try to figure out a way to copy data dynamically. There are about 45,000 rows in the spreadsheet and there are two columns that I need to copy down. Column A lists the hierarchy key and column B lists the name. Until it hits another different key, the cell will be empty. However, for data extraction purpose, I need to know each line item belongs to which hiearchy. Thus, I need to copy the data from the hiearchy down until another hiearchy populates and procesess repeats itself. I can manually copy the data but like to know how I can code the VBA to copy it dyanmically?
----example
ColA ColB Colc Amount
Ups Upstream lx.343.31 $2
sx.433.12 $1
Dws Downstream lx.433.13 $1
dx.313.31 $2
Any advice is greatly appreciated!
Howdy
I try to figure out a way to copy data dynamically. There are about 45,000 rows in the spreadsheet and there are two columns that I need to copy down. Column A lists the hierarchy key and column B lists the name. Until it hits another different key, the cell will be empty. However, for data extraction purpose, I need to know each line item belongs to which hiearchy. Thus, I need to copy the data from the hiearchy down until another hiearchy populates and procesess repeats itself. I can manually copy the data but like to know how I can code the VBA to copy it dyanmically?
----example
ColA ColB Colc Amount
Ups Upstream lx.343.31 $2
sx.433.12 $1
Dws Downstream lx.433.13 $1
dx.313.31 $2
Any advice is greatly appreciated!
Howdy