Hello,
I am seeking some help with a formula based on the inputs in the sample below. The "SHOPIFY IMAGE DATA" sheet data remains in sequential order when imported... S4,S5,S6,S7 etc. However the reference for sheet "SHOPIFY PRODUCT TITLE" only changes reference every 12 rows... S4,S16,S28...
I have a tab labeled "Header" where I'd like to insert a button to "Clear Form" and run the macro to clear the contents of multiple cell ranges on multiple sheets. Sheet names are Line1, Line2, Line3, Line4, Line5. Cell ranges to be deleted from each of the 5 sheets is the same. Can I clear...
1st I am trying to setup a POS System
2nd I want to create a searchable database. What I'm trying to do is create a search box in which text can be entered so that all cell with that text is listed on sheet 1 with the data from the specified column
What I want to be able to do is;
1. Enter info...
I have three sheets (Sheet1, Sheet2 and Sheet3). The data in these three sheets is identical upto 5 columns. the data in the first row is same as the data in first row of 2nd and 3 rd sheet and so on . That means all row and columns are identical upto 5th column.
The data in these sheets...
Hi
Please I need some expert help
I have 2 sheets Sheet1 and Sheet2
I need to copy the value of a cell in Column E and have it paste into a data filter in Sheet 2 cell A5
It then needs to copy whatever the returned value in column B and whatever the row is dependent on where the value was...
I have a work book that I'm trying to use to store supplier prices for 1-15 products over certain postal codes 1-99999999? currently set out like table below
The postcodes are in the B column from 35 down, the products are in 34 C across currently stopping at L but possibly more to be added
PAGE...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.