Salik Khatri
New Member
Hi all!
Im having trouble trying to make up a formula (Macros scare me!) to automatically paste data from the main sheet (Office Expenses in my case) onto the another sheet (Q1, Q2, Q3 & Q4).
As you might have guessed, im trying to break down the expenses into quarterly reports and i want excel to divide my main sheet into 4 different periods. On the main sheet, column A has "Qtr No" and these are 1, 2, 3 & 4. Data runs from column B through to column L.
I want excel to automatically paste the entire line in its respective quarter as i enter data in my main sheet. Also, these expenses are further categorized like, salaries, communication, travel etc. E.g. Cell B10 says salaries & related costs, cell B11:B22 contains the data (for all quarters), finally cell B24 says Total salaries & related costs.
I need the sheet to not only correctly divide the data into quarters, but also under the correct heads.
Ive tried to explain to the best of my ability, i am uploading an excel file for reference.
Awaiting anxiously for the ninjas to kick in!
Regards,
Salik
p.s. i have removed my company name and some other details (last two columns dont have any data, however they will contain information, hence the formula/macro will need to incorporate it)
Im having trouble trying to make up a formula (Macros scare me!) to automatically paste data from the main sheet (Office Expenses in my case) onto the another sheet (Q1, Q2, Q3 & Q4).
As you might have guessed, im trying to break down the expenses into quarterly reports and i want excel to divide my main sheet into 4 different periods. On the main sheet, column A has "Qtr No" and these are 1, 2, 3 & 4. Data runs from column B through to column L.
I want excel to automatically paste the entire line in its respective quarter as i enter data in my main sheet. Also, these expenses are further categorized like, salaries, communication, travel etc. E.g. Cell B10 says salaries & related costs, cell B11:B22 contains the data (for all quarters), finally cell B24 says Total salaries & related costs.
I need the sheet to not only correctly divide the data into quarters, but also under the correct heads.
Ive tried to explain to the best of my ability, i am uploading an excel file for reference.
Awaiting anxiously for the ninjas to kick in!
Regards,
Salik
p.s. i have removed my company name and some other details (last two columns dont have any data, however they will contain information, hence the formula/macro will need to incorporate it)