Hi,
I have a spreadsheet which has an output of order numbers and order details raised by differrent users. The problem with the spreadsheet in its current format is that I am unable to use data filter and choose all orders by a particular users
Column A, B & C are blank.
Rows 1-9 have data in them but are not required
Cell D10 has the User's name in this format "requisitioner: James Jones"
Row 11 has some usefull column headers which i would like to keep
D11=PO Number
G11=PO Date
L11=Order Status
Q11=Receipt Status
S11=Invoice Status
X11=Total Value Not Received
Some columns have no data and could be deleted/stripped out:-
ABC,E,F,I,J,K,M,N,O,P,RT,U,V,W
The following rows below this contain the information regarding orders place by that particular user, except to compicate things further some rows are blank, so we might have order data in row 13 then 17 then 21 - it's not always a 4 row space, sometimes only 2(!)
This would repeat down to say row 49 where we would then get the user details such as "Requisitioner: Jane Smith"
In the next row we would get the same column headers, PO number etc and then row containing the data with some blanks again.
Seems like a bit of a nightmare,I'm wondering if this can this all be done using VBA - or it is too difficult?
I have a spreadsheet which has an output of order numbers and order details raised by differrent users. The problem with the spreadsheet in its current format is that I am unable to use data filter and choose all orders by a particular users
Column A, B & C are blank.
Rows 1-9 have data in them but are not required
Cell D10 has the User's name in this format "requisitioner: James Jones"
Row 11 has some usefull column headers which i would like to keep
D11=PO Number
G11=PO Date
L11=Order Status
Q11=Receipt Status
S11=Invoice Status
X11=Total Value Not Received
Some columns have no data and could be deleted/stripped out:-
ABC,E,F,I,J,K,M,N,O,P,RT,U,V,W
The following rows below this contain the information regarding orders place by that particular user, except to compicate things further some rows are blank, so we might have order data in row 13 then 17 then 21 - it's not always a 4 row space, sometimes only 2(!)
This would repeat down to say row 49 where we would then get the user details such as "Requisitioner: Jane Smith"
In the next row we would get the same column headers, PO number etc and then row containing the data with some blanks again.
Seems like a bit of a nightmare,I'm wondering if this can this all be done using VBA - or it is too difficult?
