Im wondering if anybody could help?
I have a worksheet named Format sheet & when a button is clicked one of the jobs i want it to do is copy cells F11:F82 and paste to the next empty column in a table on worksheet 'quarterly report' but im struggling - ive had code working however it pasted the data to the next empty column after the table which is a problem just wondering if anyone could help with this?
Also, ive got a dashboard sheet and i was wondering if anyone could offer any ideas to me for this? I would like to display the data from the QR table as graphs which i think will be simple once i have the above problem fixed as i can make a graph with the data thats being populated in the table. But i was just wondering if theres a way to search for a term across the workbook as i've looked and countif only works for the worksheet its on
I have a worksheet named Format sheet & when a button is clicked one of the jobs i want it to do is copy cells F11:F82 and paste to the next empty column in a table on worksheet 'quarterly report' but im struggling - ive had code working however it pasted the data to the next empty column after the table which is a problem just wondering if anyone could help with this?
Also, ive got a dashboard sheet and i was wondering if anyone could offer any ideas to me for this? I would like to display the data from the QR table as graphs which i think will be simple once i have the above problem fixed as i can make a graph with the data thats being populated in the table. But i was just wondering if theres a way to search for a term across the workbook as i've looked and countif only works for the worksheet its on
