Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy data from 1 sheet to other sheet.
I have created a Invoice in Excel.
Where i have to enter date,invoice no., party name,item decripation. I have 8 rows where i have write decription in cells b15, c15, d15, e15 b16, c16, d16, e16 b17, c17, d17, e17 b18, c18, d18, e18 b19, c19, d19, e19 b20, c20, d20, e20 upto 8 rows. what i want to copy each cell of desciption and also date,invoice no., party name, in to sheet2. i.e. i should be like date,invoice no., party name, and item deciption of cell b15, c15, d15, e15 and in next row date,invoice no., party name, and item deciption of cell b16, c16, d16, e16 and so on. any help thanks in advance. ****al shah |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy data from 1 sheet to other sheet.
Hi
if you'ld like to email me direct (julied_ng at hcts dot net dot au) i'll be happy to send you a sample invoicing workbook that does what you're after. Cheers JulieD "****al shah" wrote in message ... I have created a Invoice in Excel. Where i have to enter date,invoice no., party name,item decripation. I have 8 rows where i have write decription in cells b15, c15, d15, e15 b16, c16, d16, e16 b17, c17, d17, e17 b18, c18, d18, e18 b19, c19, d19, e19 b20, c20, d20, e20 upto 8 rows. what i want to copy each cell of desciption and also date,invoice no., party name, in to sheet2. i.e. i should be like date,invoice no., party name, and item deciption of cell b15, c15, d15, e15 and in next row date,invoice no., party name, and item deciption of cell b16, c16, d16, e16 and so on. any help thanks in advance. ****al shah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
copy data of two cells from Sheet 2 into one cell in Sheet 1 | Excel Worksheet Functions | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions |