to replace cell
Hi,
Would like to fill in a blank cell with something, it located in another area of the list, it looks like this, **** means blank cell merchant 1234 Totals **** I would like to put the merchant number next to the total cell. |
to replace cell
If your data is in A1 thru A3, then in B3 enter:
=A2 -- Gary''s Student - gsnu200907 "Bklynhyc" wrote: Hi, Would like to fill in a blank cell with something, it located in another area of the list, it looks like this, **** means blank cell merchant 1234 Totals **** I would like to put the merchant number next to the total cell. |
to replace cell
it works for the first batch, but my list continue on about 40 to 50 batch
and some batches has more lines which look like this merchant 1234 1234 1234 1234 Totals **** is there a formula? "Gary''s Student" wrote: If your data is in A1 thru A3, then in B3 enter: =A2 -- Gary''s Student - gsnu200907 "Bklynhyc" wrote: Hi, Would like to fill in a blank cell with something, it located in another area of the list, it looks like this, **** means blank cell merchant 1234 Totals **** I would like to put the merchant number next to the total cell. |
to replace cell
Hi,
You essentially want the blank cell to be equal to the value in the cell one cell to the left (of the blank cell) and then one cell above. Select the column which has the blanks and then do Ctrl+G Special Blanks. This will select all the blank cells. Now press the left arrow key and up arrow key to select the cell. Now press Ctrl+Enter. Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bklynhyc" wrote in message ... it works for the first batch, but my list continue on about 40 to 50 batch and some batches has more lines which look like this merchant 1234 1234 1234 1234 Totals **** is there a formula? "Gary''s Student" wrote: If your data is in A1 thru A3, then in B3 enter: =A2 -- Gary''s Student - gsnu200907 "Bklynhyc" wrote: Hi, Would like to fill in a blank cell with something, it located in another area of the list, it looks like this, **** means blank cell merchant 1234 Totals **** I would like to put the merchant number next to the total cell. |
All times are GMT +1. The time now is 09:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com