J
Julmau
Hi,
I hope someone will help (sorry to ask again if these questions have
already been answered in this forum).
In a workbook, I use “x” similar worksheets in which I use the
following for each worksheet: D25
38=a date, every two rows (can be
following dates, but can also be non-following dates); E25:E38=one or
more file numbers per row (i.e., E25=152; E26=EF125, GV25-150
(separated by a coma and a space); ect. (can be numbers, combination of
number(s) and letter(s), can be anything…)); and finally M3=a reference
number for each worksheet (i.e., 2004-56). I input every date and file
numbers manually in each worksheet, and the reference number is
automatically incremented in each worksheet. It is possible that the
same file number may be found at to different dates in the same
worksheet.
I want to summarize things in another workbook but I want file numbers
to be separated: Column A=date; column B=file number (one row/file
number); column C=reference number.
What would be the functions in columns A, B, and C in order to get EACH
separate file number found in E25:E38 in a separate row (following
rows) in column B, with the corresponding date in column A, and the
corresponding reference number in column C. (Date is in column A
because the report must emphasize on the date, and the same file number
(if any) must appear in separate rows if coupled to different dates)).
Thank you
Julmau
I hope someone will help (sorry to ask again if these questions have
already been answered in this forum).
In a workbook, I use “x” similar worksheets in which I use the
following for each worksheet: D25
38=a date, every two rows (can befollowing dates, but can also be non-following dates); E25:E38=one or
more file numbers per row (i.e., E25=152; E26=EF125, GV25-150
(separated by a coma and a space); ect. (can be numbers, combination of
number(s) and letter(s), can be anything…)); and finally M3=a reference
number for each worksheet (i.e., 2004-56). I input every date and file
numbers manually in each worksheet, and the reference number is
automatically incremented in each worksheet. It is possible that the
same file number may be found at to different dates in the same
worksheet.
I want to summarize things in another workbook but I want file numbers
to be separated: Column A=date; column B=file number (one row/file
number); column C=reference number.
What would be the functions in columns A, B, and C in order to get EACH
separate file number found in E25:E38 in a separate row (following
rows) in column B, with the corresponding date in column A, and the
corresponding reference number in column C. (Date is in column A
because the report must emphasize on the date, and the same file number
(if any) must appear in separate rows if coupled to different dates)).
Thank you
Julmau