Search results

Getting the same error, could you help please?

thank you so so much!!!!!!!!!!!!!!!!!!! i almost spent 2 hours on google to find the solution :-)

Hello Experts, I want to bring the value from sheet two both vendor name and vendor number to sheet 1, but Voolup is not working. I would highly appreciate if someone can help me with this error and report. Regards, Nitika Manhas

Thank you Mr.Ninja for a easy solution:) it worked[

Everyweek I run this Query and thank you for this!!!!

Hello to all the experts, I have attached the file for more clarity. Please look at the file to follow my question- I have some duplicate item numbers in the sheet; I only want to keep the items with lower qty on hand. For example, Item number 100-00373 is listed twice (row 5 and 6)...

Thank you so much! you are amazing :-)

Thank you SO MUCH Mr.Ninja!!! it was very simple solution, thank you again!

Hello G, Thank you for the solution, I did not see any formulas in the sheet, could you please elaborate point 1 and 2?

I am sorry , I think I fail to explain it properly :-( I will try again... If I am applying filter to column S(based on color) to pick the highlighted cells than I am missing cells x4,x26,x27 and x28 if I apply filter to Column X(based on color) than I miss S13,S15, S17,S18,S21,S22... I don't...

thank you! Do you apply the if formula based on the cell color?

Hello, I applied conditional formatting on column S and Column X. I want to select all the value highlighted as Red in both the columns. How can I achieve it? For example, if I am applying a filter on column S based on the color red, then I am missingthe value in column X. Don't know how to...

I would really appreciate if someone can help me with this inquiry as I have to do this task every week and looking for some easy way. I have attached the excel (sample). Attached sheet has only 2 sheets for example, but the original file has over 35- 40 sheets, how can i combine this...

I would really appreciate if someone can help me with this inquiry as I have to do this task every week and looking for some easy way. I have attached the excel (sample). Attached sheet has only 2 sheets for example, but the original file has over 35- 40 sheets, how can i combine this...

Hello

Hello, I would really appreciate if someone can help me with this inquiry as I have to do this task every week and looking for some easy way. I have attached the excel (sample). Attached sheet has only 2 sheets for example, but the original file has over 35- 40 sheets. I have highlighted the...

Thank you!! got it :)

Hello Belleke, It works, could you please provide me details how did you do it? Thank you, Nitika Manhas

opps Sorry :p

Hello All, Attached excel sheet has the form I have created with option button, please look at row number 18, 19 and 20. Right now I can select only one button, but I want customers to pick multiple buttons if needed, How can I achieve it? Thank you in advance! Regards, Nitika

Thank you sooooo much, it worked!!! :-) you are amazing!!

I am sorry for creating this confusion and adding different names in the format, i don't mind it to be same. Could you please provide me solution for a scenario in which header of my template is same as Sheet 1 data. I am sorry again for not providing this information in my initial post!

I want to arrange the content in a table format- How can I achieve it when I have 500 records in weird format? . Attached is excel sheet for reference to show the format of current records.

I got it, Thank you ! It was easy with Pivot :-)

I want to add the freight charges to the total order Price For example in picture below, the total price for the order A107287 is $28084.558, and Total Freight for this order is $569.11, (but it is showing repetitive), How can I add one time $567 to the total Order. Also, some orders have...