Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
put data from cells into other cells
Hi Guys,
I have posted a request and recieved an answer but it does not do what I require although it does exactly what I asked :-( I'll try and re-phrase I have 5 cells per day Mon B1:B5 Tues B6:B10 Wed B11:B15 etc etc. Now on Monday I might only complete 2 jobs and Tuesday I might only complete 1 job and Wednesday I may complete 4 jobs, thus utilising cells B1,B2,B6,B11,B12,B13,B14 Now I have to fill out another part of the spreadsheet E75:E100 with the info in cells B1:B25 but with no spaces except one space between days so E75,E76 would contain mondays stuff E78 Tuesdays E80,E81,E82,E83 Wednesday etc But because jobs completed in anyone day varies between 1 and 5 i'm not sure what I need to do. many thanks in advance and thanks to DMEXCEL for the rapid response. Hopefully this is clearer Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting hover data labels to cells other than source data | Charts and Charting in Excel | |||
Setting hover data labels to cells other than source data | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel |