After you fill in the cells, you may want to paste the formulas as
values, so you could sort the data without problems. There are
instructions he
http://www.contextures.com/xlDataEntry02.html
SEOJAPAN wrote:
Hi Ryu!
I had the same questions and happy to see that we are not alone!
just do the following:
Select the Row or Rows to fill
F5 Select empty cells
press = and then select cell at top of the fist selected cell
Control + enter
All cells will fill automatically!
Best,
SEOJAPAN
ryu wrote:
Hi!
I wonder if someone could give me a hint of how to auto fill cells or
rows when they don't have a pattern.
Every month I pull data with 3000+ entries in CSV format.
Each cell follows a row order (eg. Row1=Group, Row2=Term, Row3=SE,
etc.), however, when data on cell A1 is the same as B1, and then B1
comes empty.
Also, if data on A1 is same as B1, but data on A2 is different than
B2,
then A2 and B2 have their corresponding data but B1 is still empty.
Until now, I have selected the empty cells (one by one) and performed
a
"copy down" (ctrl+D) but I am getting tired of that (more than half
of
the 3000+ entries come empty many times).
I cannot sort the entries or perform an auto fill, as the data
doesn't
follow a pattern.
If possible, I would like to find a way to do it easily and without
having to spend too much time formatting the data.
Does someone have a hint or idea of how to fill those blank cells?
You can have a look at http://home.att.ne.jp/omega/riushi/excel.gif
for
a clearer idea of this issue.
Thanks in advance!
Ryu
PS: Macros knowledge almost 0. Using Excel 2004 for Mac
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html