Copy data from one sheet to another with dynamic range selection
If I have a list of data (say 20 rows) with some repeat entries - is it possible to create a drop down selection box which shows only 1 of each individual occurrence?
For example if I have
etc - Apple would only show once in a drop down selection list.
I need to copy a range of cells data from one worksheet to another.
In the source worksheet, I have a specific number of columns but the numbers of rows should be dynamic, it should be able to expand until it finds an empty row.
It then takes this range of cell data and copies it to another worksheet starting at a specific cell (namely, A9)
In Sheet1, columns A,B,C,D,E, and F have data. with the help of a micro, I wish
to copy(paste value) the Column F (range F2:F130) to Column G (G2:G130), and then to
Column H, I, J,K, L. So If column G is filled, next copying may be in H and
destination range H2:H132
I currently have weeks of data on sheets. Our sales numbers for week 1 are on sheet "1". Week two is "2" and so on.
I need to bring all the data together.
='1'!E4 works if I click on the individual cell, but I have thousands of cells, and is too time consuming
I know this can be done in VBA, but I'm trying to avoid that. It may be impossible
I was thinking something with the & but couldn't get it to work with with formulas
=' & H2 & '!E4
Where H2 equals the week that I am searching for
The below code shows an error in the second line . if give sheet1.Range("C10").select its working fine but I want to populate the
I value from C1 to C100 cells.
For I = 1To 110 Step 1
varnisher = Selection.CurrentRegion.Rows.count Selection.Value = I Next I
Related Applications & Scripts
What it is Dynamic Background
Its an easy to use component to put dynamic floating backgrounds that react to the mouse position. You can have great effects on your flash website.
How to use Dynamic Background
Just drag and drop the DynamicBackground component to your movie clip.
Dynamic menu, items include title and subtitle, configurable design via timeline and data via actionscript array.
Lightweight and beautiful flash text field with dynamic data load through the xml file.
This is a dynamic and intuitive photo viewer driven by XML . Images and text are very easy to modify and update by changing the XML document.