copy down

nirola · #1 09-08-2008, 09:52 AM

Hi,

I have around 40000 rows each in 10 tabs with 4 columns.

On B column i have different names of our divisions. say on b2 its division New york and on B10 its Tulsa and then on B29 its tronto and then on b 55 its some other city and so on .... Please note that the space between B3 and b9 and then from B11 to B28 is empty as its relates to the above division i/e from B3 to B9 is New york and then from B11 to B28 its Tulsa and so on..

Now i need a shortcut to copy the divison name on the blank cells-* below each division. Please note that the division names may be reapeated more than once too.
Cntrl D cant work as i have to repeat the steps again and again or dragging as this also invloves repeated work.

Thanks for your understanding in advance.

Colum A is serial number column C is invoice number and D is amount.

Dav · #2 09-08-2008, 09:59 AM

Create another column
in row 2 =if(b2="",b1,b2)

then copy the formula down

Does that help

Regards

Dav

**NBVC** · #3 09-08-2008, 10:03 AM

Select from B2 to last entry in column B and then hold the CTRL key and select B2

Then go to Edit|Go To and click Special....select Blanks and click Ok.

enter an = sign and hit the up arrow key.

Hold the CTRL key again and hit ENTER.

You will have to copy down the last entry if needed..

nirola · #4 09-08-2008, 11:53 AM

Quote:

Originally Posted by Dav

Create another column
in row 2 =if(b2="",b1,b2)

then copy the formula down

Does that help

Regards

Dav

THANKS for your understanding and PERFECt answer......
Thanks Buddy.

nirola · #5 09-08-2008, 11:57 AM

Quote:

Originally Posted by NBVC

Select from B2 to last entry in column B and then hold the CTRL key and select B2

Then go to Edit|Go To and click Special....select Blanks and click Ok.

enter an = sign and hit the up arrow key.

Hold the CTRL key again and hit ENTER.

You will have to copy down the last entry if needed..

This one is SUPERB much much better

THANKS you both

nirola · #6 09-08-2008, 12:09 PM

Quote:

Originally Posted by Dav

Create another column
in row 2 =if(b2="",b1,b2)

then copy the formula down

Does that help

Regards

Dav

tHIS IS NOT HELPING AS only one cell below the already filled cell is getting the answer and rest are giving 0

Dav · #7 09-09-2008, 04:12 AM

Sorry if you are putting the formula in column C

in row 2 =if(b2="",C1,b2)

Regards

Dav

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel no copy, users must use origonal	user phil	Excel - New Users	2	02-23-2008 10:02 AM
macro to copy and paste data	erock24	Excel Programming	4	02-11-2008 10:28 AM
Search & copy from one sheet to another?	amyngordon	Excel Worksheet Functions	1	08-05-2007 08:55 PM
excel worksheet copy formula	Cntrygrl	Excel Worksheet Functions	7	03-12-2007 10:31 AM
Worksheet copy problem	Willow	Excel Programming	3	09-28-2006 10:56 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)